Rebuilding and analysing 4 years of Wordle stats from WhatsApp chat logs

a day ago

The author rebuilt and analyzed 4 years of Wordle stats from WhatsApp chat logs because Wordle's own stats lack per-game history and detailed analysis.
WhatsApp exports provided detailed data including puzzle number, date, guess count, and win/loss, which was parsed with a Python script to create a CSV dataset.
The analysis covered 1,552 games starting from puzzle #214 in January 2022, with a 99.42% win rate and a peak guess distribution at 4 guesses (590 games).
The longest streak was 278 days (Nov 2024 to Aug 2025), ending on a missed day rather than a loss, and independent analysis confirmed Wordle's streak numbers.
Opening guesses with at least one green tile averaged 3.79 guesses vs 4.11 for blank openers, and most games (79%) were shared between 6-8 am, reflecting daily routines.
Monthly average guesses crept up from 3.7-3.8 in 2022 to 4.0-4.5 by 2025, likely due to harder words being used first in Wordle's original list.
Nine losses occurred over four years (e.g., fewer, hound, scarf), with no consistent pattern, and the author noted that losses didn't negatively impact the next game's performance.

Author created a Chrome extension to detect potential cheaters on chess.com by analyzing opponent stats.
Cheating is widespread, especially at higher ratings (2200 rapid, 1900 blitz), with 3/5 rapid opponents suspected.
Extension computes a risk score (0-100) based on winrate, account age, and high-accuracy game percentage.

Nerdle is a math-based version of Wordle, where players guess a daily equation.
It was created by Richard Mann and his children during a traffic jam in January 2022.
The game features an 8-digit puzzle with operators and numbers, providing logical deduction challenges.

The author created an animation of Dutch COVID-19 figures using the 'date of onset' field to reduce the impact of testing delays.
The data uses 7-day smoothed daily positive test numbers to effectively remove weekend effects.
Week-on-week growth was 60% at the end of September, after which the daily growth rate dropped.

In 2017, a team implemented Tetris as a Game of Life simulation using a 30 trillion pixel grid and a programmable CPU.
Leap seconds, used to sync UTC with Earth's rotation, are set to be abolished by 2035, allowing drift between the two.
The backslash character scarcely existed before 1930 and was added to ASCII for mathematical notation, becoming a key due to its uselessness.

Hilo is a daily 7-letter word puzzle where players guess the word in 5 tries.
After each guess, a range bar shows possible letters for each position, narrowing down options.
The game focuses on logical deduction and alphabetical reasoning rather than vocabulary knowledge.

Hasty Briefsbeta