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

195 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
chetahs1534707(None) 
cheetahs1643781cheetahs
chetah14399581chetah_
cheths14389821chet_hs
chalahs15289882chalahs
cheaps134613682che_aps
cheats114519542che_ats
cheetah1545452cheetah_
chelas113817202chela_s
cheth135013822chet_h_
heaths126316382_heaths
heths116317782_het_hs
khedahs1852952khedahs
kheths16495972khet_hs
sheaths1358752sheaths
thetas93011572theta_s
acetals93411353acetals
betas75528763_beta_s
beths105519223_bet_hs
breaths124411183breaths
caesars9410733caesars
caftans12179443caftans
cantals93919573cantals
captans111612053captans
casbahs1436463casbahs
cedars93312833c_edars
centals94317053centals
centas85020703centa_s
cestas85018543cesta_s
cetane8315283c_etane
cetanes9315133c_etanes
cetes75731103c_et_es
chadars1338293chadars
chads116122233ch__ads
chaeta11310683chaeta__
chaetae1238603chaeta_e
chaetal1238283chaeta_l
chais107530313ch__ais
chalah143511663chalah_
chalehs15268803chalehs
challahs16377563challahs
chams126028503ch__ams
chaos105622863ch__aos
chaps125326063ch__aps
charas114223613chara_s
chars105936643ch__ars
chateaus1346013chateaus
chats105730093ch__ats
chaws135022463ch__aws
chays135319743ch__ays
chazans21268123chazans
cheap126915943che_a_p
cheapo134810083che_apo
cheapos14418513cheapos
cheat105732453che_a_t
cheated134416343cheated
cheater124816963cheater
cheaters133613513cheaters
chebecs1635013chebecs
checks174912703che_cks
cheddars15234383cheddars
cheders134512393cheders
cheeks154712783che_eks
cheeps135312913che_eps
cheeros123711633cheeros
cheers114518913che_ers
cheeses123613103cheeses
chefs136214663che__fs
chegoes1337333chegoes
chela103916803chela__
chelae113614603chela_e
chelate122914893chelate
chelates132713843chelates
chemics16349583chemics
chemos13311723che_mos
cheques2136863cheques
cherish15310463cherish
cherts115617233che_rts
cherubs1434553cherubs
chess105016923che__ss
chesses124112633chesses
chests114916263che_sts
chetrum1445343chetrum
chetrums1543913chetrums
chevies153511443chevies
chevres15379793chevres
chewers154111143chewers
chews135418513che__ws
chias104625523ch_ia_s
chiaus113611313ch_iaus
chicas135916473chica_s
chigetais1543703chigetais
chimars144010593chimars
chinas115119403china_s
chital114313883chita_l
chitins122713793chitins
chitons122611913chitons
chits105424573chit__s
cholas114818003chola_s
chorals124614113chorals
chotts113610993chot_ts
choughs16576633choughs
chuddahs18222583chuddahs
chufas14397673chufa_s
chukars1634283chukars
chuppahs2042073chuppahs
chutes114615773chut_es
chutzpahs2851093chutzpahs
cleans85817053cle_ans
clears84116563cle_ars
cleats84919313cle_ats
cloths115512483clot_hs
coevals1237883coevals
coheads13289233cohe_ads
coprahs14338153coprahs
costars94218013costars
cotans81317923c_otans
cottars94412243cottars
cottas84615573cotta_s
couths115715413cout_hs
creaks124315963cre_aks
creams104715253cre_ams
creates95225203creates
cretics112911653cretics
cretins93216423cretins
crwths1433433crwt_hs
cuestas957933cuesta_s
curtals93111623curtals
deaths105914443_deaths
etas46432273__eta_s
eths76619523__et_hs
fetas85624403_feta_s
gerahs1039413_gerahs
getas65421483_geta_s
ghettos1134473ghettos
hahs108333363_h__ahs
heads95127113_he_ads
heals85733463_he_als
heaps105223223_he_aps
hears86737373_he_ars
heath115724283_heath_
heathy156111213_heathy
heats85838403_he_ats
hehs106723963_he__hs
heptads1335873_heptads
heth107028023_het_h_
hetmans12187593_hetmans
hets75547203_het__s
heuchs14447923_heuchs
heughs13516903_heughs
hexads17468203_hexads
horahs126313873_horahs
khedah1743643khedah_
khedas1446313kheda_s
kheth15509753khet_h_
khets124913433khet__s
lotahs9479873_lotahs
metals84520893_metals
meths105320233_met_hs
obeahs1135863obe_ahs
petals84719813_petals
pietas84516503pieta_s
retags73414303_retags
rheas84816953rhe_a_s
rhetors1038513rhetors
schemas1468163schema_s
selahs9313213_selahs
shahs115919513sh__ahs
sheafs124912883she_afs
sheals94420643she_als
shears93820903she_ars
sheas86331793she_a_s
sheath12412893sheath_
sheathe1348993sheathe
sheathes14610193sheathes
sheikhs17233993sheikhs
sheitans1155603sheitans
sheltas10279673shelta_s
sheuchs15234933sheuchs
sheughs14264533sheughs
shibahs15275643shibahs
shittahs14114103shittahs
shivahs16375723shivahs
teths85418513_tet_hs
thenars10248523thenars
theta83414573theta__
wheals124512523whe_als
wheats125013223whe_ats
whenas124610463whena_s
whets115019613whet__s
whidahs1743333whidahs
whydahs2041883whydahs
wreaths13338373wreaths
yeahs115214553_ye_ahs
zetas145018163_zeta_s

Search took 9 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.466383457.1
2DLD Change Limit1340271957.53317792.0
3Display Results1951950.0603250.0
 (SQL Overall)1786911958.05922172.9
 
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.