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

141 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
dioxids165568(None) 
dioxid1568391dioxid_
dioxide1656301dioxide
dioxides1756201dioxides
dioxins1568001dioxins
diacids1137862diacids
digoxins1744292digoxins
dioxans1555312dioxans
dioxin14118782dioxi_n
dixits144210312di_xits
doxies143917852d_oxies
droids84712582dro_ids
iodids83711152_iodids
oxids13128962__oxids
trioxids1644442trioxids
aiolis6316843aioli_s
anoxias14259113anoxias
aroids75118223aro_ids
avoids104410203avo_ids
biocide1237323biocide
biocides1336933biocides
bionics114310873bionics
biopics13318543biopics
biotics113812173biotics
biotins93114453biotins
bovids1287973_bovids
bromids12278603bromids
deixis1437243deixi_s
desmids1166603desmids
dexies145018343d_exies
dhobis1236113dhobi_s
dhotis1038973dhoti_s
diacid10310633diacid_
diamide1138473diamide
diamides1238823diamides
diamins10312213diamins
diapirs10347643diapirs
diapsids1244753diapsids
diaries83321953diaries
diazins1739183diazins
dickies143416343dickies
didies84621833di_dies
diesis74013493diesi_s
digits84114533di_gits
digoxin1644943digoxi_n
dikdiks1242563dikdiks
dillies84122163dillies
dimwits1344513dimwits
dingies93618243dingies
dinkies123716033dinkies
diobols1036543diobols
diode74716113dio__de
diodes83915783dio_des
dioecies1138933dioecies
diols65521013dio__ls
diopside1245643diopside
diopsides1345283diopsides
diorite8314913diorite
diorites9313523diorites
dioxan1465773diox_an
dioxane1565423dioxane
dioxanes1645373dioxanes
diploids1247843diploids
dipodies1238413dipodies
dirties83119383dirties
disbuds11125243disbuds
discoids1239873discoids
dismiss1038153dismiss
distils83015803distils
ditties83116983ditties
divide113410893di_vide
divides123211453di_vides
divvies1457663divvies
dixit134420593di_xi_t
dizzies16279753dizzies
dobies94422093d_obies
dogies85022253d_ogies
doilies84017363doilies
doits66223673d_o_its
doobies103915673doobies
doodads1035093doodads
doodies94218773doodies
doolies83920713doolies
doozies173812723doozies
dories75232363d_ories
doxie136017153d_oxi_e
droid74218543dro_id_
droits74314313dro_its
drownds12346153drownds
druids8368093d_ruids
epoxide1745343epoxide
epoxides1844863epoxides
epoxies1637753epoxies
fiords10498623fio_rds
geoids8369843geo_ids
hyoids1377673hyo_ids
idiocies1145223idiocies
imids86015143_i_mids
iodid74315533_iodid_
iodide84812933_iodide
iodides93811613_iodides
iodins74216523_iodins
ionics84214483_ionics
irids66417773_i_rids
ixias12488373_i_xias
ixodids16213363ixodids
kidvids1643113kidvids
lipids94310923li_pids
lipoids1038233lipoids
liquids1735823liquids
loids66220703_lo_ids
miosis83615163miosi_s
miotics112710653miotics
moxies154317403_moxies
nitrids8269633nitrids
nixies135313873ni_xies
ootids71110353_ootids
opioids1036523opio_ids
ovoids10456923ovo_ids
oxid12815483__oxid_
oxide131210953__oxide
oxides14109693__oxides
oxims14107643__oxims
peroxids1837453peroxids
pixies154915513pi_xies
proxies163014933proxies
psocids1234863psocids
sialids839723sialids
sloids73712693slo_ids
solids74116403_solids
tineids8337873tineids
toxics153910203_toxics
toxins133314283_toxins
toxoids1535213_toxoids
trioxid1546613trioxid_
trioxide1644793trioxide
trioxides1744483trioxides
violins10311453violins
viroids1137923viroids
voids95414673_vo_ids
zooids1637093_zooids

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.420425454.8
2DLD Change Limit1340271417.45617975.7
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.92222556.3
 
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.