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

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

46 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
disinflationary227136(None) 
disinflation1656583disinflation___
disinflations1756283disinflation__s
inflationary1852743___inflationary
noninflationary2181303noninflationary
deflationary1952274d___eflationary
discretionary1962265dis__cretionary
disinfection1855095disinfection___
disinfections1954885disinfection__s
reflationary1872615___reflationary
stagflationary217765_stagflationary
confectionary2353756__confectionary
devolutionary2062986d__evolutionary
dictionary1654576d__i___ctionary
disciplinary2062436discipl__i_nary
disinclination1763966disinclination___
disinclinations1863586disinclination__s
disinfecting1954696disinfecti_n__g
disinfestation18113616disinfestation___
disinfestations1993496disinfestation__s
disinfesting1754436disinfesti_n__g
disinformation2063336disinformation___
disinformations2173306disinformation__s
dispensational1762506dispensationa_l
disrelation1248816dis_relation___
disrelations1348496dis_relation__s
dissertational1562576dissertationa_l
dissimilation1656526dissimilation___
dissimilations1755866dissimilation__s
dissimilatory1963046dissimilat_o__ry
dissimulation1655376dissimulation___
dissimulations1754906dissimulation__s
distillation1347736distillation___
distillations1446946distillation__s
divination14139236divin__ation___
divinations15128416divin__ation__s
divinatory1743936divin__at_o__ry
inflation12311096___inflation___
inflationism1753476___inflationism
inflationist1555286___inflationist
inflations13310326___inflation__s
libationary1672166__li__bationary
nonstationary1672126__nonstationary
reinflation1447206_reinflation___
reinflations1546646_reinflation__s
stationary1354156__s___tationary

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 Filter178691950240.1231452772.4
2DLD Change Limit95024468.62611016.0
3Display Results46460.0301533.3
 (SQL Overall)178691468.77920354.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.