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 “dioxanes” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

74 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
dioxanes164537(None) 
dioxane1565421dioxane_
dioxans1555311dioxan_s
dioxan1465772dioxan__
dioxides1756202dioxides
dioxins1568002dioxin_s
siloxanes1643612siloxanes
biogases1136143biogases
biplanes1238573biplanes
boranes93720403_boranes
decanes103118913d_ecanes
deodands1144603deodands
deplanes11311213deplanes
diabases1137223diabases
diamantes1296263diamantes
diamines11311643diamines
diazines1838713diazines
dictates11311383dictates
dienes75719903di__enes
digoxins1744293digoxin_s
dilates83220663di_lates
dines66449153di___nes
dioceses1137113dioceses
diodes83915783dio__des
dioecies1138933dioecies
dioptases1245903dioptases
dioptres1146113dioptres
dioramas1145513dioramas
diorites9313523diorites
dioxide1656303dioxide_
dioxids1655683diox_ids
dioxin14118783dioxin__
dipsades1246493dipsades
disbands1237353disbands
discants112912023discants
discases112014503discases
diseases92415813diseases
disrates91118153disrates
dissaves1239413dissaves
distances12311653distances
distaves12311403distaves
dittanies1045733dittanies
divans104612393di_van_s
divines113514723di_vines
diwans105110373di_wan_s
dogbanes1245433dogbanes
dogvanes1344303dogvanes
domaines11611063d_omaines
domines102918973d_omines
donates83217223d_onates
dopants1038433d_opants
dosages92310803d_osages
dotages92311793d_otages
doxies143917853d_ox_ies
drones75023433dro__nes
duotones937643duotones
fixates1737393fi_xates
hexanes17319463_hexanes
inanes62519803_i_nanes
iodates8312903_iodates
iodines83616633_iodines
ionones7313883_ionones
lianes63819323li__anes
lindanes939173lindanes
niobates1037283niobates
profanes132311573profanes
propanes122415823propanes
silanes72517163si_lanes
siloxane1543743siloxane_
tisanes7311853ti_sanes
tolanes74216313_tolanes
toxines142912263_toxines
violates11311193violates
violones1137383violones

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.466383457.1
2DLD Change Limit146162747.47019566.5
3Display Results74740.0332242.4
 (SQL Overall)178691747.96922423.3
 
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.