Wordle with Excel Solver

[tauqeeracma]

Amid the plenty of solutions and techniques that are coming for the newly viral word-puzzle game Wordle. I have also tried to make an excel-based solution for the puzzle. Because, being an excel enthusiast, I believe that Excel provides more flexibility and customization power than other analytical and problem-solving tools.

The primary aim of sharing the solution with the respected members of this excellent community is to have different logic and alternative solving approaches that would surely provide some learning opportunities. The element of interest for the members is to model an approach that would produce more close and accurate guesses.

For this solver, I have got inspiration from Mr. Robert Gascon, who occasionally demonstrates excellent features of traditional excel. Therefore the solver is a non-VBA / non-CSE model and does not require the 365 version of Excel. Thoughtful comments, especially from Mr. Robert Gascon @Twifoo  and Mr. Sergei Baklan @SergeiBaklan about alternate solving approaches will be valuable.

The solution of two real games along with the solution strategy is also attached for reference purposes.

Thanks

Tauqeer

[#2]

@tauqeeracma you sir are a genius! I think many people will find this helpful for the highly popular game, Wordle.

[#3]

Thanks for your comments.

[#4]

Sitting in comp sci amazed at this

[#5]

@tauqeeracma  First, very impressive and cool !!

In the attached I did 2 small ideas:

a) for the suggested word I decreased the point value for words with repeated letters to increase chance of suggested words not having repeated letters.  In example 1 it makes improvements.

b) for input I created a new option for word input: a) type whole word and then B) type hint letters as capital for correct location and lower case for correct but in wrong location.  I just thought this might be an easier input idea.

When I have time I might look at other parts too.  Should we look at how this project would look using dynamic array functions?

[#6]

Thanks a lot.

[#7]

Hi @mtarler 

Many thanks for your appreciation.

a) Yes, I checked about this change, it reduces the words having repeated letters and resultantly improve the list of suggested word. Great!
b) I agree with your input suggestion. It will certainly bring ease to the user.

Surely, it would be a wonderful idea to make the solver using dynamic array functions. It will mainly help in simplifying the guessing approach.

Regards

Tauqeer

[#8]

Excellent logical spreadsheet for Wordle. I sometimes used
https://tryhardguides.com/wordle-solver/

[#9]

Thanks for your comments.

[#10]

Hey @tauqeeracma,

                    I just wanted to say how awesome your Wordle game using Excel Solver is! It's amazing how you turned something like Excel, which most people use for work stuff, into a fun and clever game. It really shows how creative and skilled you are, thinking of a unique way to mix problem-solving and gaming.

Huge respect for your effort—it’s not every day you see someone come up with something like this! I’m sure it’s inspiring to a lot of people, and I can't wait to see what other cool projects you come up with next. I was playing this game on Wordle Unlimited.

[#11]

Hi @John_lodu,

Thank you so much for your kind words! I really appreciate it. I'm glad to hear you enjoyed the Excel Solver Wordle game—it's been a fun project to work on. It’s great to know that something as simple as Excel can be used in creative ways, and I'm happy that it resonated with you.

Your encouragement means a lot, and it definitely motivates me to keep experimenting with new ideas.

I always consider myself a learner and try to follow the other experts and respected members on this wonderful platform. In the meantime, feel free to check out my two other Excel projects—I’m sure you’ll enjoy them as well.

Thanks again for your support!

>>>> Spelling Bee Puzzle
>>>> An Excel-Based Game