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

221 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
caramels123880(None) 
caramel11310251caramel_
caravels1337431caravels
arames84622572_arame_s
calomels1236132calomels
camels105217082c__amels
caracals12310742caracals
caracols12310412caracols
caraculs1238032caraculs
carafes125015702carafe_s
caramelise1464682caramelise
carates95630612carate_s
caravel1238202caravel_
carbamyls1843032carbamyls
carcels114516062car_cels
carpels115315462car_pels
carrels95117302car_rels
cartels94618122car_tels
carvels124914592car_vels
ceramals1246512ceramals
cormels113813372cor_mels
tramels93812492_tramels
arables91814973_arables
arame75026623_arame__
aramids102810513_aramids
ariels65119373_ar_iels
armers85520273_ar_mers
armets84918353_ar_mets
artels66216233_ar_tels
barbels114514433bar_bels
barrels94514363bar_rels
cabals104020153caba__ls
cabarets12268463cabarets
cadavers1435883cadavers
calamars1238133calamars
calamus1139243calam_us
calomel1138073calomel_
calumets1236283calumets
camails11311753cama_ils
camases114216343camase_s
camel96822803c__amel_
cameos105818003c__ameos
cames97047313c__ame_s
canals84421663cana__ls
canapes111213083canape_s
cancels114113313ca_ncels
cannels93413363ca_nnels
carabaos1238073carabaos
carabids1338193carabids
carabins12312353carabins
caracal11312513caracal_
caracks152211563cara_cks
caracol11310423caracol_
caracole12310353caracole
caracoles13310073caracoles
caracul1138823caracul_
carafe115416163carafe__
carageen1155633carageen
carageens1264723carageens
caramba1336893caram_ba
carambola1542853carambola
carambolas1643363carambolas
caramelised1673093caramelised
caramelises1554613caramelises
caramelize2364113caramelize
caramelizes2494123caramelizes
carate84734003carate__
carats85929023cara__ts
caravans1338613caravans
caravelle1444693caravelle
caravelles1544883caravelles
caraways1636943caraways
carbamoyls1951793carbamoyls
carbamyl1743103carbamyl_
carbaryls1644013carbaryls
carcanets1347303carcanets
carcases12313083carcase_s
carcel105018673car_cel_
cardamoms1643513cardamoms
cardamons1445203cardamons
cardamums1642603cardamums
carders104820353car_ders
careens94514703car_eens
careers95218783car_eers
careless102813633careless
carers85133963car__ers
cares77369183car__e_s
caress85720263car__ess
carets85330773car__ets
carfares13310323carfare_s
carfuls1249133car_fuls
cargoes104415223cargoe_s
caribes113715643caribe_s
carices114220953carice_s
caries85147623car_ie_s
carioles10817073carioles
carles85435083car_le_s
carless95118493car_less
carls77037423car___ls
carmakers1736913carmakers
carmen104019343car_me_n
carnages11312213carnage_s
carnets93918403car_nets
carneys124310543car_neys
carnies94123963carnie_s
carolers103314173carolers
carols85124983car__ols
caromed123713623carome_d
caroms105619573carom__s
carousels1165343carousels
carpals113414623car_pals
carpel105418473car_pel_
carpers114521253car_pers
carpets113915333car_pets
carpools1237883carpools
carrel84718633car_rel_
carrell94610473car_rell
carrells10359273carrells
carriers103614203carriers
carries94328013carrie_s
carses85233653car_se_s
cartages11313313cartage_s
cartel85022533car_tel_
carters95327253car_ters
cartes86239473car_te_s
carvel114817573car_vel_
carvers124817533car_vers
carves115128453car_ve_s
cascabels15163233cascabels
ceramal1138843ceramal_
ceramics1446803ceramics
cerates95428253cerate_s
cermets1139713cer_mets
cerumens1235763cerumens
chapels14429153c_hapels
charades141310853charade_s
charases131312763charase_s
charmers154211333char_mers
charnels13328173char_nels
chromes142914933chrome_s
chromyls18244733chromyls
citadels1142843citadels
columels1244813columels
coracles121811163coracles
corals85325143cora__ls
corbels113813593cor_bels
cormel103815603cor_mel_
cornels94716663cor_nels
cornmeals1344573cornmeals
coronels104012143coronels
craals84113303c_ra_als
cradles103114133c_radles
crakes124921813c_rake_s
crambes1339963c_rambes
crambos1336783c_rambos
crammers14369353crammers
cramps125615563c_ram_ps
crams96229153c_ram__s
cranes84330753c_rane_s
crapes104727693c_rape_s
crases85532313c_rase_s
craters95021893c_raters
crates85736063c_rate_s
cravens124010113c_ravens
cravers124416553c_ravers
craves115825393c_rave_s
crawls114712083c_ra_wls
crazes174720133c_raze_s
creamers124111303creamers
creels84416943c_r_eels
cremes104517993c_reme_s
crenels93711013c_renels
crewels12438483c_rewels
crimes105521583c_rime_s
curares94916853curare_s
curates95323833curate_s
darnels83710433dar_nels
duramens1195153duramens
enamels9128163_enamels
falafels1453113falafels
fardels11389893far_dels
farfels13348213far_fels
farmers124315263far_mers
foramens1337823foramens
framers125113823_framers
frames115119863_frame_s
garages9314113garage_s
gravels113611143_gravels
harmers124116593har_mers
karakuls1142083karakuls
karates115617473karate_s
macrames1438953macrame_s
madames12310063madame_s
marcels113212373mar_cels
marvels123810093mar_vels
parables121613563parables
paraders113113113paraders
parades104121463parade_s
parallels1145263parallels
parament12415393parament
paraments13511553paraments
paramos113213513param_os
parapets1239763parapets
parasols1039263parasols
parcels113712663par_cels
parrels94713493par_rels
ramees84620893__ramees
ramets83517393__ramets
ratels64518213__ratels
ravels94717073__ravels
sarapes94617743sarape_s
taramas9612703taram_as
tramel84113713_tramel_
tramell9398703_tramell
tramells10327833_tramells
trammels12295413trammels
travels104711293_travels
unravels1144633unravels
wadmels1334303wa_dmels
wakames1635283wakame_s
warmers124514293war_mers

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461622218.12617987.0
3Display Results2212210.0932376.3
 (SQL Overall)1786912218.39221293.0
 
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.