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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

152 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
staleness931078(None) 
stableness1248821stableness
haleness11312622_haleness
maleness10312312_maleness
paleness10312982_paleness
safeness11239632s_afeness
sageness92111982s_ageness
saltness82610242s_altness
sameness102712682s_ameness
saneness82313722s_aneness
scaleless1135512scaleless
scaliness1149302scaliness
smallness1174512smallness
soleness8814262s_oleness
spareness1139862spareness
staginess1038752staginess
staidness1037032staidness
stalenesses11311102stalenesses
stalkless1333722stalkless
starkness1335962starkness
stateless937562stateless
stillness936102stillness
styleless1243412styleless
suaveness1247702suaveness
tallness837102_tallness
tameness102411252_tameness
agileness1046493agileness
ampleness1345303ampleness
astuteness1044753astuteness
awareness1236343awareness
baldness1137043_baldness
bareness10912813_bareness
baseness10910943_baseness
braveness14237763braveness
calmness1236643_calmness
falseness1236093_falseness
fatalness1245773fatal_ness
femaleness1545763femaleness
futileness1346133futileness
gameness112810693_gameness
graveness13288383graveness
halfness1435563_halfness
idleness936843_idleness
inaneness948383inaneness
irateness9310493irateness
lameness102612673_lameness
lateness82614073_lateness
littleness1045023littleness
mealiness11310063mealiness
nobleness1147523nobleness
notableness1347623notableness
ovalness1134673oval_ness
planeness1138153planeness
potableness1547193potableness
rareness81112853_rareness
realness8410443real_ness
sadness8310613s_a_dness
salines74029413s_aline_s
saltiness93312113s_altiness
saltless8259343s_altless
savageness1444063savageness
scalene9310773scalene__
scalenus1045543scalen_us
scantness1135733scantness
scarceness1444763scarceness
scariness11310183scariness
seaminess11310473seaminess
sedateness1146663sedateness
selfness1135153s_elfness
shadeless1335733shadeless
shadiness1337463shadiness
shakiness1637083shakiness
shameless1435923shameless
shapeless1435563shapeless
sharpness1434933sharpness
silliness9510363silliness
simpleness1445173simpleness
singleness1145733singleness
sizableness2265593sizableness
slackness1535433slackness
slatiness92511363slatiness
slyness1035263s__lyness
smartness1136143smartness
smileless1134693smileless
snakiness1367473snakiness
snideness1067683snideness
soapiness1138293soapiness
soleless8910033s_oleless
soreness8914793s_oreness
spaceless1335733spaceless
spaciness1337083spaciness
sparseness1245493sparseness
squalenes1845763squalene_s
squareness1944763squareness
stablenesses1448103stablenesses
stackless1555933stackless
stainers83212173sta_iners
stainless9176493stainless
stairless9185623stairless
stales65538293stal__e_s
stalest73720173stal__est
stalkers12369853stal_kers
stalkiest1347903stalkiest
stamened1137633stamene_d
stamens93411483stamen__s
stampless1334543stampless
stanes64933403sta__ne_s
stanines85115673stanine_s
stapedes11197753stapede_s
starless81610843sta_rless
stateliness1144233stateliness
steadiness1146703steadiness
steaminess1236773steaminess
steeliness1046793steeliness
steepness1145723steepness
stelene7310253stelene__
sternness946093sternness
stiffness1543553stiffness
stilbenes1143933stilbene_s
stiltedness1253793stiltedness
stoniness938343stoniness
stoutness945863stoutness
straitness1046293straitness
strangeness1246093strangeness
styrenes11116623styrene_s
subtileness1345403subtileness
subtleness1245443subtleness
suitableness1456303suitableness
sullenest9410213sullenest
sullenness1054153sullenness
suppleness1444453suppleness
sureness8912903s_ureness
surliness939943surliness
svelteness1344423svelteness
swartness1236113swartness
tableless1145033_tableless
talentless1042803_talentless
talents7312013_talen_ts
talkiness1356913_talkiness
tameless10259903_tameless
tapeless10218643_tapeless
tartness82210133_tartness
tautness8217183_tautness
trueness838693_trueness
tweeness11246403_tweeness
unstableness1457123unstableness
usableness1246503usableness
usualness993563usual_ness
vileness1139983_vileness
vitalness1245413vital_ness
waeness102512783_wa_eness
wholeness1545373wholeness

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 Filter1786911486410.423422437.4
2DLD Change Limit1486411526.53022762.8
3Display Results1521520.0801900.0
 (SQL Overall)1786911527.03325407.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.