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

144 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
dioxans155531(None) 
dioxan1465771dioxan_
dioxane1565421dioxane
dioxanes1645371dioxanes
dioxins1568001dioxins
digoxins1744292digoxins
dioxids1655682dioxids
dioxin14118782dioxin_
divans104612392di_vans
diwans105110372di_wans
ajowans1734003ajowans
alloxans1545243alloxans
biogas94310913bioga_s
biogens1038963biogens
biomass1155993biomass
biotas84313923biota_s
biotins93114453biotins
bogans95714813_bogans
brogans1049663brogans
cions75222853cio__ns
cotans81317923_cotans
damans94715983d_amans
dans56748153d___ans
deans66131393d__eans
dedans85915073d_edans
deewans11306903deewans
demeans1039723demeans
deodand1035713deodand
deodands1144603deodands
deodars937623deodars
desmans1039003desmans
dewans105215143d_ewans
dials64925343di__als
diamins10312213diamins
diazins1739183diazins
dickens144410133dickens
digoxin1644943digoxin_
diktats1235623diktats
dinars75417563di_nars
dins56652043di___ns
diobols1036543diobols
diocesans1242483diocesans
diodes83915783dio_des
diols65521013dio__ls
diorama1046533diorama
dioramas1145513dioramas
dioxid1568393diox_id
dioxide1656303dioxide
dioxides1756203dioxides
dipnoans1144103dipnoans
dipsas9359893dipsa_s
diquats1745983diquats
dirams94413703di_rams
dirhams13376313dirhams
disband1138243disband
disbands1237353disbands
disbars10310323disbars
discant103017263discant
discants112912023discants
disdains1037913disdains
dishpans14115833dishpans
dismals102010243dismals
dismays13237433dismays
disowns1136733disowns
distains9413603distains
distant83519953distant
ditas65923673di_ta_s
dittany1135653dittany
diurons838823diurons
divan96114843di_van_
divas95418583di_va_s
diwan95712553di_wan_
dixits144210313di_xits
dizens164911393di_zens
doats65224883d_o_ats
dolmans10479683dolmans
domains10510873d_omains
donas65926473d_ona_s
donnas75511323d_onnas
dons56048703d_o__ns
doodads1035093doodads
dopant9316133d_opant
dopants1038433d_opants
dopas85019063d_opa_s
dovens104413903d_ovens
downs94918573d_o_wns
doxies143917853d_oxies
doyens104810223d_oyens
dozens164612463d_ozens
dromons1038193dromons
drowns105612333dro_wns
durians839573durians
firmans12238523firmans
gobans94412043_gobans
gowans105512293_gowans
groans74815063gro_ans
hogans105914313_hogans
honans94814503_honans
iodins74216523_iodins
ions46737853_io__ns
iotas54821113_iota_s
koans95818623_ko_ans
ligans76817733li_gans
lignans8398853lignans
limans84816303li_mans
lions55923213lio__ns
loans56026463_lo_ans
logans76319063_logans
lorans65117603_lorans
minyans1237263minyans
moans74624373_mo_ans
moxas145014403_moxa_s
oilcans936813oilcans
pians75126963pi__ans
pions75826393pio__ns
pitmans11188743pitmans
prolans9314273prolans
riojas1335813rioja_s
roans54926443_ro_ans
romans84620243_romans
rowans95715343_rowans
ryokans1443293ryokans
shorans102812413shorans
siloxane1543743siloxane
siloxanes1643613siloxanes
silvans10308333silvans
simians959203simians
slogans8407983slogans
solans64122493_solans
somans84619303_somans
sowans94215893_sowans
teopans939203teopans
titans63414913ti_tans
titians72710453titians
tolans64319273_tolans
tomans85419133_tomans
toxins133314283_toxins
violas93713523viola_s
violins10311453violins
vixens16286203vi_xens
wiccans1434603wiccans
wigans104511703wi_gans
witans93412933wi_tans
womans114613653_womans

Search took 7 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.440406115.9
2DLD Change Limit1340271446.36021073.4
3Display Results1441440.0463130.4
 (SQL Overall)1786911446.84626101.5
 
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.