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

289 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
coesite971362(None) 
coesites101313091coesites
cerite84724872c_erite
chedite1338862chedite
coedit9316242coedit_
coedited1237832coedited
coedits10310242coedits
cohesive1646072cohesive
cordite10315262cordite
cosie74728262co_si_e
cosine83823512co_sine
cowrite123612682cowrite
homesite1359262homesite
resite64128452_resite
zoisite1635832zoisite
aconite9315473aco_nite
amosite9313163amosite
andesite949453andesite
arenite71017713arenite
beside95114613_beside
boehmite1583153boehmite
boite74426323bo__ite
bornite9311183bornite
caesium1158833caesium
calcite11413783calcite
campsite1447413campsite
capsize2037623capsize
caseate9314783caseate
casette9310393casette
casita82913703c_asita
cassine93817283cassine
caste75932363c_as_te
cecity1398153c_ecity
celeste949653celes_te
celestite11167033celestite
cenote83715843c_enote
cerate84829463c_erate
cerise84822043c_erise
cerites94823433c_erites
cerusite1047763cerusite
cesium1039583c_esium
cesta75419483c_es_ta
cesti75217423c_es_ti
cete64934783c_e__te
chaste114617393chas_te
cheddite1543953cheddite
chedites1438263chedites
chelate122914893chelate
chemise143211503chemise
cheshire1644553cheshire
chest104926143ches_t_
chested133811673ches_ted
chestier1387423chestier
chests114916263ches_ts
chesty144610503ches_ty
cite65640343c___ite
cleveite1343823cleveite
coast75236273coas_t_
coasted104015953coas_ted
coaster94219043coas_ter
coasts85719143coas_ts
cocaine111315173cocaine
cocotte1138603cocotte
codeine103815033codeine
coderive1447693coderive
codesign1274503codesign
codrive1337653codrive
coeditor1145723coeditor
coeliac1138233coeliac
coelome1139693coelome
coempt12311033coempt_
coempted1535333coempted
coempts1335683coempts
coenobite1344523coenobite
coenure968153coenure
coequate1946153coequate
coerce10310403coe_rce
coercive1545873coercive
coexist1638583coexist
coexisted1944143coexisted
coexists1735653coexists
cogito939203co_gito
cognate10312203cognate
cognise1059683cognise
cognize1957683cognize
cohesion1347283cohesion
cokelike1336813cokelike
colessee1098793colessee
collate92919683collate
collide103214793collide
collie83621993colli_e
comate104124843co_mate
combine133014723combine
comfit133112423comfit_
comfits14328743comfits
comity13312713co_mity
commie124215523commi_e
commit124016703commit_
commits133812383commits
commute134310443commute
compete134716553compete
compile13312443compile
composite15410153composite
compote135616463compote
compute134513663compute
comte96125473co__mte
concise11314473concise
conepate12712533conepate
confide13310203confide
confine12315583confine
confit113316403confit_
confits122811423confits
confute1239263confute
coniine9316803coniine
conine84528553co_nine
connate9315753connate
connive1238993connive
connote9311613connote
consider11310393consider
consign1038773consign
consist9316033consist
consisted1238503consisted
consists10310593consists
console92715983console
conspire1257873conspire
consume11510133consume
conte76633203co__nte
contrite10318543contrite
cookie123716043cooki_e
coolie83821603cooli_e
coontie9311423coontie
cootie84223093cooti_e
copemate1439993copemate
coppice1537483coppice
copse95623923cops__e
coquito1845403coquito
corbie103618203corbi_e
cordate10315223cordate
cordites11314623cordites
corelate10516013corelate
cornice11612933cornice
cornute939643cornute
corrie83621223corri_e
corsage1039803corsage
corse75036183cors__e
corset85636223corset_
corseted11311473corseted
corsets94819803corsets
corslet9318063corslet
corvine122113643corvine
coset75748843co_set_
cosets85824403co_sets
cosied94819883co_sied
cosier84423753co_sier
cosies84932153co_sies
cosign958783co_sign
cosily113613853co_sily
cosines94122673co_sines
cosset84125863cosset_
cosseted1178343cosseted
cossets95014283cossets
cost68057943co_s_t_
costa75523733co_s_ta
costae85319683co_stae
costate94019273costate
costed95623113co_s_ted
coster84331293co_s_ter
costive12312843costive
costs77231143co_s_ts
cote66648733co___te
coterie9417403coteri_e
cousin8517163cousi_n
cousins9516003cousins
covellite1445603covellite
coversine1459703coversine
cowhide1636143cowhide
cowpie133511513cowpi_e
cowrie113814283cowri_e
cowriter13238883cowriter
cowrites133011593cowrites
cowrote12289673cowrote
coyest11316053coyes_t_
coyote11411783co_yote
cozie163519133co_zi_e
create85126383cre_ate
credit9315193credit_
credited1238253credited
credits1039973credits
cremate113816183cremate
crenate93317113crenate
creosote1045923creosote
crescive1545283crescive
cresset93319943cresset
crest74632693cres_t_
crested103416533cres_ted
crests85218703cres_ts
crevice1436153crevice
crinite9513633crinite
crocoite1248053crocoite
crosstie1046933crosstie
cuesta838513cues_ta
cuisine9310423cuisine
cuprite1159683cuprite
curite85222943c_urite
cursive1237833cursive
cutesie937963cutesi_e
cyanite122710763cyanite
cyesis1148573cyesi_s
desire7415303_desire
despite10410123_despite
doest65829523does_t_
dolerite9611773dolerite
donsie7613643donsi_e
elite56230183__elite
eosine64519413eo_sine
eremite9312833eremite
evite85317683__evite
felsite1039083felsite
fomite113314073fo_mite
foreside12310303foreside
fossate10388603fossate
geste65920693_ges_te
gobshite1443273gobshite
goethite1244053goethite
gothite1146403gothite
hessite1038993hessite
hoelike141411163hoelike
homesites1448913homesites
hoplite12311073hoplite
horste94817413hors_te
inosite7314063inosite
iolite63221983io_lite
lenite6719983_lenite
modiste1039283modiste
moste75925083mo_s_te
noesis6311443noesi_s
noesises838503noesises
nonelite8313613nonelite
norite63221133no_rite
obesity1275653obesity
onside7511803_onside
oolite63319603_oolite
ophite11410563_ophite
pelite84323003_pelite
petite84320653_petite
podite93315353po_dite
poesies93217403poesies
poetise9314043poetise
poetize18310773poetize
polite83625073po_lite
popsie103013053popsi_e
posit75833333po_sit_
posited10511493po_sited
posits85718713po_sits
postie84123963po_stie
potsie83916033potsi_e
preside10715613preside
recite83625113_recite
reside74224933_reside
resile64627673_resile
resit54241043_resit_
resited85122423_resited
resites74027793_resites
resits64725563_resits
resize154117723_resize
respite9513033_respite
roseate7613453roseate
rosette7310373rosette
sclerite10410713sclerite
scolecite1345653scolecite
sienite7312713sienite
site47052413___site
somite84519373so_mite
sonsie6614863sonsi_e
sopite84917713so_pite
subsite9412873subsite
syenite1039773syenite
teosinte845543teosinte
toelike11149823toelike
toeshoe1047843toeshoe
topside1037733topside
totemite1046873totemite
ulexite1445723ulexite
verite94323443_verite
website1235323website
woesome1246733woesome
yperite1249893yperite
zeolite1638903zeolite
zoisites1744973zoisites

Search took 7 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.406440125.6
2DLD Change Limit1340272896.40620922.1
3Display Results2892890.1102627.3
 (SQL Overall)1786912896.92225814.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.