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

109 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
cladode113461(None) 
cladodes1245321cladodes
alamode1038152alamode
cladded12356922clad_ded
clade85821012cla__de
abode85518813__abode
adobe84814713__adobe
adore65723673__adore
adoze155713833__adoze
alamodes1148013alamodes
aldose7311093al_dose
alidade936993alidade
anode65021043__anode
bladder11429153blad_der
blade85923333bla__de
bladed104717763bladed_
caddie104316453c_addie
caddy125414023c_ad_dy
cade76443913c_a__de
cadge94018793c_ad_ge
cadged114812343c_adged
cadre85419023c_ad_re
cajole154011183c_ajole
callose9313663callose
calzone1848623calzone
canoe75627253c_ano_e
canoed94618963c_anoed
capote10315733c_apote
cathode1338993cathode
celadon1036913celado_n
celadons1137003celadons
cestode1037963cestode
chador1238673chado_r
chadors1338753chadors
chalone12312103chalone
chamade15138453chamade
charade13129913charade
chayote1536493chayote
clacked164113603clacked
clad76225823cla__d_
clades94920463clad_es
cladism1238553cladism
cladist10311973cladist
cladodial1342853cladodial
clads85722733cla__ds
clagged12749233clagged
claimed12298833claimed
clammed14369963clammed
clamor1049453clamo_r
clamored1336943clamored
clamorer1236903clamorer
clamors11710093clamors
clamour1196333clamour
clamped144012043clamped
clanged114212653clanged
clanked143812253clanked
clapped143511173clapped
claque17338563cla_que
claro75018693claro__
claroes93113733claroes
claros84015113claro_s
clashed133614013clashed
clasped123610443clasped
classed104113653classed
clause84311503cla_use
clavate1238713clavate
clave105420153cla__ve
clawed125115073clawed_
claxon1536583claxo_n
claxons1635803claxons
clayed125013043clayed_
claymore1544253claymore
cleome1039083cl_eome
clod76124613cl__od_
cloddy13405233clod_dy
clodpole1343603clodpole
clods85320863cl__ods
clone75728163cl__one
close76425223cl__ose
clove105619443cl__ove
cloze165517543cl__oze
code77347733c___ode
commode1438123commode
condole102914953condole
condone102616293condone
corrode101310573corrode
cradle93313163crad_le
cradled113410813cradled
crunode1034713crunode
cyanide13298843cyanide
dadoed9449903_dadoed
flavone1335523flavone
gladded11357453glad_ded
gladden10376313glad_den
gladder10398313glad_der
glade75121963gla__de
gladsome1244243gladsome
ladder84617623_lad_der
laddie83713173_laddie
lade56345983_la__de
laded74232613_laded_
ladle66320443_lad_le
ladled85013483_ladled
ladrone83611873_ladrone
lanose6313593_lanose
lode56240113_l__ode
radome9511873_radome
sarode75317513_sarode
vadose1037963_vadose

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.563317390.8
2DLD Change Limit1340271097.11018850.5
3Display Results1091090.0303633.3
 (SQL Overall)1786911097.70323197.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.