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

279 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
aconites1031435(None) 
aconite9315471aconite_
taconites1148471taconites
acolytes13168042acolytes
aconitic1239532aconitic
aconitum1243742aconitum
aconitums1342612aconitums
adonises92611432adonises
agonies83016622agoni_es
agonises92613162agonises
agonistes10266262agonistes
agonizes182610582agonizes
alunites8310702alunites
ammonites1348142ammonites
amosites10311232amosites
arenites8917102arenites
atonies75320952atoni_es
conies84338592_coni_es
conines93827792_conines
contes84432912_con_tes
ebonites1039232ebonites
ichnites1345742ichnites
masonites1149172masonites
saponites1139942saponites
taconite1049312taconite_
acarines10314343acarines
accretes1238113accretes
acetates102013063acetates
achiotes1339003achiotes
achondrites1753363achondrites
acidities12810183acidities
acnes75922623ac_n__es
acnodes1037833ac_nodes
acolyte12157653acolyte_
acquires1945403acquires
acquits1857293acquit_s
acroliths1445113acroliths
actinides12188323actinides
actives12311523ac_tives
actuates10310313actuates
acuities10312453ac_uities
acutes83917723ac__utes
acylates1339743acylates
adenines9310193adenines
adenitis947433adenitis
adonis7314063adoni__s
aerolites9312583aerolites
agenizes18269743agenizes
agnates82813193a_gnates
agnizes17328843a_gnizes
agones75719863agon__es
agonise83112693agonise_
agonised10248483agonised
agonists9289833agonists
agonize172911403agonize_
agonized19258993agonized
agouties9337693agouties
alanines8314803alanines
albites9313203a_lbites
allanites949803allanites
alunite7311633alunite_
amanitas1048533amanitas
amazonites2143613amazonites
amenities11310433amenities
aminities11312913aminities
ammoniates1444793ammoniates
ammonite1249143ammonite_
amniotes1036603a_mniotes
amosite9313163amosite_
anchorites1547763anchorites
ancones93116343ancon__es
animes84719593a__nimes
anises64826693a__nises
annates72415423a_nnates
anodizes1837963anodizes
anointed938343anointed
anointer837823anointer
anointers937003anointers
anoints7311063anoint_s
anolytes11169213anolytes
anomies93316993anomi_es
antes56334323a__n_tes
apatites10311293apatites
aphanites1448273aphanites
aplites9314933a_plites
apomixes1934853apomixes
aragonites1145803aragonites
arenite71017713arenite_
arointed939003arointed
aroints7313133aroint_s
arsenites9149163arsenites
ascites9312603a_scites
astonies8815093astoni_es
atomies93918363atomi_es
atomises103514403atomises
atomizes192711433atomizes
atones65225773aton__es
atonias73315993atoni_as
atonics93613713atoni_cs
atopies92816433atopi_es
attrites8311563attrites
augites8312183a_ugites
aunties73920073a_unties
autunites946203autunites
avodires1244123avodires
axites134913833a__xites
axonemes1744333axonemes
axones134614513axon__es
azotes154312223azo__tes
azotises1737603azotises
azotizes1636853azotizes
azurites1737283azurites
backbites19108633backbites
balconies1347753balconi_es
baronies10315023baroni_es
biotites10310083biotites
boites84322703_bo_ites
bonitas939453_bonitas
bonitoes1038153_bonitoes
bonitos939733_bonitos
boonies93422483booni_es
bornites10310983bornites
calcites12313003calcites
canines93724033_canines
canities101519263_canities
canonises11410803canonises
canonizes2049593canonizes
caponizes2238703caponizes
carnies94123963carni_es
cenotes92814543_cenotes
cerites94823433_cerites
cites74435593_c__ites
codices12512583_codices
coesites101313093_coesites
cogitos1037613_cogitos
cognates11311583_cognates
cognises11610043_cognises
cognizes2058033_cognizes
cointer93616723_cointer
cointers103616413_cointers
coitus8511893_co_itus
colies84837053_coli_es
colitis92617353_colitis
comates114123643_comates
comities12317793_comities
comtes106222813_co_mtes
conatus9310463_conatus
conches144019813_conches
condoes104319203_condoes
cones76457423_con__es
confides14310573_confides
confines13315653_confines
confits122811423_confit_s
confutes1339843_confutes
congees103517923_congees
conges94928173_con_ges
congoes103617303_congoes
conics103920593_coni_cs
conifer123212643_conifer
conifers133611703_conifers
coniines10415363_coniines
conine84528553_conine_
conins84327233_coni_ns
conioses10313313_conioses
coniums11311863_coniums
connives1339723_connives
connotes10311453_connotes
conte76633203_con_te_
contest93523233_con_test
contos84923233_con_tos
coonties10513803coonties
cooties93725733_cooties
copies104130303_copi_es
cordites11314623_cordites
cornices12713293_cornices
cosies84932153_cosi_es
cosines94122673_cosines
cotes76347843_co__tes
counties10316283_counties
cowrites133011593_cowrites
coxitis16238463_coxitis
coyotes12410703_coyotes
cozies174521413_cozi_es
crinites10612763crinites
cronies9622503croni_es
curites93919863_curites
cyanites132610163cyanites
cyclonites1744913cyclonites
dacites101114593dac__ites
dacoities1248213daco_ities
dacoits1079073daco_it_s
dawsonites1442533dawsonites
diaconates1346703diaconates
diorites9313523diorites
donates83217223_donates
dunites8313593_dunites
dunnites947173dunnites
ebonies9312883eboni_es
ebonises1039223ebonises
ebonite9310293ebonite_
ebonizes1938073ebonizes
eclogites1245263eclogites
ecocides1346583ecocides
essonites945153essonites
favorites1546583favorites
finites10315923_finites
fomites123613203_fomites
frontes104214163fron_tes
gahnites1235703gahnites
galenites10129183galenites
glauconites1492613glauconites
goonies83618333gooni_es
granites92116363granites
gunites8313123_gunites
ichnite1245983ichnite_
icones84616383icon__es
ignites81310583_ignites
inosites8312793inosites
iolites73819483_iolites
ionises72916433_ionises
ionizes162813343_ionizes
ironies7517423ironi_es
ironizes17510373ironizes
jaconets1745613jaconet_s
jarosites1647373jarosites
kainites1238793kainites
kernites1269113kernites
kyanites15216683kyanites
laborites1149263laborites
laconisms1347013laconisms
lenites7818443_lenites
lignites9129613lignites
limonites1148003limonites
lionises8310313lionises
lionizes1738773lionizes
loonies73919543looni_es
mannites10312613mannites
masonite1049683masonite_
monies83233163_moni_es
montes84226933_mon_tes
mylonites1446453mylonites
neonates8310063neonates
niobites1037313niobites
nites55736343___nites
norites74018803_norites
odonates947743odonates
oolites72817843_oolites
ozonates1745963ozonates
ozonides1854293ozonides
ozonises1776373ozonises
ozonizes1636083ozonizes
peonies93620153peoni_es
phonates13410643phonates
phonies123717513phoni_es
pinites9319533_pinites
podites103014733_podites
pointes93216753_pointes
ponies84833463_poni_es
pontes83627853_pon_tes
pronates10418373pronates
reunites8312473reunites
saponines1148043saponines
saponite10410533saponite_
saxonies1537913saxoni_es
scanties103215423scanties
scolices1238733scolices
sconces113811453scon_ces
scones84521303scon__es
scotties1039753scotties
sienites8311913sienites
somites94219123_somites
sopites93817173_sopites
sorites73825243_sorites
syenites1138943syenites
thorites11312393thorites
toonies73719883tooni_es
unites65024853__unites
uranites82514643uranites
zeolites1738383zeolites

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 Limit1461622797.40619735.6
3Display Results2792790.1262214.3
 (SQL Overall)1786912797.96822426.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.