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

78 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
sultaness94561(None) 
saltiness93312112saltiness
saltness82610242salt_ness
sulkiness1347352sulkiness
sultanas8237152sultan_as
sultanesses1145562sultanesses
sultans72411832sultan__s
sultriness1045562sultriness
adultness1043973adult_ness
bulginess1245633bulginess
bulkiness1555933bulkiness
bustiness111810473bustiness
butanes9312743bu_tane_s
curtness1037263curt_ness
cuteness1039673cu_teness
dullness934873dul_lness
dulness8307983dul__ness
dustiness102211033dustiness
faultiness1344823faultiness
flatness1138153_flatness
fullness1135443ful_lness
fulness10248963ful__ness
fustiness121910243fustiness
guiltiness1144193guiltiness
gustiness10189893gustiness
justness1535323just_ness
lustiness92010453lustiness
maltiness112910573maltiness
mustiness112211663mustiness
muteness1039013mu_teness
nuttiness9207563nuttiness
pulpiness1335603pulpiness
runtiness92410393runtiness
rustiness92111933rustiness
ruttiness9258793ruttiness
saltines82917793saltine_s
saltless8259343salt_less
selfness1135153sel_fness
silanes72517163sil_ane_s
silkiness1337253silkiness
silliness9510363silliness
slatiness92511363slatiness
slimness1036523s_limness
slowness1135013s_lowness
slyness1035263s_l_yness
smuttiness1244403smuttiness
softness1136433soft_ness
soleness8814263sol_eness
solidness1036903solidness
sootiness999833sootiness
soutanes8312933soutane_s
squatness1844943squat_ness
stanes64933403s__tane_s
suaveness1247703suaveness
subpanels1344393subpanels
subtleness1245443subtleness
subtones10311383subtone_s
suchness1335763su_chness
suldans8299723suldan__s
sulfates11310793sulfate_s
sulfones1147683sulfone_s
sullages939973sullage_s
sullenest9410213sullenest
sullenness1054153sullenness
sultan63012593sultan___
sultana7257803sultan__a
sultanate946053sultanate
sultanates1045233sultanates
sultanic1046173sultan_ic
sultriest938653sultriest
sunniness9247943sunniness
suntans72111733suntan__s
sureness8912903su_reness
surliness939943surliness
surtaxes1536513surtaxe_s
sustainers1044133sustainers
svelteness1344423svelteness
titaness836723_titaness

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 Filter1786911486410.1731032896.0
2DLD Change Limit148641788.00018580.1
3Display Results78780.0302600.0
 (SQL Overall)178691788.20321783.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.