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 “afield” 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.

337 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
afield103595(None) 
field95015321_field
ailed66240282a_iled
airfield1243142airfield
ariel55228972ariel_
ariels65119372ariels
ariled75620322ariled
bield84614652_bield
canfield1444332canfield
chield124610212chield
failed105421602failed
fields104211042_fields
fiend95312982_fiend
filed95331902_filed
fjeld16465582_fjeld
hayfield18102072hayfield
infield1135822infield
shield106212972shield
upfield1343032upfield
wield95213912_wield
yield9519692_yield
aahed917816443aahe_d
abed79734133a_be_d
abele76323253a_bele
abided105313313abided
abled86926833able_d
aced79540883a_ce_d
ached119227833ache_d
acid77533393aci__d
acidly125211793acidly
acned87520673acne_d
acold86214933a_cold
acred87126353acre_d
acted88521733acte_d
added84918433adde_d
addend9458453addend
addled94112523addled
adieu6417423adie_u
adieus739633adieus
adieux1444283adieux
adzed166012543adze_d
aeried74221863aerie_d
afeard1058263afeard
affect1448903affect
affined1436413affined
affinely1743863affinely
affixed2134123affixed
afford1346493afford
afire86215913afi_re
afoul8510193afoul_
afraid1049723afraid
afreet9315153afreet
afresh1255503afresh
after85719793afte_r
afters94717073afters
aged67334253a_ge_d
agile65122263agi_le
agilely1135123agilely
agreed84712503agreed
ahead96817053a_head
ahed89536253a_he_d
ahold94714253a_hold
aid49269083a_i__d
aided75828933a_ided
ail37171043a_i_l_
ails45654713a_i_ls
aimed85626053a_imed
aioli5318313a_ioli
aired66032923a_ired
airfields1342203airfields
aisle55223193a_isle
aisled74516183a_isled
akela9311343a_kela
alible8311973alible
alidad838883alidad
alien56425583alie_n
aliened81011743aliened
alienly1037503alienly
aliens65619213aliens
alined75221403alined
aliped95414283aliped
allele64514563allele
allied74217153allie_d
ambled115116373ambled
amend85717753a_mend
amid77036353ami__d
amie66339853amie__
amies76837693amie_s
amped104820513ampe_d
anele55628833a_nele
aneled74719283a_neled
angel65019563angel_
angeled93211513angeled
angels74416173angels
angled84219093angled
anil46437433ani_l_
anile54634463ani_le
anils56326723ani_ls
aniseed839403aniseed
ankled114313483ankled
annelid838733annelid
anted66328243ante_d
anteed75616113anteed
anviled1138953anviled
aped78538153a_pe_d
apiece10510083apiece
appel94615893appel_
appels104312793appels
append1138273append
arced88224163arce_d
argled85314553argled
arid57642713ari__d
aridly105513703aridly
aril45843023ari_l_
arils58732203ari_ls
armed86324433arme_d
artel56122743artel_
artels66216233artels
ascend9429733ascend
ashed97829773ashe_d
asked106919313aske_d
atilt54828473ati_lt
attend7258973attend
augend837633augend
auld54125363a__uld
availed1135973availed
avid88325963avi__d
avidly13548783avidly
awed88436033a_we_d
awned96615953awne_d
axed128829613a_xe_d
axel115222073a_xel_
axels126313633a_xels
axial124515193axial_
axil116424453axi_l_
axile126020513axi_le
axilla13289573axilla
axils127217503axi_ls
axised14438963axised
axled135315813axle_d
axseed1456993axseed
babied114913513babie_d
backfield2143383backfield
baffed154812173baffe_d
baffled16418063baffled
bailed94726653bailed
beheld1236413beheld
bields94110003_bields
bifold1237223bifold
boiled95020953boiled
build84413353bui_ld
canfields1542833canfields
caried94528693carie_d
caviled1348723caviled
ceiled94114953ceiled
chiel104918973chiel_
chields13507483chields
chiels115115933chiels
child114516223chi_ld
coalfield1541823coalfield
coiled95123943coiled
cried84624283crie_d
daffed14429493daffe_d
defied115016383defie_d
defiled124013103defiled
died66137853_die_d
diel59034603_diel_
doiled84817293doiled
dried75321383drie_d
eld46733793___eld
exiled144712463exiled
fabled124216383fabled
faced117727653face_d
faciend1334803faciend
faded105025243fade_d
fail74840243fai_l_
faille93414743faille
fails85631483fai_ls
faired105915773faired
fairly125610013fairly
faked135225483fake_d
famed115928343fame_d
fared95842343fare_d
fated95632133fate_d
fauld95214493_fauld
favela1237033favela
faxed166220533faxe_d
fayed126422153faye_d
fazed186222963faze_d
fed76548353_f_e_d
feed84538903_f_eed
feel75233843_feel_
feels85223043_feels
felid94717173_f_elid
fell76833073_f_ell
felt75146933_f_elt
fend84832973_f_end
feod815523003_f_eod
feud86523023_f_eud
fid76847693_fi__d
fie67152443_fie__
fief107331363_fie_f
fiefs116213703_fiefs
fielded12206813_fielded
fielder11217413_fielder
fiends104110293_fiends
fiery114714793_fiery
fifed125115973_fifed
fil65447143_fi_l_
fila74729133_fi_la
file75446643_fi_le
filer85433003_filer
files85441273_files
filet85540163_filet
fill75540193_fi_ll
fille84327403_fille
filled104922263_filled
fillo84319783_fillo
fills84632373_fills
filly114424903_filly
film94828173_fi_lm
filo76034283_fi_lo
fils75838693_fi_ls
find87532603_fi_nd
fined94930503_fined
finely123011563_finely
fiord94313343_fiord
fired94829743_fired
fitly115114973_fitly
fixed165416953_fixed
fjelds17414473_fjelds
fled85429773_fle_d
flied96519433flie_d
foiled104618403foiled
fold86528943_f_old
freed95223543_freed
fremd115010323_fremd
fried95322913frie_d
friend10388933friend
fuel76824733_fuel_
fueled104913603_fueled
fuels87117353_fuels
gaffed144210203gaffe_d
geld65828433__geld
gied64631983_gie_d
gild65526513_gi_ld
guild75312753gui_ld
guiled84315383guiled
hafted134713833hafte_d
hailed104122743hailed
hayfields19101723hayfields
heiled104415613heiled
held85330403__held
hied85434043_hie_d
infields1244013infields
ivied94710523ivie_d
jailed144917423jailed
lazied164610653lazie_d
lied55838093_lie_d
mailed95326753mailed
meld75830473__meld
midfield15203843midfield
mild75330853_mi_ld
misfield14265913misfield
moiled94318863moiled
naffed13408333naffe_d
nailed74021493nailed
offed12359163offe_d
offend13365663offend
oiled64429473_oiled
oriel54920423oriel_
oriels64914623oriels
outfield1265253outfield
pied75035363_pie_d
piled85232993_piled
playfield1841663playfield
plied85118593plie_d
pried84426863prie_d
raffled14429083raffled
rafted104714703rafte_d
railed74727543railed
refiled114318653refiled
reweld103711113reweld
riel46432383_riel_
riels55121333_riels
rifely123710033rifely
rifled104115003rifled
riled65833253_riled
roiled74320053roiled
safely12249393saf_ely
sailed74327763sailed
samiel8313333samiel_
samiels939763samiels
shied96125493shie_d
shiel811023773shiel_
shields11538043shields
shiels95418923shiels
sild55030583_si_ld
skied104417753skie_d
smiled93716433smiled
soiled73822473soiled
spied85427713spie_d
spiel74623913spiel_
spieled104811883spieled
spiels85317953spiels
spiled94621993spiled
stied65723033stie_d
subfield1444753subfield
tailed74424663tailed
taxied14509373taxie_d
tied55535213_tie_d
tiled64832943_tiled
toiled74420323toiled
tried65026913trie_d
upheld12115563upheld
vailed104619293vailed
varied104817863varie_d
veiled103714543veiled
veld85323203__veld
vied86328633_vie_d
waffed16459793waffe_d
waffled17357523waffled
wafted134012143wafte_d
waifed134011033waife_d
wailed104823593wailed
weld84727733__weld
whiled134514133whiled
wields10469623_wields
wieldy13476183_wieldy
wifed125117743wife_d
wifely15429423wifely
wild85126513_wi_ld
wiled95231553_wiled
wried95518563wrie_d
yaffed16457323yaffe_d
yeld811423873__yeld
yields10466843_yields

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127163375.06322262.7
3Display Results3373370.1103063.6
 (SQL Overall)1786913375.56332121.3
 
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.