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

176 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
cadelles113997(None) 
cadelle1039921cadelle_
cadences1338472cadences
canellas10310562canellas
chandelles1645342chandelles
cordelles1248232cordelles
gabelles11278932gabelles
gazelles18266562gazelles
nacelles1048392nacelles
abeles84719393_abe_les
academes1344873acade_mes
academies1444683academies
addles84216603_ad_dles
aediles83413903_aediles
alleles73812033_alleles
amarelles1145533amarelles
aneles64626293_ane_les
areoles71016953_areoles
bedells10379363bedell_s
belles85325993__belles
caballed1337163caballed
cables104527553ca__bles
cackles153717203ca_ckles
caddices14297853caddices
caddies113718383cad_dies
caddises12329353caddises
cadence1239063cadence_
cadenced1435523cadenced
cadencies1447323cadencies
cadenzas2053743cadenzas
cades85440733cad___es
cadets96316513cade__ts
cadges104716713cad__ges
cadres94017933cad__res
cajoles163712103ca_joles
calces104420053ca__lces
caleches15269943caleches
calicles123811433calicles
callas84526753ca__llas
called94126733ca__lled
callee84327293ca__llee
callees94117783ca_llees
caller85125483ca__ller
callers94221963ca__llers
callet84536763ca__llet
callets93821703ca__llets
calls75634733ca__ll_s
callus85317073ca__llus
calves115119283ca__lves
calxes154113033ca__lxes
calycles15295693calycles
cameleer1246033cameleer
cameleers1345093cameleers
camelias12510303camelias
camelids1356943camelids
camellia1255443camellia
camellias1365093camellias
camels105217083came_l_s
canailles1148273canailles
canalled1139583canalled
canaller1038953canaller
canallers1137213canallers
cancelled1456743cancelled
canceller1366683canceller
cancellers1445363cancellers
candelas1139533cande_las
candles104422343ca_ndles
canella9310793canell_a
cantles94721413ca_ntles
capelans1238013capelans
capelet11517073cape_let
capelets1268603capelets
capelins12311133capelins
capsules1236623capsules
caravelles1544893caravelles
careless102813633careless
caresses10314063caresses
carioles10817073carioles
carles85435083ca__rles
carolled1138833carolled
caroller1039203caroller
carollers1137703carollers
carrells10359273carrell_s
caseases10410473caseases
caseates10313713caseates
casefies1339213casefies
caseoses1039293caseoses
casernes103810753casernes
casettes1039653casettes
castles94917733ca_stles
cataloes10311653cataloes
caudexes1843843caude_xes
caudillos1243563caudillos
caudles103912813ca_udles
caules85927253ca__ules
cavallas1366843cavallas
cavallies1446393cavallies
cavilled1436733cavilled
caviller1337063caviller
cavillers1435613cavillers
cayennes1345013cayennes
cedillas1145743cedillas
celled94420323c__elled
cellos84517803c__ellos
cells75428063c__ell_s
chandelle1545223chandelle_
chandelled1744273chandelled
cicelies1269753cicelies
cineoles10109403cineoles
coddles114213593cod_dles
codeines113114523codeines
codeless112010113codeless
cordelle1148433cordelle_
cordelled1346403cordelled
cradles103114133crad__les
crenelles1146733crenelles
creoles9913323c_reoles
crueller1056453crueller
cruellest1155583cruellest
cubanelles1462433cubanelles
cuddles114014093cud_dles
cudgelled1443113cudgelled
cupelled1365743cupelled
cupeller1256103cupeller
cupellers1374863cupellers
daddles104213803dad_dles
dalles74222063__dalles
deles65139253__de_les
dellies83622213__dellies
dells66630943__dell_s
delves104917083__delves
duxelles1643963duxelles
echelles1346673echelles
fadeless12258323fadeless
failles102914133fa_illes
favellas1446163favellas
gabelle10259213gabelle_
gabelled12317583gabelled
gadflies1334733gadflies
gavelled13387363gavelled
gazelle17236333gazelle_
jadeites1645823jadeites
labelled11278293labelled
labeller10248073labeller
labellers11206553labellers
ladles74619543lad__les
lamellas1098163lamellas
lapelled11227083lapelled
manilles102312603manilles
micelles1288833micelles
modelled1236433modelled
modeller1136613modeller
modellers1245393modellers
morelles10710493morelles
nacelle938153nacelle_
paddles113515643pad_dles
padles95221123pad__les
paellas9411413pa_ellas
panelled1138963panelled
patellas1039103patellas
raddles93615703rad_dles
radicles11249703radicles
ravelled12419783ravelled
raveller11339263raveller
ravellers12257163ravellers
rondelles1046623rondelles
roselles8310713roselles
saddles95415743sad_dles
selles64426983__selles
spadilles1244993spadilles
tadpoles1135953tadpoles
tailles72516473ta_illes
waddles124314843wad_dles
yodelled1334603yodelled
yodeller1244853yodeller
yodellers1343973yodellers

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621767.32619951.1
3Display Results1761760.0802200.0
 (SQL Overall)1786911767.81222873.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.