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

112 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
dioxide165630(None) 
dioxid1568391dioxid_
dioxides1756201dioxides
dioxids1655681dioxids
biocide1237322biocide
diamide1138472diamide
diode74716122dio__de
diopside1245652diopside
diorite8314912diorite
dioxane1565422dioxane
dioxin14118782dioxi_n
dioxins1568002dioxins
divide113410892di_vide
doxie136017152d_oxi_e
epoxide1745342epoxide
iodide84812932_iodide
oxide131210962__oxide
trioxide1644792trioxide
alkoxide2083213alkoxide
biocides1336943biocides
biotite9311033biotite
bolide9515563_bolide
boride9415903_boride
bromide12269583bromide
dayside1236173dayside
debride1138593debride
decide104116873d_ecide
deicide1149403deicide
deionize1858683deionize
deoxidize2743533deoxidize
depside1138413depside
deride84420033d_eride
dexie134716893d_exi_e
diacid10310633diacid_
diacids1137863diacids
diamides1238823diamides
diamine10311983diamine
diazine1738933diazine
dibromide1543563dibromide
dickie133913113dicki_e
didie74120573di_di_e
digoxin1644943digoxi_n
digoxins1744293digoxins
diocese1036853diocese
diodes83915783dio__des
diopsides1345293diopsides
dioptre1055763dioptre
diorites9313523diorites
dioxan1465773diox_an
dioxanes1645373dioxanes
dioxans1555313dioxans
dirtied93210853dirtied
dislike122913453dislike
divided13378593di_vided
divider12278953di_vider
divides123211453di_vides
divine103514463di_vine
divvied1544813divvied
dixit134420593di_xi_t
dixits144210313di_xits
dizzied17236133dizzied
dobie84920333d_obi_e
docile94213123d_ocile
dogie75222793d_ogi_e
domine92918253d_omine
doobie94712683doobi_e
doolie73916833dooli_e
doozie163910653doozi_e
dowie94721143d_owi_e
doxies143917853d_oxies
droid74218543dro_id_
droids84712583dro_ids
ecocide1246743ecocide
epoxides1844863epoxides
epoxied1734823epoxied
hydroxide2445403hydroxide
idolise839293idolise
idolize1737783idolize
imide85716903_i_mide
inside7613453_inside
iodid74315533_iodid_
iodides93811613_iodides
iodids83711153_iodids
iodine74618653_iodine
iodise74214943_iodise
iodize164112593_iodize
iolite63221983_iolite
ionise63516943_ionise
ionize154613873_ionize
lionise7310373lionise
lionize1668823lionize
lipide93511063li_pide
monoxide1846293monoxide
moxie144018123_moxi_e
niobite937953niobite
nitride82811243nitride
nixie125114943ni_xi_e
oroide7311703oro_ide
oxid12815493__oxid_
oxides14109693__oxides
oxids13128973__oxids
oxime1498433__oxime
ozonide1754963ozonide
peroxide1848193peroxide
pixie145415523pi_xi_e
provide1339853provide
riptide1036893riptide
suboxide1845213suboxide
toxine133114123_toxine
trioxid1546613trioxid_
trioxides1744493trioxides
trioxids1644443trioxids

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.390458182.1
2DLD Change Limit1340271126.75019855.9
3Display Results1121120.0333393.9
 (SQL Overall)1786911127.17324911.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.