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

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

47 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
discretionary196226(None) 
accretionary1961443_accretionary
concretionary2062853concretionary
dictionary1654583di_c__tionary
discretion1347523discretion___
discretions1447223discretion__s
secretionary1752433_secretionary
digressionary1861574di_gressionary
disciplinary2062434discipli_nary
diversionary1962034diver_sionary
cautionary1553925___cautionary
decretory1544675d_ecret_o__ry
deflationary1952275d_eflationary
devolutionary2062985devolutionary
dictional1268605di_c__tiona_l
dictionally1755975di_c__tionally
directional1445435di__rectiona_l
discerningly1952955discerni_ngly
discreditably2262205discreditably
discrepancy2151825discre_pan_cy
discrepantly2062025discre_pantly
discretely1653695discret___ely
discreteness1554485discret_eness
discriminably2362805discrimi_nably
discriminant17113185discrimi_nant
discriminate17164805discrimi_nate
discriminatory2262505discrimi_natory
disinflationary2271365disinflationary
distortional1353485distortiona_l
elocutionary1762375eloc_utionary
extortionary2262695extor_tionary
functionary1953755func__tionary
incretion1149055_incretion___
incretions1248655_incretion__s
indiscretion1552805indiscretion___
indiscretions1652585indiscretion__s
inflationary1852745_inflationary
insurrectionary2071335insurrectionary
lectionary1554825_lec__tionary
libationary1672165li__bationary
miscreation1547715miscreation___
miscreations1647055miscreation__s
missionary1553665mis___sionary
precautionary2062265precautionary
reactionary1653695reac__tionary
stationary1354155__s_tationary
visionary1544035vis____ionary

Search took 9 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 Filter1786911247900.1401276364.3
2DLD Change Limit124790478.56314573.2
3Display Results47470.0301566.7
 (SQL Overall)178691478.73320461.6
 
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.