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

157 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
caleche1429795(None) 
caleches15269941caleches
caliche14329961caliche
acalephe1552732acalephe
cache125122482ca__che
caliches153812272caliches
calicle113111432calicle
calycle14245832calycle
capuche1644432capuche
caroche1469242caroche
catechu1444472catechu
cliche133712452c_liche
cloche134312372c_loche
creche13310762c_reche
fleche14299302_fleche
acaleph1453443acaleph_
acalephae1652523acalephae
acalephes1643223acalephes
acalephs1542993acalephs
ache96829823_a__che
alec66430063_alec__
alecs76620733_alec_s
alee46652323_ale__e
aleph10311393_aleph_
alephs1136533_alephs
apache134210783_apache
babiche1644573babiche
bobeche1643843bobeche
caboched1844043caboched
cached145419203ca__ched
caches137926913ca__ches
cachet134526413ca__chet
cadelle1039923cadelle
cadence1239063cadence
caeca93915133ca_ec_a
caecal103713733ca_ecal
caecum1238183ca_ecum
calash11312433calash_
calashes13310543calashes
calathi1247593calathi
calcar10312753cal_car
calceate1239863calceate
calces104420053cal_ces
calcic9311873cal_cic
calcine11315273calcine
calcite11413783calcite
calender1138273calender
calends1039523calends
calesa8412473cale_sa
calesas9411833calesas
calibre1136603calibre
calices114321693calices
calicles123811433calicles
calico103414433calic_o
calicoes123911603calicoes
calicos113913493calicos
calipee11412913calipee
caliph13311403caliph_
caliphs1436753caliphs
callee84327293cal_lee
callose9313663callose
calorie92716903calorie
calotte9510563calotte
calque17289843cal_que
calve105919923cal__ve
calycate1537893calycate
calyces14428803calyces
calycine1546963calycine
calycles15295693calycles
calzone1848623calzone
camerae11312063camerae
cancha134411613ca_ncha
capuched1843743capuched
capuches1735513capuches
caroch13911763caroch_
caroches15710693caroches
casease939323casease
caseate9314783caseate
caseose939163caseose
caserne93710063caserne
casette9310393casette
catch125120373ca_tch_
catcher143115823ca_tcher
catches144320773ca_tches
catchy16559583ca_tchy
catechin1546813catechin
catechise1644943catechise
catechize2544473catechize
catechol1544613catechol
catechus1544823catechus
catenae9311373catenae
caulicle1245043caulicle
cayenne1244603cayenne
celeste949653celeste
ceviche1744143ceviche
chaleh143711993chale_h_
chalehs15268803chale_hs
chalice14311043chalic_e
cilice103213353cilic_e
clach124617823c_lach_
clachs133511323c_lachs
claucht1445583claucht
cleave114212513c_leave
clench133910053c_lench_
clenched16257763c_lenched
clencher15277973c_lencher
clenches152910953c_lenches
cleome1039083c_leome
clepe94617383c_le_pe
cliched153711023c_liched
cliches144213743c_liches
cloches144113713c_loches
clothe114712993c_lothe
coalesce1245423coalesce
creches14313093c_reches
culch124512833cul_ch_
culches143710743cul_ches
cultch13385953cultch_
cultches15316533cultches
daledh1133743daledh_
daledhs1232783daledhs
daleth1038633daleth_
daleths1135323daleths
earache1239333earache
eche97520283___eche
fleches153411443_fleches
galeae74717453gale_ae
galeate83916793galeate
galere73716683gale_re
galette84212703galette
galoshe1135413galoshe
ganache1346223ganache
gauche1238563ga_uche
halacha15388023halacha
lech96825443__lech_
leched123716003__leched
lecher113415853__lecher
leches115421313__leches
lechwe1435113__lechwe
lethe85717303__lethe
mache125925303ma__che
maleate94117543maleate
malice104818483malic_e
manche133515103ma_nche
palace104516923palac_e
paleae84820293pale_ae
paleate94120003paleate
palette93613983palette
panache1458433panache
panoche1456383panoche
parfleche1951913parfleche
planche14299753planche
samech13277033samech_
samechs14285353samechs
scalene9310773scale_ne
tache106222373ta__che
valence1268773valence

Search took 10 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.403443402.0
2DLD Change Limit1340271578.78315259.8
3Display Results1571570.0762065.8
 (SQL Overall)1786911579.26219292.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.