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

142 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
ozonate164686(None) 
odonate848401odonate
ozonated1864591ozonated
ozonates1745961ozonates
zonate154114921_zonate
coronate103018212coronate
donate73619502_donate
neonate7311332neonate
obovate1235462obovate
odonates947742odonates
ornate6315142o_rnate
ozone14310612ozon__e
ozonide1754962ozonide
ozonise1646442ozonise
ozonize1546292ozonize
phonate12411812phonate
pronate9418872pronate
zonae145116442_zona_e
zonated173310532_zonated
aconite9315473aconite
adnate72913483_adnate
agnate73314883_agnate
azonal1568273azona_l
azote144416343azo__te
binate8419773_binate
borate85026153_borate
bromate11313553bromate
cholate122114933cholate
cognate10312203cognate
cohobate1547013cohobate
colocate12313443colocate
comate104124843_comate
connate9315753connate
conte76633203_con_te
coronae94214893corona_e
coronated123313323coronated
coronates1110816923coronates
corotate102813933corotate
cozenage2094793cozenage
crenate93317113crenate
cyanate12259703cyanate
detonate9311193detonate
dominate11312853dominate
donated93513863_donated
donates83217223_donates
ebonite9310293ebonite
elongate945613elongate
emanate9312473emanate
enate54428153__enate
folate93320393_folate
globate1057823globate
innate63917313_innate
intonate8310923intonate
iodate7313503_iodate
iodinate949343iodinate
isolate7313923isolate
khanate1437073khanate
lanate6421263_lanate
lobate82915243_lobate
locate83919843_locate
lunate6316043_lunate
magnate10512703magnate
monte75829773_mon_te
monzonite2044833monzonite
neonates8310063neonates
niobate937703niobate
nominate10312473nominate
nonage7313683_nonage
notate63217863_notate
oblate82214743o_blate
obviate1235793obviate
ocreate93711743ocreate
oleate6318883o_leate
oocyte1135753o_ocyte
oolite63319603o_olite
operate9615733operate
opiate8513463o_piate
orate55133303__orate
ordinate9310253ordinate
ostomate1049573ostomate
outate62923403o_utate
outdate83016423outdate
outrate72323183outrate
ovate84214393__ovate
overate10620963overate
ovulate1039453ovulate
oxalate1457623oxalate
oxidate1537023oxidate
ozonating1944323ozonating
ozonation1845673ozonation
ozones1539393ozon_es
ozonic17308943ozon_ic
ozonides1854293ozonides
ozonised1853893ozonised
ozonises1776373ozonises
ozonized1745113ozonized
ozonizer1654473ozonizer
ozonizes1636083ozonizes
ozonous1645263ozonous
pennate93314033pennate
peonage1048723peonage
phenate12412203phenate
phonated1447893phonated
phonates13410643phonates
phorate12413363phorate
pinnate93613743pinnate
planate9314573planate
probate11414483probate
prolate9419793prolate
pronated11414053pronated
pronates10418373pronates
prorate9418733prorate
protonate11412573protonate
quinate16511573quinate
resonate8513513resonate
rotate63320343_rotate
ruinate7312833ruinate
senate63725173_senate
solate64526073_solate
sonata6313223_sonata
sororate8411173sororate
spinate93114813spinate
stolonate944833stolonate
stomate9313123stomate
tannate71813523tannate
ternate7415483ternate
thionate11137503thionate
togate74515683_togate
umbonate1245293umbonate
unornate848013unornate
urinate7315363urinate
violate10311553violate
zincate1838533_zincate
zoeae144412483_zoea_e
zona136321963_zona__
zonal145116853_zona_l
zonary1838793_zonary
zone135231083_zon__e
zonule1577483_zonule
zoolater1746093zoolater
zoonal1558083zoona_l
zouave1833573_zouave

Search took 9 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.420425454.8
2DLD Change Limit1340271427.76617258.2
3Display Results1421420.0632254.0
 (SQL Overall)1786911428.24921662.1
 
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.