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

36 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
dysuric134453(None) 
dysuria1144921dysuria
daturic1047032daturic
dysurias1244462dysurias
anuric8812113_anuric
auric74521743__auric
caesuric1244233caesuric
cystic132710653cys_tic
daric85623123d__aric
desertic1147743desertic
dimeric12310023dimeric
dineric10310973dineric
disomic1238763disomic
district11413873district
duroc84513143d__uroc
dyadic1336093dy_adic
dynamic1545813dynamic
dyscrasic1752633dyscrasic
dyscratic1744213dyscratic
dysgenic1544283dysgenic
dyslexic2162893dyslexic
dysphoric2044023dysphoric
dyspneic1642833dyspneic
dyspnoic1643133dyspnoic
dystonic1446513dystonic
gastric1038643gastric
hydric15227953hy_dric
hysteric1647533hysteric
lyric104512723ly__ric
mystic132711643mys_tic
pyloric1438063pyloric
pyric123815073py__ric
pyuria1136953py_uria
tsuris62710203_tsuris
uric63624943___uric
yttric1145433_yttric

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 Filter1786911340270.423422437.4
2DLD Change Limit134027366.82619634.8
3Display Results36360.0162250.0
 (SQL Overall)178691367.26524596.1
 
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.