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

231 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
connotes1031145(None) 
connote9311611connote_
connoted1138861connoted
cenotes92814542c_enotes
cognates11311582cognates
compotes144716512compotes
condoes104319202condo_es
condoles113015802condoles
condones112817392condones
condores113315642condores
conenoses1188902conenoses
confutes1339842confutes
congoes103617302congo_es
conioses10313312conioses
connate9315752connate_
connives1339722connives
consoles103216152consoles
contes84432912co_n_tes
convokes17247702convokes
coyotes12410702co_yotes
aconites10314353aco_nites
amniotes1036603amniotes
annates72415423_annates
banknotes1544313banknotes
bongoes104314113bongo_es
bonitoes1038153bonitoes
bonnes85621453bonn__es
bonneted1136223bonneted
bonnets94812803bonnet_s
bonnocks1644623bonnocks
bornites10310983bornites
cannolis1037863cannolis
cannoned11118143cannoned
cannons94412883canno_ns
cannot83616773cannot__
canoes84725883c_ano_es
canzones1939153canzones
capotes11314643c_apotes
cenote83715843c_enote_
centones10313663centones
chayotes1636503chayotes
chinones13510473chinones
cineoles10109403cineoles
coannexes1843643coannexes
cobnuts1135353cobnut_s
cocottes1238303cocottes
coelomes1239293coelomes
coenobites1444183coenobites
coenocytes1744093coenocytes
coenures1048683coenures
coesites101313093coesites
cognate10312203cognate_
cognises11610043cognises
cognizes2058033cognizes
cognomen1346083cognomen
cognomens1443863cognomens
coinages11310803coinages
coinmates1348343coinmates
cointer93616723coin_ter
cointers103616413coin_ters
cojones163512103co_jones
collates103019143collates
colones96124433co_lones
colonies103620013colonies
comates114123643co_mates
commodes1539093commodes
commoves1736963commoves
commutes143011893commutes
competes144117243competes
composes145017123composes
compote135616463compote_
computes143914553computes
comtes106222813co__mtes
conatus9310463co_natus
concaves1538913concaves
concedes13311063concedes
conches144019813co_nches
conchies153214853conchies
concocted1346763concocted
concocter1247623concocter
concocters1346753concocters
concocts1138633concocts
concords1358593concords
concours1239473concours
concretes13411473concretes
condole102914953condole_
condoled123110723condoled
condoler113412123condoler
condolers122710573condolers
condoms124214083condo_ms
condone102616293condone_
condoned122612023condoned
condoner112913413condoner
condoners122811513condoners
condors104018573condo_rs
condos94322333condo__s
conduces13129783conduces
condyles14277463condyles
conenose1078593conenose_
conepates13912283conepates
cones76457423co_n__es
confides14310573confides
confines13315653confines
confits122811423confit_s
conflates14311133conflates
conforms1538873conforms
confuses13310363confuses
confute1239263confute_
confuted1437683confuted
confuter1338513confuter
confuters1437793confuters
congees103517923co_ngees
conges94928173co_n_ges
conglobes1444223conglobes
congos94219883congo__s
congous103615083congo_us
conies84338593co_n_ies
coniines10415363coniines
conines93827793co_nines
coniosis1048133coniosis
conjoins1738133conjoins
conjures17119913conjures
connately1445233connately
connected1438753connected
connecter1349053connecter
connecters1448013connecters
connects123010563connects
conned95119703conn__ed
conner84423963conn__er
conners94023113conn_ers
connive1238993connive_
connived1436433connived
conniver1337493conniver
connivers1436933connivers
connoting12310023connoting
conns75024233conn___s
conoids10813883co_noids
console92715983console_
consoled112911453consoled
consoler102812613consoler
consolers112510923consolers
consols92914073conso_ls
consommes1545633consommes
consorted1239773consorted
consorts101512343consorts
consumes12310413consumes
conte76633203co_n_te_
contest93523233co_n_test
contorted1239473contorted
contorts101112643contorts
contos84923233co_n_tos
contours1039653contours
contuses10413453contuses
convenes132916913convenes
convexes20278273convexes
convoke16207173convoke_
convoked18236163convoked
convoker17226903convoker
convokers18246103convokers
convolutes1544503convolutes
convolves1745323convolves
convoyed17225553convoyed
convoys15267023convo_ys
cooees85621893co__oees
coonties10513803coonties
cooter85128613co__oter
cooters94525723co__oters
cooties93725733co__oties
coots75636843co__ot_s
coplots11511593coplot_s
corantoes1147653corantoes
cordites11314623cordites
cornets94820573cornet_s
cornices12713293cornices
cornpones1347113cornpones
cornuses10310033cornuses
cornute939643cornute_
cornuted1137473cornuted
cornutos1046053cornutos
coronates1110816923coronates
coronets103814363coronets
corrodes111310333corrodes
cosmoses1239713cosmoses
cotes76347843c___otes
counted103815803coun_ted
counter94220153coun_ter
counters103320193coun_ters
countess103710053coun_tess
counties10316283counties
counts84618273coun_t_s
cowpokes1944573cowpokes
cowpoxes2244513cowpoxes
cowrites133011593cowrites
cowrote12289673cowrote_
coyote11411783co_yote_
crannoges1244243crannoges
crinites10612763crinites
crunodes1144973crunodes
cyanates13238433cyanates
cyanites132610163cyanites
cyanoses1337423cyanoses
denotes83817003_denotes
donates83217223do_nates
donnees84210363donn_ees
dunnites947173dunnites
endnotes945943endnotes
footnotes1244323footnotes
hognoses12108143hognoses
ionones7313883io_nones
keynotes1543633keynotes
mannites10312613mannites
mannoses1039083mannoses
mongoes103415713mongo_es
montes84226933mo_n_tes
nonnovel1144413nonnovel
nonnovels1243443nonnovels
nonvoter1186893nonvoter
nonvoters12136463nonvoters
notes55034583___notes
pointes93216753poin_tes
pontes83627853po_n_tes
sonneted936183sonneted
sonnets74211993sonnet_s
sonnies7315223sonn_ies
tannates81911953tannates
tonettes839203tonettes
tonnages9187873tonnages
tonnes65320853tonn__es
unnoted8311363_unnoted
woodnotes1344163woodnotes
zoonoses1746203zoonoses

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.436409841.7
2DLD Change Limit1461622316.50022486.5
3Display Results2312310.0932483.9
 (SQL Overall)1786912317.02925422.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.