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

500 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
cermets113971(None) 
cermet10321151cermet_
armets84918352_armets
berets85822522ber_ets
bermes106023002berme_s
carets85330772car_ets
carnets93918402carnets
carpets113915332carpets
cements112714222ce_ments
cerates95428252cerates
cerements13411452cerements
ceres75540012cer_e_s
cereus85215522cer_eus
cerites94823432cerites
certes84623082certe_s
cerumens1235762cerumens
comets105823582c_omets
cormels113813372cormels
cornets94820572cornets
corsets94819802corsets
corvets124715022corvets
cremes104517992creme_s
cruets85314952c_ruets
curets84922342cur_ets
curvets12399912curvets
emmets10349152_emmets
ferments13311472ferments
ferrets103111392ferrets
germens1078622germens
helmets12309072helmets
hermits12312142hermits
kermes124616122kerme_s
kermess13396222kermess
pelmets11309692pelmets
permits11314002permits
tercets93512442tercets
termers95414502termers
terrets72913582terrets
vermes115019142verme_s
versets103913102versets
vervets13419752vervets
acerbest1245463acerbest
aerates74627493aerates
aeries64737783aerie_s
aeriest73924053aeriest
afreets1037013afreets
armers85520273_armers
armet76739453_armet_
armlets94610063_armlets
averments1449093averments
barbets114915843barbets
barrets94917103barrets
beckets15399823beckets
beets76131443be__ets
befrets1237613befrets
begets96215523be_gets
bennets94712163bennets
berates94126873berates
beret74946363ber_et_
berimes115216643berime_s
berme96022943berme__
bermed115217723berme_d
berms95323663berm__s
besets85718803be_sets
besmuts1134683besmuts
brevets12519393brevets
burets84321263bur_ets
burnets93813263burnets
cabernets1345063cabernets
cablets114216343cablets
cachets145014263cachets
cadets96316513c_adets
callets93821703callets
calmest11312343calmest
calumets1236283calumets
camels105217083c_amels
cameos105818003c_ameos
cames97047313c_ame_s
camlets114314623camlets
caplets114914523caplets
caramels1238803caramels
carates95630613carates
carats85929023car_ats
carcels114516063carcels
carders104820353carders
careens94514703careens
careers95218783careers
carers85133963car_ers
cares77369183car_e_s
caress85720263car_ess
caret75360563car_et_
caries85147623carie_s
carles85435083carle_s
carless95118493carless
carmen104019343carme_n
carnet84732873carnet_
carneys124310543carneys
carpels115315463carpels
carpers114521253carpers
carpet104530093carpet_
carrels95117303carrels
carrots9714623carrots
carses85233653carse_s
cartels94618123cartels
carters95327253carters
cartes86239473carte_s
carts78946293car__ts
carvels124914593carvels
carvers124817533carvers
carves115128453carve_s
caskets133910173caskets
ceases84427073cease_s
ceders93817673ce_ders
cedes84927323ce_de_s
cees65941593ce__e_s
ceilers93912533ceilers
celebs1037883ce_lebs
celts75325783ce__lts
cement103321663ce_ment
cementa112810533ce_menta
cenotes92814543cenotes
censers94313903censers
censes83721803cense_s
centers94420603centers
cents74730333ce__nts
cepes94424463ce_pe_s
ceramals1246513ceramals
ceramics1446803ceramics
ceramist12310933ceramist
ceramists1346723ceramists
cerastes101111093cerastes
cerate84829463cer_ate
cerated103922473cerated
cercis104614493cer_cis
cercus105013153cer_cus
cere66741473cer_e__
cereal8315833cer_eal
cereals9313173cereals
cered85227443cer_e_d
cerement12315133cerement
cerias83321983cer_ias
ceriphs1484753ceriphs
cerises94722253cerises
cerite84724873cer_ite
ceriums1139473ceriums
ceros74726073cer__os
cerous85821203cer_ous
cerumen1147763cerume_n
ceruses93716233ceruses
cervelas1344673cervelas
cervelats1443493cervelats
cerveza2142333cerveza
cervezas2242013cervezas
cesses84221363cesse_s
cetes75731103ce_te_s
chalets122813473chalets
charmers154211333charmers
cheroots1348193cheroots
cherts115617233cher__ts
chevrets16255323chevrets
chimers144515143chimers
chimes134922573chime_s
chromes142914933chrome_s
chymes165912153chyme_s
circlets1235663circlets
cires74932913cir_e_s
civets115212543c_ivets
clarets94111103clarets
cleomes1138813cleome_s
climes104720003clime_s
closets94611603closets
coempts1335683coempts
coercers1237653coercers
coerces11311943coerce_s
coerects1258543coerects
collets93517903collets
comers105328083c_omers
comes97246993c_ome_s
comet95946073c_omet_
cometh134811683c_ometh
comments142913883comments
commits133812383commits
compts125216653c_ompts
comtes106222813c_omtes
coquets18399893coquets
corbels113813593corbels
corders104520883corders
corers85231073cor_ers
cores76361853cor_e_s
corkers134118853corkers
cormel103815603corme_l
cormous11312353cormous
corms95626223corm__s
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornet84436733cornet_
coronets103814363coronets
corrects1259573corrects
corses84433463corse_s
corset85636223corset_
corslets1038273corslets
corvees124613793corvees
corves115122523corve_s
corvet114626933corvet_
cosets85824403c_osets
cossets95014283cossets
coverlets1437053coverlets
covets114819643c_ovets
crafts115312743c_rafts
crates85736063c_rates
creamers124111303creamers
creates95225193creates
credits1039973credits
creds85418773c_r_eds
creeds94714773c_reeds
creeks124812923c_reeks
creels84416943c_reels
creeps104213623c_reeps
cremate113816183cremate
cremates124216003cremates
creme94319323creme__
crenels93711013crenels
crepes105419343crepe_s
cress75022833c_r_ess
cressets10309103cressets
crest74632693c_r_est
crests85218703c_rests
crewels12438483crewels
crews105917493c_r_ews
criers83918583c_riers
cries75438403c_rie_s
crimes105521583crime_s
crits75527573c_r_its
crofts114910593c_rofts
cruet74831843c_ruet_
crumpets14335943crumpets
crusets93811043crusets
crusts84916543c_rusts
crypts13397743c_rypts
culets85518513c_ulets
cullets94015613cullets
cummers133713483cummers
curates95323833curates
curbers115514383curbers
curers84923193cur_ers
cures75645433cur_e_s
curet75447643cur_et_
curfews15294913curfews
curies84934023curie_s
curites93919863curites
curlers94218073curlers
curlews12387393curlews
currents1038373currents
cursers94317163cursers
curses85328273curse_s
curtest9713963curtest
curves114619283curve_s
curvet114720243curvet_
cutlets94113653cutlets
cygnets1333813cygnets
cymes1210118923c_yme_s
deets65330243de__ets
dements103016623de_ments
demes86032693de_me_s
demits94918073de_mits
derates84028893derates
derats74625063der_ats
dermas94116813derm_as
dermis94717163derm_is
derms85022893derm__s
dormers104313923dormers
ebbets10376833_ebbets
eeriest73620673eeriest
egrets72712243_egrets
emes65434663_e_me_s
emeus76913333_e_meus
emits75421473_e_mits
emmers104013223_emmers
emmet94221383_emmet_
erects84116183_erects
ergots74512373_ergots
ernes55224813_erne_s
erses55826803_erse_s
eructs83610793_eructs
erupts8348903_erupts
farmers124315263farmers
femes105626223fe_me_s
femmes135410213femme_s
feres86038183fer_e_s
fermata12278143fermata
fermatas13246223fermatas
fermate122813003fermate
ferment12315573ferment
fermis114313503ferm_is
ferrels10248623ferrels
ferret93021173ferret_
ferrety13287013ferrety
firmers124711443firmers
firmest1239273firmest
forgets113813793forgets
formats123113573formats
formers128217953formers
formes114623713forme_s
frets85523403_fr_ets
fumets114311813_fumets
furmety1534813furmety
gargets94614573gargets
garments1139963garments
garnets84115403garnets
garrets84413623garrets
gemots93712153ge_mots
genets75716663ge_nets
gerents82612923gerents
germans1079473germans
germen9612313germe_n
germiest11249913germiest
germs85118873germ__s
gorgets94711783gorgets
gourmets1144153gourmets
greets75117423_greets
gurnets84010793gurnets
harmers124116593harmers
helmet113718933helmet_
hemes105031083he_me_s
hemmers143310843hemmers
herders113914123herders
heres86245903her_e_s
hereto9313693her_eto
heriots10312063heriots
hermetic15310243hermetic
hermetism1646643hermetism
hermetist1448953hermetist
hermit11519443hermit_
herms105626433herm__s
heroes94923823heroe_s
herpes115517323herpe_s
hornets104113553hornets
jennets14517633jennets
jereeds15326383jereeds
jerkers18287083jerkers
jerseys1733243jerseys
keets95123483ke__ets
kermesse14303483kermesse
kermis124012393kerm_is
kernels11417953kernels
kernes104717523kerne_s
kerseys1433993kerseys
keysets1434343keysets
kirmess13234313kirmess
kismets13306883kismets
leets54927123le__ets
mammets103911113mammets
markets133314033markets
marmots11311513marmots
maumets11369693maumets
meets74224613me__ets
memes94927703me_me_s
mercers114412773mercers
merces105720743merce_s
merdes94518603merde_s
meres75143573mer_e_s
merest84725113mer_est
mergees104411233mergees
mergers103813423mergers
merges94122483merge_s
merits8320873mer_its
merles85322763merle_s
merlots92710123merlots
mermen10813813merme_n
nereis6315343ner_eis
nerts55924983ner__ts
nerves94216193nerve_s
neumes83112623neume_s
ormers84316143_ormers
overbets132510683overbets
overlets112312363overlets
overmelts1447263overmelts
oversets113114173oversets
overwets14219953overwets
pargets105215193pargets
pellets94014783pellets
pelmet103419243pelmet_
percents122713373percents
percepts14247643percepts
peres76246643per_e_s
perfects15107353perfects
permease1246503permease
permeate12311613permeate
permeates13311773permeates
permed115217343perme_d
permit10321683permit_
perms95524513perm__s
permute1138793permute
permutes1238713permutes
perpents122312033perpents
perses85428063perse_s
pertest9317043pertest
perverts1337533perverts
premeds12389583premeds
presets94216423presets
ramets83517393_ramets
reamers94221083reamers
reemits9611303reemits
reflets103513153reflets
reglets83512983reglets
regreets9287853regreets
regrets83212923regrets
relets64025673re_lets
remeets93712413remeets
remelts93511493re_melts
remet74843723re_met_
remits85622943re_mits
rennets75212633rennets
rerents73319423rerents
resets65427613re_sets
resmelts1046143resmelts
rets45352563__r_ets
revets94022173re_vets
rewets94617213re_wets
sarments10311963sarments
scarlets10178573scarlets
seamers94719433seamers
secrets9311773secrets
seemers93814333seemers
segments1138903segments
semens84616963se_mens
semes75731583se_me_s
sennets73712583sennets
septets998953septets
seres55448893ser_e_s
serest64831613ser_est
sergers83815633sergers
serges74225963serge_s
series64540973serie_s
sermons9311783sermons
serpents102410373serpents
servers103214833servers
serves94423653serve_s
sestets7911473sestets
sextets1497143sextets
sherbets1335213sherbets
sorbets93012513sorbets
sterlets8169273sterlets
streets73312613streets
targets84314223targets
teemers95012903teemers
telnets738373telnets
tempts10439453te_mpts
tenets65518953te_nets
tercels94110363tercels
terces83921413terce_s
tercet83624913tercet_
terete6319333ter_ete
termed94816703terme_d
termer85717253terme_r
termite9313893termite
termites10313693termites
termless1036233termless
termors94712773termors
terms75523473term__s
ternes65422903terne_s
terret63425623terret_
territs72714503territs
tersest71713993tersest
thermels13607763thermels
thermes126214613therme_s
thermits1338513thermits
torments10310453torments
trets55928023_tr_ets
trevets10499973trevets
turrets73010673turrets
varlets10411573varlets
varments1339063varments
velvets13326693velvets
vergers114412633vergers
verges104320173verge_s
veriest103719133veriest
verists103613673verists
verites103822263verites
vermeil1285223vermeil
vermeils1374813vermeils
vermis114214963verm_is
vermuth1543533vermuth
vermuths1642603vermuths
versers103813523versers
verses94223763verse_s
verset94327323verset_
verstes104014283verstes
versts93914733ver_sts
verts85724733ver__ts
verves124617883verve_s
vervet124619063vervet_
warmers124514293warmers
warmest123113033warmest
weets85427723we__ets
wergelts1253413wergelts
wormers124012573wormers
worsets105512843worsets
zeroes154314343zeroe_s

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.1401276364.3
2DLD Change Limit1340275007.01619103.1
3Display Results5005000.1902631.6
 (SQL Overall)1786915007.34624324.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.