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

312 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
chetah1439958(None) 
cheetah1545451cheetah
chetahs15347071chetahs
cheth135013821chet_h
chaeta11310682chaeta_
chaetae1238602chaetae
chaetal1238282chaetal
chalah143511662chalah
cheap126915942che_ap
cheat105732452che_at
cheats114519542cheats
cheetahs1643782cheetahs
chela103916802chela_
chelae113614612chelae
chelas113817202chelas
cheths14389822cheths
chital114313882chital
heath115724282_heath
heth107028022_het_h
khedah1743642khedah
kheth15509752khet_h
sheath12412892sheath
theta83414572theta_
thetas93011572thetas
aceta74017353aceta_
acetal84314903acetal
ahead96817053ahe_ad
beta66234133_beta_
betas75528763_betas
beth96629233_bet_h
breath113916263breath
caeca93915133caeca_
caecal103713733caecal
caesar8410933caesar
caftan111710123caftan
cantal84122033cantal
captan101613343captan
casbah1337903casbah
catch125120373c_atch
ceca84820783c_eca_
cecal94619113c_ecal
cedar84014323c_edar
centai84814783centai
cental84420963cental
centas85020703centas
cesta75419483cesta_
cestas85018543cestas
cetane8315283c_etane
cete64934783c_et_e
cetes75731103c_etes
chad105525503ch__ad
chadar1239353chadar
chai95929903ch__ai
chalahs15289883chalahs
chaleh143711993chaleh
challah15458323challah
cham115532313ch__am
chao95727313ch__ao
chap114928493ch__ap
char95132153ch__ar
charas114223613charas
chat95546133ch__at
chateau1236273chateau
chats105730093chat_s
chatty14419363chatty
chaw126224633ch__aw
chay124924873ch__ay
chazan20269133chazan
cheapo134810083cheapo
cheaps134613683cheaps
cheated134416343cheated
cheater124816963cheater
chebec1536963chebec
check164714713che_ck
checks174912703checks
cheddar14254733cheddar
cheder125113493cheder
cheek145115713che_ek
cheeks154712783cheeks
cheeky18448613cheeky
cheep125416503che_ep
cheeps135312913cheeps
cheer105420383che_er
cheero114712943cheero
cheers114518913cheers
cheery144913153cheery
cheese113812763cheese
cheesy14419193cheesy
chef125125623che__f
chefed155010563chefed
chefs136214663che_fs
chegoe1237273chegoe
chelate122914903chelate
chemic153012093chemic
chemo12313633che_mo
chemos13311723chemos
cheque2036663cheque
cherish15310463cherish
cherry144810763cherry
chert105232103che_rt
cherts115617233cherts
cherty144612473cherty
cherub1337263cherub
chess105016923che_ss
chest104926143che_st
chested133811673chested
chests114916263chests
chesty144610503chesty
chetrum1445343chetrum
chevre14318313chevre
chevy16479993che_vy
chew126622133che__w
chewed154415013chewed
chewer145512623chewer
chews135418513che_ws
chewy165011903che_wy
chez184519023che__z
chia96026623ch_ia_
chiao105618363ch_iao
chias104625523ch_ias
chica125818263chica_
chicas135916473chicas
chigetai1443233chigetai
chimar133911473chimar
china105022483china_
chinas115119403chinas
chinch163911243chinch
chiral114614413chiral
chit96937463chit__
chitin113114963chitin
chiton112612393chiton
chits105424573chit_s
chitty14329433chitty
chola104718033chola_
cholas114818003cholas
choral115118493choral
chott103923933chot_t
chotts113610993chotts
chough15699253chough
choush14549063choush
chuddah17263253chuddah
chufa13489113chufa_
chufas14397673chufas
chukar1534633chukar
chuppah1952453chuppah
church1636483church
chute104316463chut_e
chuted124611843chuted
chutes114615773chutes
chutzpah2751413chutzpah
clean75420413cle_an
clear76219053cle_ar
cleat76335063cle_at
cleats84919313cleats
clench133910053clench
cloth105817543clot_h
clutch13367753clutch
coeval1138893coeval
cohead123811123cohe_ad
coital84117053coital
cometh134811683comet_h
coprah133710603coprah
costa75523733costa_
costae85319683costae
costal85419513costal
costar85518613costar
cotan71521783c_otan
coteau8311083coteau
cotta75818573cotta_
cottae84615703cottae
cottar84613813cottar
cottas84615573cottas
couth106122493cout_h
cratch134110793cratch
creak115418433cre_ak
cream95721353cre_am
create85126383create
credal9311673credal
creesh11328333creesh
crestal9312133crestal
cretic102816283cretic
cretin82917913cretin
crotch133410083crotch
crutch13408243crutch
crwth1337483crwt_h
cuesta838513cuesta_
cuestas957933cuestas
cultch13385953cultch
curtal83914543curtal
cutch125116193c_utch
death94822523_death
detach12310413_detach
doeth9411983doet_h
eath75735663__eath
eta35834193__eta_
etas46432273__etas
etch95419143__etch
eth66630983__et_h
feta76528903_feta_
fetal85623373_fetal
fetas85624403_fetas
fetch134913473_fetch
fletch14388193fletch
foetal9311883foetal
gerah9315303_gerah
geta56627443_geta_
getas65421483_getas
gherao1036753gherao
ghetto1036073ghetto
hah910655223_h__ah
hatch135719593_hatch
hath105933913_hat_h
head87137173_he_ad
heal75645693_he_al
heap96432893_he_ap
hear76143883_he_ar
heat77061423_he_at
heaths126316383_heaths
heathy156111213_heathy
heats85838403_heats
heh96039623_he__h
heigh124812543_heigh
hemal104419803_hemal
heptad1237273_heptad
het67674313_het__
heths116317783_heths
hetman112510603_hetman
hets75547203_het_s
heuch135312333_heuch
heugh125410923_heugh
hexad164910623_hexad
hitch134515473_hitch
horah117922053_horah
hotch136214733_hotch
hutch135414093_hutch
hyetal1236543hyetal
ketch144912023_ketch
kheda1346533kheda_
khedahs1852953khedahs
khedas1446313khedas
khet116328623khet__
kheths16495973kheths
khets124913433khet_s
kvetch1832993kvetch
letch105215803_letch
lotah85315853_lotah
meta65932413_meta_
metal75427383_metal
meth95827843_met_h
neath86020283_neath
obeah1038993obe_ah
petal76526893_petal
pieta75421753pieta_
pietas84516503pietas
pretax152310193pretax
prutah1136583prutah
retag63618413_retag
retax124517973_retax
retch104818303_retch
rhea75017433rhe_a_
rheas84816953rhe_as
rhetor938063rhetor
rhyta1135083rhyta_
schema1388373schema_
schemas1468163schemas
selah8319613_selah
seta45637313_seta_
setae56026223_setae
setal56430903_setal
shah105627783sh__ah
shea76031573she_a_
sheaf115424123she_af
sheal84927703she_al
shear85424833she_ar
sheas86331793she_as
sheathe1348993sheathe
sheaths1358753sheaths
sheesh1237813sheesh
sheikh16206993sheikh
sheitan1036573sheitan
shelta93111793shelta_
sheltas10279673sheltas
sheuch14267043sheuch
sheugh13295883sheugh
shibah14387473shibah
shittah1385153shittah
shivah15488543shivah
sketch1535363sketch
teeth87315853teet_h
teth76327893_tet_h
thatch1435613thatch
theca103311453theca_
thecae11299653thecae
thecal113310313thecal
thenal92712433thenal
thenar92610003thenar
thetic11412893thetic
trefah1235093trefah
vetch134411843_vetch
wheal115716183whe_al
wheat114924573whe_at
wheats125013223wheats
whenas124610463whenas
whet105133783whet__
whets115019613whet_s
whidah1634803whidah
whydah1942953whydah
wreath124111193wreath
wretch14326533wretch
yeah106725413_ye_ah
zeta135121643_zeta_
zetas145018163_zetas

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.376475242.0
2DLD Change Limit1127163125.15621861.1
3Display Results3123120.1102836.4
 (SQL Overall)1786913125.64231671.6
 
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.