Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “redhead” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

220 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
redhead125705(None) 
redheads1336171redheads
behead1239922be_head
deadhead1444432deadhead
godhead1334762godhead
recheat12415932recheat
redded94019552redde_d
redear73515172red_ear
reded74829122red_e_d
redheaded1545082redheaded
redream10107912redream
redyed114611242redye_d
rehear93713222re_hear
reheard11309022re_heard
reheat94423942re_heat
replead10399012replead
reread71715432re_read
rethread1245352rethread
retread849002retread
acidhead1542793acidhead
ahead96817053__ahead
airhead1136993airhead
baldhead1544273baldhead
barehead1446603bare_head
bedded115114073bedde_d
bedstead1253403bedstead
beheads1338523be_heads
beheld1236413be_held
bestead10389113bestead
bighead14126653bighead
bowhead1636433bowhead
cathead1338753cathead
ceded96118563ced_e_d
cepheid1545433cepheid
cohead123811123_cohead
dead65434243__d_ead
deadheads1544023deadheads
delead84112343de_lead
dread74419023__dread
dredged11346893dredge_d
drophead1544613drophead
drumhead1542653drumhead
eched116919223_eche_d
edged85514533_edge_d
egghead1343433egghead
ennead736253_ennead
fathead1437863fathead
forehead1537893fore_head
freshed143312593freshe_d
gearhead1344433gearhead
godheads1443983godheads
greenhead1443163greenhead
hardhead1645883hardhead
head87137173___head
hedged125211813hedge_d
hophead16337923hophead
hothead14349293hothead
jarhead1835173jarhead
jehad1637683je_h_ad
jetbead1742983jetbead
jughead1933643jughead
kedged13439753kedge_d
leched123716003leche_d
lethean1037093lethean
meathead1436793meathead
mediad104313713med_iad
meshed124415933meshe_d
overhead152110363overhead
peched144915343peche_d
pinhead13347073pinhead
pithead13419593pithead
pothead133810393pothead
preheat12413893pre_heat
radded94716493radde_d
railhead1244183railhead
reached134619083reache_d
read55942533r___ead
readded103310733readde_d
readied93316623readie_d
reamed94326123reame_d
reaped94122453reape_d
reared75930013reare_d
reaved104523923reave_d
reblend1036653reblend
rebred95816353rebre_d
rebreed104611073rebreed
recheats1339193recheats
recheck1835613recheck
rechew14310213reche_w
rechewed1735633rechewed
rechews1537293rechews
recked134821803recke_d
reclad9311873re_clad
reclean938523reclean
redan66125013red__an
redated93120923redated
redbay1238333red_bay
redbird1155263redbird
redbud10135803red_bud
redcap1158493red_cap
redcoat10410883redcoat
redd66323173red___d
redden83613623redde_n
reddened1136423reddened
reddens9259783reddens
redder83918143redde_r
redders93615343redders
reddest9311953reddest
reddled102912323reddled
rede55037673red_e__
redears82814453red_ears
redeem9311533red_eem
redeemed1235593redeemed
redeems1037163redeems
redefeat1246313redefeat
redefy13388763red_efy
redemand1245923redemand
redeny102712733red_eny
redes65139133red_e_s
redeye103811793red_eye
redia65524483red_ia_
rediae74221993red_iae
redial74923113red_ial
redias74523603red_ias
redid74922393red__id
redleg839273redle_g
redlegs936823redlegs
redneck1445113redneck
redness82012443redness
redoes74623773redoe_s
redound968173redound
redowa1038453redowa_
redowas1138393redowas
redraw10269853red_raw
redreamed1345023redreamed
redreams1195953redreams
redreamt11127183redreamt
redress82511873redress
redrew10309513redre_w
redried93714893redried
reduced11610323reduced
redwood1236523redwood
redye94413473redye__
redyes104214093redye_s
reed55549623re__e_d
reeded84022563reede_d
reefed103816583reefe_d
reeked113717643reeke_d
reeled74725533reele_d
reeved104118713reeve_d
refed93921923re_fe_d
refeed104717623re_feed
reffed134712513reffe_d
regear73512743re_gear
rehab10312443re_h_ab
rehears103312773re_hears
reheated122415003re_heated
reheats104513523re_heats
reheel93610823re_heel
rehem103815353re_he_m
rehems113410983re_hems
reined74425523reine_d
reived104518133reive_d
relend76116453re_lend
relied74926233relie_d
reload7413893re_load
remend95216553re_mend
rended84524103rende_d
rented74426593rente_d
repeal84718283re_peal
repeat85127213re_peat
repleads11357213repleads
repled93319783reple_d
repped114616723reppe_d
rereads81512293re_reads
reseal64819643re_seal
reseat64131493re_seat
reseau64216213re_seau
reseda739703re_seda
reseed74823293re_seed
resend75016773re_send
reshes94124363reshe_s
reshod103012233resh_od
reshoed112212153reshoed
respeak1335933respeak
respread1135433respread
rested74430783reste_d
retched133814273retche_d
reteam83214533re_team
retear63115483re_tear
rethreads1344483rethreads
retied75924983retie_d
retreads937823retreads
retreat7317533retreat
retted74826313rette_d
reused75419563reuse_d
reveal94115053re_veal
revved13469723revve_d
rewear93012003re_wear
rewed95425453re_we_d
reweld103711113re_weld
rhea75017433r__hea_
rheas84816953r__heas
ridded93615123ridde_d
ridged94014223ridge_d
riverhead1642993riverhead
rodded93713703rodde_d
ruched124314633ruche_d
rushed104419863rushe_d
saphead1357773saphead
sorehead1246973sore_head
subhead1387693subhead
teched124014433teche_d
tedded93810903tedde_d
towhead1435223towhead
undead82711903und_ead
warhead1436603warhead
wedded123811843wedde_d
wedged125110303wedge_d
wellhead1543503wellhead

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911340270.390458182.1
2DLD Change Limit1340272206.68620045.9
3Display Results2202200.0802750.0
 (SQL Overall)1786912207.15624970.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.