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.<\/p>\n

For a great Wordle Analysis from Laurent Lessard: https:\/\/laurentlessard.com\/solving-wordle\/<\/a><\/p>\n

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

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<\/p>\n","protected":false},"author":3,"featured_media":3365,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[21,142,138],"tags":[],"jetpack_featured_media_url":"https:\/\/i0.wp.com\/bonbonsguide.com\/wp\/wp-content\/uploads\/2022\/02\/0UsttMlOuQ4.jpg?fit=1280%2C720&ssl=1","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7QB1z-Sf","_links":{"self":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/3363"}],"collection":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/comments?post=3363"}],"version-history":[{"count":0,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/posts\/3363\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media\/3365"}],"wp:attachment":[{"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/media?parent=3363"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/categories?post=3363"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bonbonsguide.com\/wp\/wp-json\/wp\/v2\/tags?post=3363"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}