Wordle Hint - 5 Letter Words for Wordle

Use this tool to improve your Wordle game. Enter letters below to see a possible list of words. Most frequent 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 at Correct Position
12345

Letters also in Word but at Wrong Position
PosLetters
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%
S15.81A13.13A13.26E13.74E18.32
C8.55O12.05I11.49N7.86Y15.72
B7.47R11.53O10.54S7.39T10.93
T6.44E10.45E7.65A7.04R9.16
P6.13I8.73U7.13L7.00L6.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;