Enter letters below to see possible list of words. Most used 20 letters: e,a,r,o,t,l,i,s,n,c,u,y,d,h,p,m,g,b,f,k
Letters in word by correct position
1
2
3
4
5
Letters also in word but in wrong position
Pos
Letters -
1
2
3
4
5
Letters NOT in word (Grey)
Words Found
.txt
5 Most Used Letters by Position
Pos 1
%
2
%
3
%
4
%
5
%
S
15.81
A
13.13
A
13.26
E
13.74
E
18.32
C
8.55
O
12.05
I
11.49
N
7.86
Y
15.72
B
7.47
R
11.53
O
10.54
S
7.39
T
10.93
T
6.44
E
10.45
E
7.65
A
7.04
R
9.16
P
6.13
I
8.73
U
7.13
L
7.00
L
6.74
SQL Query
This SQL statement will determine good starting words ranked from best to least.
WITH letter_frequencies AS (
SELECT letter, COUNT(*) as frequency
FROM (
SELECT SUBSTR(word, 1, 1) as letter FROM answers wordle
UNION ALL
SELECT SUBSTR(word, 2, 1) FROM answers
UNION ALL
SELECT SUBSTR(word, 3, 1) FROM answers
UNION ALL
SELECT SUBSTR(word, 4, 1) FROM answers
UNION ALL
SELECT SUBSTR(word, 5, 1) FROM answers
)
GROUP BY letter
),
word_scores AS (
SELECT
w.word,lf.frequency, COALESCE(lf2.frequency,0)frequency2, COALESCE(lf3.frequency,0)frequency3, COALESCE(lf4.frequency,0)frequency4, COALESCE(lf5.frequency,0)frequency5,
lf.frequency + COALESCE(lf2.frequency,30) + COALESCE(lf3.frequency,30) + COALESCE(lf4.frequency,30) + COALESCE(lf5.frequency,30) AS score
FROM
answers w
JOIN letter_frequencies lf ON SUBSTR(w.word, 1, 1) = lf.letter
LEFT JOIN letter_frequencies lf2 ON SUBSTR(w.word, 2, 1) = lf2.letter and SUBSTR(w.word, 2, 1) NOT IN (SUBSTR(w.word, 1, 1))
LEFT JOIN letter_frequencies lf3 ON SUBSTR(w.word, 3, 1) = lf3.letter and SUBSTR(w.word, 3, 1) NOT IN (SUBSTR(w.word, 2, 1),SUBSTR(w.word, 1, 1))
LEFT JOIN letter_frequencies lf4 ON SUBSTR(w.word, 4, 1) = lf4.letter and SUBSTR(w.word, 4, 1) NOT IN (SUBSTR(w.word, 3, 1),SUBSTR(w.word, 2, 1),SUBSTR(w.word, 1, 1))
LEFT JOIN letter_frequencies lf5 ON SUBSTR(w.word, 5, 1) = lf5.letter and SUBSTR(w.word, 5, 1) NOT IN (SUBSTR(w.word, 4, 1),SUBSTR(w.word, 3, 1),SUBSTR(w.word, 2, 1),SUBSTR(w.word, 1, 1))
)
SELECT word
FROM word_scores
ORDER BY score DESC, word;