After my previous video showing AROSE as the best first guess in Wordle, I started doing some more cool Excel formulas to test all Wordle words. This is a long video for the weekend, mostly of me geeking out about Excel and doing 1.5 billion calculations with a $10 spreadsheet.

For a great Wordle Analysis from Laurent Lessard: https://laurentlessard.com/solving-wordle/

Table of Contents
(0:00) Introduction
(1:15) Colors in 53 formulas
(6:10) Laurent Lessard or 3Blue1Brown
(7:25) The 2315 words
(8:50) Solving for 5.3 Million with 284 MM formulas in Excel
(10:40) The 10,972 words
(11:57) 2315 x 12972 x 53 of 1.3 billion
(13:00) Wordle Universe 1.596 billion calcs
(14:25) Can be the answer?
(14:59) Count unique constellations per guess
(17:17) It is not 3^5 possible answers
(18:10) Show 10 largest using LARGE in Excel
(18:30) Using Ctrl+Right Arrow in Excel
(18:46) TRACE, CRATE, or SALET starting words
(19:38) 10 words with most constellations
(20:14) Max words in play after any guess
(20:36) COUNTIF for each in array in Excel
(21:30) What’s the most words still in play
(22:20) RAISE or ARISE for less words in play
(23:00) Is Wordle a hostile opponent?
(23:34) Solving methodology
(25:05) Filtering to find 10 words still in play
(26:00) Sheet2 for words still in play
(26:38) Evaluating the best for 2nd word
(28:45) Guessing a wrong word narrows it for the win
(29:16) Which words will minimize words in play
(30:00) Having 221 after first guess
(30:25) Using Excel Advanced Filter from another sheet
(32:05) End game strategy wins 2nd guess from now
(34:10) Increase chance of less than 100 words after first guess
(35:30) Maximize winning in 2 PARSE, CRATE, TRACE
(36:50) The worst first guesses in Wordle
(37:15) TARES, SANER, AISLE, ALONE as best words
(38:40) Over 1000 words in play after first guess
(39:10) AISLE ALONE for less than 200 words
(39:20) PARSE or CRATE or TRACE