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

261 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
coterie941740(None) 
coteries10422701coteries
coderive1447692coderive
coerce10310402co_erce
cohere112716992coher_e
corrie83621222co_rrie
cowrie113814282co_wrie
cutesie937962cutesie
niterie7313742niterie
aerie54634603__aerie
apteria9312913apteria
arteries8321483arteries
asteria7316183asteria
batterie10711533batterie
boiserie1047993boiserie
booteries11312773booteries
bothria1246443bothria
boweries13312293boweries
calorie92716893calorie
camerae11312063camerae
caserne93710063caserne
catbrier1236173catbrier
catenae9311373catenae
cater74840723cater__
cateran9313773cateran
catered103117773catered
caterer92815943caterer
catering112019903catering
caters85336503cater_s
catteries11815523catteries
cattie85221023cat_tie
causerie1078273causerie
cauteries11615393cauteries
cauterize2088313cauterize
celeries10316313celeries
cere66741473c__er_e
ceria75125353c__eria
ceric94023093c__eric
cerise84822043c__erise
cerite84724873c__erite
cheerier1348003cheerier
cheerio12379313cheerio
choleric15107913choleric
cinerin9313823cinerin
citer74827333citer__
citers85022983citer_s
citric102812313cit_ric
citrin82615413cit_rin
citrine92514023cit_rine
cleric10612133c_leric
clerid9312413c_lerid
cloture9238453clotur_e
coarse84813903co_arse
coatee84327223coate__e
coater84329573coater__
coaters93525793coater_s
codeia94112193code_ia
codein94916723code_in
codeine103815033codeine
coder86134223coder__
coderived1644793coderived
coderives1547483coderives
coders95426983coder_s
codrive1337653co_drive
coedit9316243co_edit
coerced1238583co_erced
coercer1138383co_ercer
coerces11311943co_erces
coercive1545873co_ercive
coesite9713623co_esite
coheir1137583cohe_ir
coheirs1236753coheirs
cohered133514693cohered
coherer122912783coherer
coheres122917693coheres
cohering142413833cohering
cohesive1646073cohesive
cokelike1336813cokelike
collie83621993co_llie
colorize192314203colorize
colter84625093colter__
colters93522443colter_s
colure8314163colur_e
comedic14158633comedic
comedies13311843comedies
comelier12310653comelier
comer95832693comer__
comers105328083comer_s
cometic131215723cometic
commerce16116323commerce
commie124215523co_mmie
compere134616623comper_e
comprise14310813comprise
comprize2368733comprize
conchie143312683conchie
conferee13613733conferee
congeries12316403congeries
conserve1339933conserve
contrite10318543contrite
contrive13311353contrive
converge1437393converge
converse13310263converse
cooee74531023cooe__e
cooer74831013cooer__
cooers84324563cooer_s
cookeries151210633cookeries
cookie123716043co_okie
coolie83821603co_olie
coontie9311423coontie
cooperies131113313cooperies
cooter85128613cooter__
cooters94525723cooter_s
cootie84223093co_otie
coper95336093coper__
copers104629843coper_s
copter109822013copter__
copters113621283copter_s
corbie103618203co_rbie
core67263113co__r_e
coremia11310363coremia
corer75538873corer__
corers85231073corer_s
coria75828323co__ria
corries94026793co_rries
corse75036183co__rse
cortege1098953corte_ge
cosie74728263co__sie
coster84331293coster__
costers94128333coster_s
cote66648733cot___e
coteau8311083cote_au
coteaux1643723coteaux
coted85033853cote__d
cotes76347843cote__s
cotinine10311493cotinine
cottae84615703cot_tae
cottage104210573cottage
cotter84926673cotter__
cottered112511733cottered
cotters94323443cotter_s
cottier93814173cot_tier
coturnix1742203coturnix
cotype1346823cot_ype
courier93617893co_urier
course85117783co_urse
couter84930223couter__
couters93827303couter_s
couthie121810553couthie
couture9310623coutur_e
couturier1145423couturier
covaried1448003covaried
covaries13413253covaries
cover105430773cover__
coverage1438733coverage
covered133315293covered
coverer123113523coverer
covering142215723covering
coverlet13413013coverlet
coverlid1445943coverlid
covers114627963cover_s
coversine1459703coversine
covert114925503cover_t
coverts124813813coverts
coverup1434623coverup
cower104531773cower__
cowered133214653cowered
cowering142514033cowering
cowers114625533cower_s
cowpie133511513co_wpie
cowries124218013co_wries
cowrite123612683co_write
coyer105222843coyer__
cozie163519133co__zie
creepie1137483creepie
criteria1047993criteria
curie74533043c__urie
currie84317263c_urrie
cuter74728233cuter__
cutesier1045623cutesier
cutie76925933cut__ie
cutleries1179213cutleries
deterge9118463deterge
dolerite9611773dolerite
doter65428623doter__
doters74423913doter_s
dovekie15134313dovekie
doweries12411933doweries
eateries8324313eateries
eerie55228533__eerie
enteric9314213enteric
esoteric1057593esoteric
eterne6311723_eterne
exoteric1746803exoteric
externe1438573externe
faerie93514683_faerie
gomeril1047383gomeril
homeric14312213homeric
hotelier1137633hotelier
hottie92514383hot_tie
icteric1138023icteric
interim9912873interim
interne73218153interne
intertie8317613intertie
laterite8716333laterite
laterize17613293laterize
lotteries9311073lotteries
materiel10311253materiel
moderne1037123moderne
moperies12313873moperies
motoric11312223motoric
motorise10311523motorise
motorize19410433motorize
neoteric1047853neoteric
niteries8318383niteries
notaries8314933notaries
notarize1749293notarize
noter55025643noter__
noters64021003noter_s
octette946423octette
onerier7311613_onerier
oorie53026363_o_orie
ourie54027303_o_urie
overlie102615013_overlie
peerie83617893_peerie
poetries10315583poetries
poperies12316793poperies
potence11711363potence
potpie103412433pot_pie
potsie83916033pot_sie
potteries11313593potteries
pterin81014153_pterin
reverie103615163reverie
roperies10315763roperies
roseries8317313roseries
rotaries8315693rotaries
roturier836033roturier
scoter83815483scoter__
scoters93313813scoter_s
scottie937463scot_tie
soberize1998883soberize
stere55328543_ster_e
steric8317063_steric
sterile7316603_sterile
stourie7469353stourie
terce75721843__terce
terne56426153__terne
terse55026823__terse
totemic1137533totemic
totemite1046873totemite
toter55932133toter__
toters65026363toter_s
towerier1137123towerier
uteri51012983_uteri_
uterine7315193_uterine
voleries11313233voleries
vomerine1347683vomerine
votaries11312013votaries
voter85121053voter__
voters95017443voter_s
wasterie111211583wasterie
waterier11312083waterier

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.423422437.4
2DLD Change Limit1340272616.56320421.6
3Display Results2612610.0902900.0
 (SQL Overall)1786912617.07625253.1
 
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.