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

240 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
chields1350748(None) 
chield124610211chield_
chiels115115931chiel_s
shields11538041shields
bields94110002_bields
chelas113817202ch_elas
chicles143512502chicles
chiefs14509652chie_fs
chiel104918972chiel__
child114516222chi_ld_
childe124711212chi_lde
childes134211272chi_ldes
chiles115425302chi_les
chilis115517872chi_lis
chillis124411602chillis
chills114717702chi_lls
chimlas1437452chimlas
chisels12219102chisel_s
fields104211042_fields
shield106212972shield_
shiels95418922shiel_s
wields10469622_wields
yields10466842_yields
achieves1645523achieves
afield1035953afield_
aholds10469483ah_olds
ariels65119373ariel_s
bield84614653_bield_
builds9378493bui_lds
cahiers123510673cahie_rs
caids85226433cai__ds
cairds96411513cai_rds
calends1039523calends
camelids1356943camelids
camels105217083camel_s
canfields1542833canfields
caulds95512383c_aulds
ceiled94114953ceiled_
ceilers93912533ceilers
ceilis85413743cei_lis
ceils75019403cei_l_s
cells75428063c__ells
cels65534973c__el_s
celts75325783c__elts
chablis14368563chablis
chads116122233ch__ads
chalehs15268803chalehs
chalets122813473chalets
chalks155412143ch_alks
challas124414123challas
challis124613463challis
chapels14429153chapel_s
chards125119733ch_ards
cheaps134613683ch_eaps
cheats114519543ch_eats
checks174912703ch_ecks
cheeks154712783ch_eeks
cheeps135312913ch_eeps
cheeros123711643cheeros
cheers114518913ch_eers
cheeses123613103cheeses
chefs136214663ch_e_fs
chela103916803ch_el_a
chelae113614613ch_elae
cheloids1438033ch_eloids
chemos13311723ch_emos
cherts115617233ch_erts
chess105016923ch_e_ss
chests114916263ch_ests
cheths14389823ch_eths
chews135418513ch_e_ws
chias104625523chi__as
chiasms14357523chiasms
chiaus113611313chi_aus
chicas135916473chi_cas
chichis1737073chichis
chicks175317593chi_cks
chicle134312543chicl_e
chicly16429203chicl_y
chicos134614833chi_cos
chics123920943chi__cs
chid106626413chi__d_
chide115321023chi__de
chided135113963chided_
chiders135312943chiders
chides124620473chi_des
chief134419483chie__f
chiefdom1942483chiefdom
chiefdoms2052493chiefdoms
chiefer1536863chiefer
chiefest1645313chiefest
chiefly1834103chiefly
chigoes1338353chigoes
childish1744393chi_ldish
childly1644803chi_ldly
chile105626893chi_l_e
chili106218483chi_l_i
chiliads1445853chiliads
chilies124218303chilies
chill105619873chi_l_l
chilled133310933chilled
chiller124112183chiller
chillers133710923chillers
chillest13259593chillest
chilli114312773chi_lli
chillies134113483chillies
chillum1435443chillum
chillums1544163chillums
chilly144113223chi_lly
chimars144010593chimars
chimbs153910303chi_mbs
chimed145814833chimed_
chimeras15388833chimeras
chimeres153511313chimeres
chimers144515143chimers
chimes134922573chi_mes
chimla1337593chiml_a
chimley1785163chimley
chimleys1883633chimleys
chimps155713663chi_mps
chinas115119403chi_nas
chined125620063chined_
chines115029173chi_nes
chinks155817573chi_nks
chinless1337493chinless
chinos115018693chi_nos
chins105631463chi__ns
chints115117833chi_nts
chips125721253chi__ps
chirks155414843chi_rks
chirms135113983chi_rms
chiros114617773chi_ros
chirps135414003chi_rps
chirres123812253chirres
chirrs114514983chi_rrs
chirus114615693chi_rus
chis95933313chi___s
chisel112111943chisel__
chiseled1435883chiseled
chiseler1335903chiseler
chiselers1445453chiselers
chitins122713793chitins
chitlin12269283chitlin
chitlins13289393chitlins
chitons122611913chitons
chits105424573chi__ts
chives144317593chi_ves
chivies153412853chivies
cholas114818003ch_olas
cholers124215203cholers
chollas123811353chollas
cholos114716853ch_olos
chords125214633ch_ords
churls115411073churl_s
chyles144813283ch_yles
clients938093clients
coeds85920163c_oe_ds
coheads13289233coheads
coiled95123943coiled_
coilers93619903coilers
coils75030083coi_l_s
colds85726973c__olds
coleads102911423coleads
creds85418773c_re_ds
creeds94714773c_reeds
creels84416943creel_s
cried84624293crie_d_
criers83918583crie_rs
cries75438403crie__s
cupels10310203cupel_s
elds56324863___elds
field95015323_field_
fiends104110293_fiends
fjelds17414473_fjelds
friends11396743friends
gelds75118343__gelds
ghiblis1353343ghiblis
gilds75417533_gi_lds
guilds8388353gui_lds
heads95127113_h_eads
heeds95420423_h_eeds
heels85625533_heel_s
heils85222193_heil_s
held85330403_h_eld_
hells85032043_h_ells
helms105619463_h_elms
helos84928063_h_elos
helps105219343_h_elps
herds96424683_h_erds
hied85434053_hie_d_
hies74842843_hie__s
hillos94618893_hillos
hills85431353_hi_lls
hilts86924413_hi_lts
hilus84817643_hi_lus
hinds96721483_hi_nds
holds94623243_h_olds
infields1244013infields
melds84822383__melds
milds86422063_mi_lds
oriels64914623oriel_s
phials1158873phial_s
rewelds11457413rewelds
riels55121333_riel_s
sheds96122703sh_e_ds
sheilas1059403sheilas
shells94319523sh_ells
shends105313773sh_ends
sherds105614723sh_erds
shied96125493shie_d_
shiel811023773shiel__
shielded1334393shielded
shielder1235183shielder
shielders1334763shielders
shiers94921753shie_rs
shies86136553shie__s
shills94519613shi_lls
shreds105613053shre_ds
silds65520533_si_lds
spiels85317953spiel_s
thieves1346903thieves
thills95515383thi_lls
thiols95112763thiol_s
thirds10438603thi_rds
thirls95012063thirl_s
threads11419953threads
velds95615583__velds
welds94719163__welds
wheels123811723wheel_s
whelks16367323wh_elks
whelms14377573wh_elms
whelps14437843wh_elps
whids125413993whi__ds
whiled134514133whiled_
whiles124418013whi_les
whirls124710533whirl_s
wield95213913_wield_
wieldy13476183_wieldy
wilds94818213_wi_lds
yield9519693_yield_

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.406440125.6
2DLD Change Limit1340272406.82619634.8
3Display Results2402400.0803000.0
 (SQL Overall)1786912407.31224438.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.