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

52 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
diuresis94513(None) 
dieresis956851dieresis
diureses936451diureses
anuresis846962anuresis
diaeresis1044772diaeresis
diereses938692diereses
diesis74013492di__esis
digress938322digres_s
diuretic1146992diuretic
diuretics1244952diuretics
duress74712062d_ures_s
enuresis845492enuresis
anureses837973anureses
auxesis1445443_auxesis
depress10239873depres_s
diaereses1045593diaereses
dialysis1245413dialysis
diarists9410363diarists
diathesis1345533diathesis
dieretic1148763dieretic
dieses75218693di__eses
digenesis1145333digenesis
digests93610613di_gests
digresses1137863digresses
dimness1038843dimnes_s
dioceses1137113dioceses
diplosis11128413diplosis
directs102710263di_rects
direst75024243di_res_t
disrelish1345263disrelish
distress9311713distres_s
diurnals943803diurnals
diurons838823diur_ons
divests114510933di_vests
dourest8312943doures_t
dourness947683dournes_s
dress65319833d__res_s
dures65635923d_ure__s
duresses939173d_uresses
editress944933editres_s
enureses838113enureses
fibrosis1345453fibrosis
hidrosis1246303hidrosis
kinesis11259593ki_nesis
milreis937323milre_is
mimesis1137323mi_mesis
neurosis848843neurosis
ourebis936123_ourebis
paresis93315093_paresis
pheresis1377633pheresis
tigress836093tigres_s
virosis1039023vi_rosis

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 Filter1786911461620.423422437.4
2DLD Change Limit146162526.42322756.0
3Display Results52520.0134000.0
 (SQL Overall)178691526.85926052.0
 
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.