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

164 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
odonate84840(None) 
donate73619501_donate
odonates947741odonates
ozonate1646861ozonate
adnate72913482ad_nate
coronate103018212coronate
donated93513862_donated
donates83217222_donates
iodinate949342iodinate
neonate7311332neonate
obovate1235462obovate
ordinate9310252ordinate
ornate6315142o_rnate
ozonated1864592ozonated
ozonates1745962ozonates
phonate12411812phonate
pronate9418872pronate
zonate154114922_zonate
aconite9315473aconite
adulate8313233adulate
aduncate1145573aduncate
advocate1445833advocate
agnate73314883_agnate
binate8419773_binate
borate85026153_borate
bromate11313553bromate
cholate122114933cholate
coadunate1245643coadunate
cognate10312203cognate
cohobate1547013cohobate
colocate12313443colocate
comate104124843_comate
connate9315753connate
conte76633203_con_te
coronae94214893corona_e
coronated123313323coronated
coronates1110816923coronates
corotate102813933corotate
crenate93317113crenate
cyanate12259703cyanate
date56443323_d__ate
debate94419193_debate
delate73827753_delate
denote74118043_denote
dentate8315153_dentate
derate74531233_derate
detonate9311193detonate
dilate73220693_dilate
doat56947673_do_at_
doated84118183_do_ated
doats65224883_do_ats
dominate11312853dominate
dona55529633_dona__
donas65926473_dona_s
donative12139873_donative
donator8310263_donator
done55747913_don__e
donee66931013_don_ee
dongle83612493_dongle
donne65520463_don_ne
donnee74317063_donnee
donsie7613643_donsie
donut6324513_donut_
donuts7410583_donuts
dosage82810003_dosage
dotage82711613_dotage
dote55442883_do__te
dunite7315013_dunite
ebonite9310293ebonite
edentate947703edentate
educate10310213educate
elongate945613elongate
emanate9312473emanate
enate54428153__enate
folate93320393_folate
globate1057823globate
ideate7313683id_eate
idolater936863idolater
innate63917313_innate
intonate8310923intonate
iodate7313503_iodate
iodinated1146943iodinated
iodinates1048203iodinates
isolate7313923isolate
khanate1437073khanate
lanate6421263_lanate
lobate82915243_lobate
locate83919843_locate
lunate6316043_lunate
magnate10512703magnate
moderate11710993moderate
modulate1138593modulate
monte75829773_mon_te
neonates8310063neonates
niobate937703niobate
nominate10312473nominate
nonage7313683_nonage
notate63217863_notate
obdurate1175123obdurate
oblate82214743o_blate
obviate1235783obviate
ocreate93711743ocreate
odometer1147413odometer
odorant8411393odorant
odorants946043odorants
odorize1737403odorize
oleate6318883o_leate
oocyte1135753o_ocyte
oolite63319603o_olite
operate9615733operate
opiate8513463o_piate
orate55133303__orate
ordinates1049003ordinates
ostomate1049573ostomate
outate62923403o_utate
outdate83016423outdate
outrate72323183outrate
ovate84214393__ovate
overate10620963overate
ovulate1039453ovulate
oxalate1457623oxalate
oxidate1537023oxidate
ozone14310613ozon__e
ozonide1754963ozonide
ozonise1646443ozonise
ozonize1546293ozonize
pennate93314033pennate
peonage1048723peonage
phenate12412203phenate
phonated1447893phonated
phonates13410643phonates
phorate12413363phorate
pinnate93613743pinnate
planate9314573planate
probate11414483probate
prolate9419793prolate
pronated11414053pronated
pronates10418373pronates
prorate9418733prorate
protonate11412573protonate
quinate16511573quinate
resonate8513513resonate
rhodonite1344513rhodonite
rotate63320343_rotate
ruinate7312833ruinate
senate63725173_senate
sodomite11136913sodomite
solate64526073_solate
sonata6313223_sonata
sororate8411173sororate
spinate93114813spinate
stolonate944833stolonate
stomate9313123stomate
tannate71813523tannate
ternate7415483ternate
thionate11137503thionate
togate74515683_togate
umbonate1245293umbonate
unornate848013unornate
urinate7315363urinate
violate10311553violate
woodnote1244153woodnote
zonae145116443_zona_e
zonated173310533_zonated

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.406440125.6
2DLD Change Limit1340271646.58020368.8
3Display Results1641640.0602733.3
 (SQL Overall)1786911647.04625360.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.