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

53 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
diopside124564(None) 
diopsides1345281diopsides
biopsied1344592biopsied
depside1138402d_epside
diapsid1146702diapsid_
diapsids1244752diapsids
diopsidic1552172diopsidic
dioxide1656302dio_xide
dropsied1234962dropsied
topside1037732_topside
biocide1237323bio_cide
biopsic1345523biopsi_c
biopsies1237383biopsies
dayside1236173d_ayside
depsides1238503d_epsides
diamide1138473di_amide
diode74716113dio___de
dioptase1145513dioptase
dioptre1055763diop_tre
diorite8314913dio_rite
dioxid1568393dio_xid_
dioxides1756203dio_xides
dioxids1655683dio_xids
dipeptide1544463dipeptide
dipsades1246493di_psades
displode1247643displode
disprize2048433disprize
divide113410893di__vide
divisive1545013divisive
dockside16154743dockside
donsie7613643d_onsi_e
downside1345293downside
dropsies1138693dropsies
dropsonde1342543dropsonde
dumpsite1344293dumpsite
fireside1247003fireside
gipsied1135873gi_psied
hillside1254673hillside
inside7613453_i_nside
iodide84812933_io_dide
ironside945853ironside
kingside1444263kingside
lipide93511063li_p_ide
lopsided1244253_lopsided
onside7511803__onside
poolside1145043poolside
popsie103013053_popsi_e
ringside1045403ringside
riptide1036883ri_ptide
shipside1445033shipside
topsider1144503_topsider
topsides1137203_topsides
upside9289803__upside

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.420425454.8
2DLD Change Limit146162536.97020970.2
3Display Results53530.0301766.7
 (SQL Overall)178691537.42024082.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.