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

121 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
ozonates174596(None) 
odonates947741odonates
ozonate1646861ozonate_
ozonated1864591ozonated
coronates1110816922coronates
donates83217222_donates
neonates8310062neonates
odonate848402odonate_
ozones1539392ozon__es
ozonides1854292ozonides
ozonises1776372ozonises
ozonizes1636082ozonizes
phonates13410642phonates
pronates10418372pronates
zonate154114922_zonate_
zonated173310532_zonated
aconites10314343aconites
agnates82813183_agnates
annates72415423_annates
azotes154312223azo__tes
borates94823013_borates
bromates12413133bromates
cholates132414743cholates
cognates11311573cognates
cohobates1646513cohobates
colocates13312853colocates
comates114123633_comates
conatus9310463_conatus
contes84432913_con_tes
coronate103018213coronate_
coronated123313323coronated
corotates112714283corotates
cozenages2194693cozenages
cyanates13238423cyanates
detonates10310423detonates
dominates12311743dominates
donate73619503_donate_
donated93513863_donated
ebonites1039223ebonites
elongates1045383elongates
emanates10311333emanates
enates64026423__enates
folates103218453_folates
frontes104214163fron_tes
intonates9410233intonates
iodates8312893_iodates
iodinates1048203iodinates
isolates8613513isolates
khanates1535733khanates
locates93218813_locates
magnates11511603magnates
monades103713823_monades
montes84226933_mon_tes
monzonites2144303monzonites
nates55238333___nates
neonate7311333neonate_
niobates1037273niobates
nominates11311053nominates
nonages8313843_nonages
notates72817483_notates
oblates91913243o_blates
obovate1235463obovate_
obviates1345153obviates
oleates7417833o_leates
oocytes1246063o_ocytes
oolites72817843o_olites
operates10515403operates
opiates9312143o_piates
orates64328613__orates
ordinates1049003ordinates
ornate6315133o_rnate_
ostomates1149343ostomates
outdates93114743outdates
outrates82421363outrates
ovulates1148523ovulates
oxalates1557063oxalates
oxidates1636333oxidates
ozonating1944323ozonating
ozonation1845673ozonation
ozonations1945143ozonations
ozone14310613ozon__e_
ozonide1754963ozonide_
ozonise1646443ozonise_
ozonised1853893ozonised
ozonize1546293ozonize_
ozonized1745113ozonized
ozonizer1654473ozonizer
ozonizers1753233ozonizers
ozonous1645263ozon_ous
penates93321593_penates
peonages1138473peonages
phenates13611563phenates
phonate12411813phonate_
phonated1447893phonated
phorates13413043phorates
pontes83627853_pon_tes
probates12414263probates
pronate9418873pronate_
pronated11414053pronated
prorates10418063prorates
protonates12411683protonates
resonates9412403resonates
rotates72819773_rotates
ruinates8311883ruinates
senates73322583_senates
solates73523853_solates
sonatas7510293_sonatas
sororates9410463sororates
stomates10313343stomates
tannates81911953tannates
thionates12106643thionates
urinates8314133urinates
violates11311183violates
zincates1937733_zincates
zonae145116443_zona_e_
zones145528043_zon__es
zonules1647793_zonules
zoolater1746093zoolater
zoolaters1844973zoolaters
zoonoses1746203zoonoses
zouaves1933893_zouaves

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.1731032896.0
2DLD Change Limit1461621217.29620033.2
3Display Results1211210.0631920.6
 (SQL Overall)1786911217.53223724.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.