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

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

38 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
deciduousness175402(None) 
deciduousnesses1953872deciduousnesses
assiduousness1353253assiduousness
decorousness1586173dec_orousness
deliciousness16116633deliciousness
deliriousness1496713deliriousness
desirousness1356873desi_rousness
deviousness1547273devi__ousness
exiguousness2054253_exiguousness
ambiguousness1853184ambiguousness
arduousness1255774__arduousness
decidedness16103794decid__edness
deciduous1342614deciduou____s
dexterousness2154624dexterousness
dubiousness1446244dubi__ousness
heinousness1455584he_i_nousness
hideousness1555224__hideousness
insidiousness1486094insidiousness
invidiousness1785614invidiousness
lecherousness1864074lecherousness
melodiousness1655304melodiousness
meticulousness1872674meticulousness
pendulousness1654204pe_ndulousness
perfidiousness2054134perfidiousness
perilousness1457794peri_lousness
preciousness1648474preci__ousness
religiousness1486374religiousness
seditiousness1476434seditiousness
sedulousness1365024se__dulousness
sensuousness1155334se_nsuousness
seriousness11410164seri__ousness
sinuousness1146914__sinuousness
speciousness1647554speci__ousness
tediousness1247764te__diousness
tenuousness1146684te__nuousness
unctuousness1455334unc_tuousness
vacuousness1645884vac__uousness
viciousness1647944vici__ousness

Search took 6 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.356501941.0
2DLD Change Limit95024385.39317619.9
3Display Results38380.0301266.7
 (SQL Overall)178691385.77930920.7
 
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.