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 “diopsides” 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
diopsides134528(None) 
diopside1245641diopside_
biopsies1237382biopsi_es
depsides1238502d_epsides
diapsids1244752diapsid_s
diopsidic1552172diopsidic
dioxides1756202dio_xides
dipsades1246492di_psades
dropsies1138692dropsi_es
topsides1137202_topsides
apoapsides1542383apoapsides
apsides103911303__apsides
biocides1336933bio_cides
biopsied1344593biopsi_ed
daysides1335963d_aysides
depside1138403d_epside_
diamides1238823di_amides
diapsid1146703diapsid__
diodes83915783dio___des
dioecies1138933dioeci_es
dioptases1245903dioptases
dioptres1146113diop_tres
diorites9313523dio_rites
dioxide1656303dio_xide_
dioxids1655683dio_xid_s
dipeptides1643793dipeptides
dipodies1238413dipodi_es
displodes1347863displodes
disprizes2148113disprizes
divides123211453di__vides
docksides17154283docksides
downsides1444813downsides
dropsied1234963dropsi_ed
dropsondes1452673dropsondes
dumpsites1443763dumpsites
firesides1346603firesides
gipsies1039903gi_psi_es
hillsides1344553hillsides
insides8512653_i_nsides
iodides93811613_io_dides
ironsides1045293ironsides
kingsides1543853kingsides
lipides103810623li_p_ides
lopsided1244253_lopsided
poolsides1254553poolsides
popsies112816463_popsi_es
ringsides1144743ringsides
riptides1136413ri_ptides
shipsides1544883shipsides
topside1037733_topside_
topsider1144503_topsider
topsiders1243023_topsiders
upsides10319633__upsides

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 Filter1786911486410.423422437.4
2DLD Change Limit148641536.15324157.5
3Display Results53530.0163312.5
 (SQL Overall)178691536.59227107.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.