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

43 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
salutariness125316(None) 
salutarinesses1462772salutarinesses
solitariness1283922solitariness
paltriness1244993pal_t_riness
saltiness93312113sal_t__iness
sultriness1045563sul_t_riness
voluntariness1662793voluntariness
alizarines1944664_alizarine_s
bleariness1246054_bl_eariness
blurriness1243484_blu_rriness
dilatoriness1352594dilatoriness
faultiness1344824fault__iness
glariness1038554_gl__ariness
glutamines1343504_glutamine_s
illusoriness1262094illusoriness
klutziness2342274_klut_ziness
maltiness112910574mal_t__iness
saintliness1144154saint_liness
salaries8319574sal__ari_e_s
saltines82917794sal_t__ine_s
saltness82610244sal_t___ness
salutarily1353424salutari__ly
salutations1147644salutati_ons
salutatories1262314salutatori_e_s
sanitaries1049914sanitari_e_s
sauciness1138044sa_u__ciness
sauternes947024sa_uter_ne_s
savoriness1354934sa__voriness
scariness11310184s___cariness
silveriness1443854sil_veriness
slatiness92511364s_l__atiness
sleaziness19104704s_l_eaziness
sluggardness1561514s_luggardness
slushiness1344644s_lu_shiness
smuttiness1244404s_mut_tiness
solitaries10410124solitari_e_s
solitarinesses1452964solitarinesses
squareness1944764s_qu_areness
staginess1038754s___taginess
stalwartness1551504stal_wartness
starkness1335964s___tarkness
sultaness945614sul_ta__ness
wateriness1348074wa__teriness

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.1561145455.1
2DLD Change Limit124790438.40314850.6
3Display Results43430.0331303.0
 (SQL Overall)178691438.59220797.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.