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

285 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
aconite931547(None) 
aconites10314351aconites
taconite1049311taconite
acolyte12157642acolyte
aconitic1239532aconitic
aconitum1243742aconitum
agonise83112692agonise
agonize172911402agonize
alunite7311632alunite
ammonite1249142ammonite
amosite9313162amosite
arenite71017712arenite
conine84528552_conine
conte76633202_con_te
ebonite9310292ebonite
ichnite1245982ichnite
masonite1049682masonite
saponite10410532saponite
taconites1148472taconites
acarine9316003acarine
accrete1137843accrete
acerate92818913acerate
acetate92514753acetate
achiote1239213achiote
achondrite1653253achondrite
acidity1338593acidity
acini75718983acini__
acinic104713543acini_c
acinose938573acinose
acne66625873ac_n__e
acnode938193ac_node
acolytes13168033acolytes
aconitums1342613aconitums
acquire1835603acquire
acquit17610323acquit_
acquits1857293acquits
acrolith1348453acrolith
acronic112814693acroni_c
actiniae101810013actiniae
actinide11199213actinide
active11313743ac_tive
actuate9311443actuate
acuate8315633ac_uate
acuity1139373ac_uity
acute74720363ac__ute
acylate12310533acylate
adenine8311213adenine
adnate72913483a_dnate
adonis7314063adoni_s
adonises92611433adonises
aeonian738353aeonian
aeonic83517043aeoni_c
aerolite8315053aerolite
agenize172910153agenize
agnate73314883a_gnate
agnize16329563a_gnize
agone65924553agon__e
agonic93515143agoni_c
agonies83016623agonies
agonised10248483agonised
agonises92613163agonises
agonist82615403agonist
agonistes10266263agonistes
agonists9289833agonists
agonized19258993agonized
agonizes182610583agonizes
alanine7316863alanine
albite8313313a_lbite
allanite8411093allanite
alone55732963alon__e
alunites8310703alunites
amanita9310453amanita
amazonite2044213amazonite
amenity1238333amenity
aminity12310513aminity
ammoniate1345483ammoniate
ammonites1348143ammonites
amniote936963a_mniote
amosites10311233amosites
anchorite1448823anchorite
ancone83916953ancon__e
anile54634463a__nile
anime75423203a__nime
anise55129703a__nise
anodize1738673anodize
anoint6423633anoint_
anointed938343anointed
anointer837823anointer
anoints7311063anoints
anolyte10158993anolyte
anomie83215963anomi_e
ante46538903a__n_te
apatite9312963apatite
aphanite1348773aphanite
aplite8316393a_plite
apposite12410013apposite
aragonite1046463aragonite
arenites8917103arenites
aroint6328153aroint_
arointed939003arointed
aroints7313133aroints
arsenite8119663arsenite
asinine7310723asinine
atomise93013823atomise
atomize183111823atomize
atone56527983aton__e
atonia63816513atoni_a
atonias73315993atonias
atonic83420473atoni_c
atonics93613713atonics
atonies75320953atonies
atoning83514873atoning
attrite7311833attrite
augite7312613a_ugite
auntie64317703a_untie
autunite856693autunite
avodire1143763avodire
axite125218253a__xite
axone125918473axon__e
axoneme1644783axoneme
axonic154312723axoni_c
azonic175513153azoni_c
azote144416343azo__te
azotise1637073azotise
azotize1537083azotize
azurite1638003azurite
backbite1899173backbite
biotite9311033biotite
boite74426323_bo_ite
bonita8312943_bonita
bonito8313433_bonito
bornite9311183bornite
calcite11413783calcite
canine83826703_canine
cannie83819363canni_e
canonise10511093canonise
canonize1959833canonize
caponize2139113caponize
carnie84421093carni_e
cenote83715843_cenote
cerite84724873_cerite
cite65640343_c__ite
coesite9713623_coesite
cogito939203_cogito
cognate10312203_cognate
cognise1059683_cognise
cognize1957683_cognize
cointer93616723_cointer
comate104124843_comate
comity13312713_comity
comte96125473_co_mte
concise11314473_concise
cone67256963_con__e
confide13310203_confide
confine12315583_confine
confit113316403_confit_
confits122811423_confits
confute1239263_confute
conge85227593_con_ge
congee96024463_congee
coni65534803_coni__
conic95329793_coni_c
conics103920593_conics
conies84338593_conies
conifer123212643_conifer
coniine9316803_coniine
conin76232723_coni_n
conines93827793_conines
coning94331823_coning
conins84327233_conins
conium10415313_conium
connate9315753_connate
connive1238993_connive
connote9311613_connote
contes84432913_con_tes
conto76027173_con_to
contrite10318543_contrite
coontie9311423coontie
cootie84223093_cootie
cordite10315263_cordite
cornice11612933_cornice
cornute939643_cornute
cosie74728263_cosi_e
cosine83823513_cosine
cote66648733_co__te
cowrite123612683_cowrite
coyote11411783_coyote
cozie163519133_cozi_e
crinite9513633crinite
curite85222943_curite
cyanite122710763cyanite
cyclonite1645453cyclonite
dacite91115883dac__ite
dacoit9415453daco_it_
dacoits1079073daco_its
dacoity1366183daco_ity
dawsonite1342703dawsonite
diaconate1247193diaconate
diorite8314913diorite
donate73619503_donate
dunite7315013_dunite
dunnite857333dunnite
ebonise939613ebonise
ebonites1039233ebonites
ebonize1838153ebonize
eclogite1146303eclogite
ecocide1246733ecocide
essonite845733essonite
falconine1445173falconine
favorite1447313favorite
finite9316823_finite
fomite113314073_fomite
gahnite1135973gahnite
galenite91210063galenite
glauconite13102613glauconite
goonie73615563gooni_e
granite82017083granite
gunite7414403_gunite
ichnites1345743ichnites
iconic10411593iconi_c
ignite71410583_ignite
incondite1246553incondite
inosite7314063inosite
iolite63221983_iolite
ionise63516943_ionise
ionize154613873_ionize
ironize16610373ironize
jaconet16311483jaconet_
jaconets1745613jaconets
jarosite1548383jarosite
kainite1149543kainite
kernite1159473kernite
kyanite14237313kyanite
laborite10410693laborite
laciniate1156843laciniate
laconic1139883laconi_c
laconism1248043laconism
lacunate10128963lacunate
lenite6719983_lenite
leonine7311233leonine
lignite81310303lignite
limonite1048163limonite
lionise7310373lionise
lionize1668823lionize
loonie64216453looni_e
mannite9312903mannite
masonites1149173masonites
monie75631653_moni_e
monte75829773_mon_te
mylonite1346813mylonite
neonate7311333neonate
niobite937953niobite
nite45943583___nite
norite63221133_norite
odonate848403odonate
oolite63319603_oolite
ozonate1646863ozonate
ozonide1754963ozonide
ozonise1646443ozonise
ozonize1546293ozonize
pavonine1346663pavonine
phonate12411813phonate
pinite8321243_pinite
podite93315353_podite
pointe84619313_pointe
polite83625073_polite
pronate9418873pronate
recondite1248963recondite
reunite7312713reunite
saponine1039223saponine
saponites1139943saponites
sconce104711723scon_ce
scone74621833scon__e
scoriae9310903scoriae
scottie937463scottie
sienite7312713sienite
somite84519373_somite
sopite84917713_sopite
syenite1039773syenite
thorite10313443thorite
toonie63617993tooni_e
unite54828383__unite
uranite72515693uranite
zeolite1638903zeolite
zonate154114923_zonate

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.1561145455.1
2DLD Change Limit1340272856.72019944.5
3Display Results2852850.1102590.9
 (SQL Overall)1786912856.98625578.4
 
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.