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

210 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
softness113643(None) 
daftness1235532daftness
deftness1236302deftness
hotness1038612ho_tness
loftiness1236572loftiness
loftless1135902loftless
lostness837682lostness
mootness1036752mootness
safeness11239632safeness
saltness82610242saltness
shortness1236732shortness
softeners1245132softeners
softens10347622soft_ens
softest10310602soft_est
softies103414612softie_s
softnesses1337602softnesses
soleness8814262soleness
sootiness999832sootiness
soreness8914792soreness
sourness839542sourness
stoutness945862stoutness
swiftness1543652swiftness
aptness9268573_aptness
boldness1136973boldness
boltless10338283boltless
boniness102211803boniness
bootless103410983bootless
boxiness17247813boxiness
coatless1039693coatless
coldness1137953coldness
comfiness1646953comfiness
coolness1037743coolness
cosiness103214283cosiness
costless10310003costless
countess103710053countess
coyness1277323co_yness
coziness19319823coziness
curtness1037263curtness
doneness9411513doneness
dopiness11289973dopiness
dottiness1058043dottiness
dourness947683dourness
doziness18228553doziness
fastness11238763fastness
fatness103311293_fatness
fitness10299393_fitness
flatness1138153flatness
fondness1237213fondness
footless113710803footless
fortress1136753fortress
foulness11236653foulness
foxiness18257403foxiness
foziness20257803foziness
gastness9278483gastness
giftless1245173giftless
goneness9310763goneness
goodness1036253goodness
goofiness1365603goofiness
goriness9310753goriness
goutiness1038773goutiness
heftiness1536313heftiness
hokiness152510183hokiness
holiness112512503holiness
hominess132712463hominess
hostess103210243host_ess
iffiness1435023iffiness
jokiness19227393jokiness
justness1535323justness
loathness1244703loathness
lofters103912903loft_ers
loftiest1139083loftiest
loginess9310163loginess
loneness8512093loneness
longness938553longness
lornness836493lornness
loudness937013loudness
lowness1037813lo_wness
meetness1036653meetness
moistness1146343moistness
mopiness12259063mopiness
moreness10911573moreness
neatness839153neatness
niftiness1236363niftiness
nosiness83211393nosiness
nowness1037033no_wness
oddness935313_oddness
oftenest1148863_oftenest
oftest91212003_oft_est
oldness836403_oldness
oneness7512143_oneness
ooziness17237513ooziness
pastness102510503pastness
patness92912283_patness
pertness10310093pertness
poetess938933poet_ess
poetless1038723poetless
pokiness14219863pokiness
poorness1036363poorness
portless10310643portless
portress1038323portress
poshness1356653poshness
pottiness1179703pottiness
raptness1046733raptness
rifeness1138603rifeness
riftless1136943riftless
rootiness979063rootiness
rootless83910443rootless
ropiness102311073ropiness
rosiness82613183rosiness
sadness8310613s_adness
sageness92111983sageness
saltiness93312113saltiness
saltless8259343saltless
sameness102712683sameness
saneness82313723saneness
scantness1135733scantness
seatless83213003seatless
selfness1135153selfness
sexiness1537943sexiness
shiftiness1644793shiftiness
shiftless15265303shiftless
shitless11249243shitless
showiness1576073showiness
shyness1344993s_hyness
sickness1437833sickness
sifters103714793sift_ers
siziness1737423siziness
skewness1533763skewness
slatiness92511363slatiness
slimness1036523slimness
slitless8268143slitless
slowness1135013slowness
slyness1035263s_lyness
smartness1136143smartness
smokiness1535543smokiness
smoothness1543043smoothness
smugness1143813smugness
snootiness1085833snootiness
snottiness1055593snottiness
snowiness1296243snowiness
snubness1044373snubness
snugness934323snugness
soapiness1138293soapiness
soapless10278073soapless
soberness1186463soberness
sockless14267793sockless
sodaless936113sodaless
sofabeds1451893sofabeds
softas94410403soft__as
soften9429493soft_e_n
softened1235663softened
softener1145613softener
softer94015313soft_e_r
softhead1545003softhead
softheads1644553softheads
softie93312483softie__
softish13127813soft_ish
softs85019233soft___s
sogginess1136183sogginess
soilless8279033soilless
soleless8910033soleless
solidness1036903solidness
solonets838233solonets
sones55444143so__ne_s
songless9218823songless
sonless72612613so_nless
sonnets74211993so_nnets
sooners73916643so_oners
soonest7415593so_onest
soothers113913433soothers
soothes103917113soothe_s
soothest113312243soothest
sootiest84016753sootiest
soppiness1336543soppiness
sorners73416873so_rners
sorriness939583sorriness
sorters74221133sort_ers
sorties74126403sortie_s
soulless8218763soulless
soundness1036963soundness
soupless10268463soupless
soutanes8312933soutane_s
souters74422603sout_ers
southers114214453southers
sozines16611263sozine_s
sportiness1278233sportiness
spotless1037043spotless
spottiness1285763spottiness
spoutless1134243spoutless
spryness1334003spryness
squatness1844943squatness
stiffness1543553stiffness
stoniness938343stoniness
stress66616673s__tress
suchness1335763suchness
sultaness945613sultaness
sureness8912903sureness
swartness1236113swartness
sweetness1245683sweetness
tartness82210133tartness
tautness8217183tautness
unfitness1244843unfitness
vastness11257293vastness
voidness1235553voidness
votress1035483vo_tress
wetness10277723_wetness
whatness1435093whatness
witness103010013_witness
woeness1020211543wo_eness
wornness1136363wornness

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 Filter1786911461620.406440125.6
2DLD Change Limit1461622107.70318974.7
3Display Results2102100.0762763.2
 (SQL Overall)1786912108.18521831.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.