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

50 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
savoriness135493(None) 
savories11311272savori_e_s
savoriest1246612savori_est
savorinesses1544612savorinesses
savorless1243212savor_less
savviness1534712sav_viness
airiness8412213_a_iriness
angriness1036453_angriness
favorites1546583favorite_s
goriness9310753__goriness
hairiness1238013ha_iriness
paltriness1244993paltriness
paperiness1446133paperiness
saltiness93312113sa_ltiness
sandiness102111713sa_ndiness
saponines1148043saponine_s
sappiness1337433sa_ppiness
sassiness8249333sa_ssiness
sauciness1138043sa_uciness
savageness1444063savageness
savarins1139893savarin__s
savines104417633sav__ine_s
savorers1157223savor__ers
savorier1136643savori_e_r
savoring1269483savorin__g
savouries1245473savouri_e_s
savouriest1343033savouri_est
scariness11310183s_cariness
severeness1346123severeness
shadowiness1842113shadowiness
shortness1236733s_hortness
showiness1576073s_howiness
silveriness1443853silveriness
smokiness1535543s_mokiness
snootiness1085833snootiness
snowiness1296243s_nowiness
sootiness999833s_ootiness
soreness8914793s__oreness
sorriness939583s_orriness
spookiness1644433spookiness
sportiness1278233s_portiness
stoniness938343s_toniness
storminess1245213s_torminess
sultriness1045563sultriness
taborines11238983taborine_s
tarriness9229243ta_rriness
tawdriness1482843tawdriness
wariness11313213wa__riness
wateriness1348073wateriness
waviness1437723wav__iness

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 Filter1786911406030.503355250.5
2DLD Change Limit140603506.57621381.2
3Display Results50500.0163125.0
 (SQL Overall)178691507.09525185.5
 
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.