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

112 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
smallness117451(None) 
maleness10312312_maleness
saltness82610242s_altness
scaliness1149302scaliness
smallest1039402small_est
smallnesses1344962smallnesses
smartness1136142smartness
staleness9310782staleness
stillness936102stillness
tallness837102_tallness
ampleness1345303ampleness
baldness1137043_baldness
calmness1236643_calmness
chillness1455373chillness
coalless1038193coall_ess
dismalness1344043disma_lness
drollness1043623drollness
dullness934873_dullness
fellness1135913_fellness
femaleness1545763femaleness
frailness1236543frailness
fullness1135443_fullness
goalless935723goall_ess
haleness11312623_haleness
halfness1435563_halfness
illness736473__illness
madness10310073_ma_dness
mailless10248583_mailless
malines93625603_maline_s
mallees93315973_mall_ees
mallets93318493_mall_ets
malleus92911313_mall_eus
maltiness112910573_maltiness
manless93012933_manl_ess
manliness111310123_manliness
matiness102114753_matiness
matless93014043_matl_ess
maziness19239543_maziness
mealiness11310063mealiness
mealless10288363meall_ess
mildness1136523_mildness
ovalness1134673ova_lness
paleness10312983_paleness
realness8410443rea_lness
sadness8310613s_a_dness
safeness11239633s_afeness
sageness92111983s_ageness
sailless82410373s_ailless
salines74029413s_aline_s
sallets73719653s_all_ets
salliers83613343s_alliers
sallies73227813s_allie_s
sallowness1343753s_allowness
saltiness93312113s_altiness
saltless8259343s_altless
sameness102712683s_ameness
saneness82313723s_aneness
sapless93313443s_apl_ess
scaleless1135513scaleless
scantness1135733scantness
scariness11310183scariness
scarless10189053scarl_ess
seaminess11310473seaminess
seamless10238723seaml_ess
seatless83213003seatl_ess
selfness1135153s_elfness
shadiness1337463shadiness
shakiness1637083shakiness
shallowness1752093shallowness
sharpness1434943sharpness
shrillness1343223shrillness
silliness9510363silliness
simpleness1445173simpleness
skilless12246763skill_ess
slackness1535433slackness
slatiness92511363slatiness
slyness1035263s__lyness
smallages1245293smallages
smaller93410333small_e_r
smallish1346573small_ish
smalls84514123small___s
smaltines1136993smaltine_s
smarminess1444303smarminess
smellers10329773smell_ers
smelliest1136603smelliest
smileless1134693smileless
smogless1134053smogl_ess
smokiness1535543smokiness
smugness1143813sm_ugness
snakiness1367473snakiness
snapless10287463snapl_ess
soapiness1138293soapiness
soapless10278073soapl_ess
soilless8279033soill_ess
soleness8814263s_oleness
soulless8218763soull_ess
spaciness1337083spaciness
spallers102910733spall_ers
spanless10247363spanl_ess
spareness1139863spareness
stableness1248823stableness
staginess1038753staginess
staidness1037033staidness
stainless9176493stainless
stalkless1333723stalkless
starkness1335963starkness
starless81610843starl_ess
suaveness1247703suaveness
surliness939943surliness
swartness1236113swartness
usualness993563usua_lness
wellness1135793_wellness

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.436409841.7
2DLD Change Limit1486411128.25018017.1
3Display Results1121120.0502240.0
 (SQL Overall)1786911128.73620454.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.