Wordle Analytics - dbt

Wordle is a fun game, but I couldn't resist knowing what a great first / second word choice would be. As an experiment, we are integrating the views with dbt to see if it is faster.

Best first word

This is better than our original best first word, because it only takes into account the actual answers that are available, and uses a better strategy

SQL

https://github.com/AutoIDM/wordle/blob/main/actual_best_first_word.sql

guess	sum	avg	stddev	max	min
roate	4594	1.9844492440604752	1.0355479830658308	5	0
oater	4594	1.9844492440604752	1.0355479830658308	5	0
orate	4594	1.9844492440604752	1.0355479830658308	5	0
realo	4584	1.9801295896328294	1.0105506429868332	5	0
alert	4559	1.9693304535637149	1.0694998512424874	5	0
alter	4559	1.9693304535637149	1.0694998512424874	5	0
taler	4559	1.9693304535637149	1.0694998512424874	5	0
later	4559	1.9693304535637149	1.0694998512424874	5	0
artel	4559	1.9693304535637149	1.0694998512424874	5	0
ratel	4559	1.9693304535637149	1.0694998512424874	5	0
arose	4534	1.9585313174946004	1.0107501271667612	5	0
soare	4534	1.9585313174946004	1.0107501271667612	5	0
aeros	4534	1.9585313174946004	1.0107501271667612	5	0
retia	4511	1.9485961123110151	1.0308304749950321	5	0

Results

Most used letters

Letter	Count
s	6665
e	6662
a	5990
o	4438
r	4158
i	3759
l	3371
t	3295
n	2952
u	2511

Best first word by word matches

sql: https://github.com/AutoIDM/wordle/blob/main/best_first_word_by_word_matches.sql

Results

matcher_strategy	word	words matched	total_word_count
oneletter_matcher	toeas	12417	12972
oneletter_matcher	stoae	12417	12972
oneletter_matcher	aloes	12412	12972
oneletter_matcher	aeons	12407	12972
oneletter_matcher	soare	12395	12972
twoletter_matcher	rales	5995	12972
twoletter_matcher	laers	5995	12972
twoletter_matcher	lears	5995	12972
twoletter_matcher	earls	5995	12972
twoletter_matcher	laser	5995	12972
threeletter_matcher	stear	1724	12972
threeletter_matcher	resat	1724	12972
threeletter_matcher	aster	1724	12972
threeletter_matcher	rates	1724	12972
threeletter_matcher	reast	1724	12972
fourletter_matcher	stear	541	12972
fourletter_matcher	resat	541	12972
fourletter_matcher	rates	541	12972
fourletter_matcher	aster	541	12972
fourletter_matcher	reast	541	12972
fiveletter_matcher	stear	111	12972
fiveletter_matcher	resat	111	12972
fiveletter_matcher	aster	111	12972
fiveletter_matcher	rates	111	12972
fiveletter_matcher	reast	111	12972

Best first word

-- Best first word to use

select * from public.wordle
where 
word like ('%s%')
and
word like ('%e%')
and
word like ('%a%')
and
word like ('%o%')
and
word like ('%r%')

Results

1. arose
2. aeros
3. soare

Best second word

--If no matches on the first word, best second word
select * from public.wordle
where 
word like ('%i%')
and
word like ('%l%')
and
word like ('%t%')
and
word like ('%n%')
and
word like ('%u%')

Results

1. unlit
2. until

Run analytics yourself

1. Setup postgres ( podman run -e POSTGRES_PASSWORD=postgres -p 5432:5432 -h postgres -d postgres )
2. Run Initial Setup
3. Run Most Used Letter
4. Have fun!