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

149 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
heftiness153631(None) 
deftness1236302deft_ness
hastiness122410882hastiness
headiness132510362headiness
heartiness1338032heartiness
heaviness15207062heaviness
heftiest1439182hefti_est
heftinesses1737132heftinesses
huffiness1844282huffiness
jettiness1675692jettiness
loftiness1236572loftiness
meatiness11311182meatiness
niftiness1236362niftiness
pettiness1178702pettiness
shiftiness1644792shiftiness
testiness9209752testiness
artiness81615403_artiness
battiness11239843battiness
beadiness12249233beadiness
beefiness1435583beefiness
beeriness1137863beeriness
bittiness11228333bittiness
bustiness111810473bustiness
cattiness112310633cattiness
chattiness1565123chattiness
cheekiness1944043cheekiness
cheeriness1545533cheeriness
cheesiness1544733cheesiness
chewiness1744823che_winess
craftiness1545753craftiness
daffiness1634843daffiness
daftness1235533daft_ness
definers124211193def_iners
defines114118683def_ine_s
dentines93418403dentine_s
destines93619663destine_s
dewiness1238453de_winess
dirtiness1039473dirtiness
dottiness1058043dottiness
draftiness1444863draftiness
dustiness102211033dustiness
easiness8313043_easiness
edginess1036053_edginess
eeriness8311873_eeriness
emptiness1335373emptiness
fattiness12239373fattiness
feistiness1345073feistiness
fetidness1345443fe_tidness
fitness10299393__fitness
fustiness121910243fustiness
geekiness1435413geekiness
gemminess1464643gemminess
germiness1257693germiness
goutiness1038763goutiness
gustiness10189893gustiness
hairiness1238013hairiness
hamminess1635713hamminess
handiness132110933handiness
happiness1635993happiness
hardiness132310353hardiness
haziness20248513h_aziness
healthiness1744093healthiness
heathless1535593heathless
heatless113011463heat_less
hefters134312003heft__ers
heftier1337203hefti_e_r
hefting144510913heftin__g
heiress1036813he__iress
hematines141312203hematine_s
hemlines13310623hemline_s
heptanes1339003heptane_s
heroines112916573heroine_s
hilliness1248923hilliness
hippiness1635463hippiness
hoariness1238823hoariness
hokiness152510183h_okiness
holiness112512503h_oliness
hominess132712453h_ominess
horniness12309143horniness
horsiness12259473horsiness
hotness1038613h_ot_ness
humpiness1635773humpiness
huskiness16206583huskiness
iffiness1435023_iffiness
jerkiness20175643jerkiness
leafiness1236483leafiness
leakiness1337503leakiness
leeriness938323leeriness
lefties10312073lefti_e_s
legginess1135033legginess
lustiness92010453lustiness
maltiness112910573maltiness
matiness102114753_matiness
mealiness11310063mealiness
meetness1036653meet_ness
merriness1138293merriness
messiness11248223messiness
miffiness1734523miffiness
mistiness111911633mistiness
mustiness112211663mustiness
nastiness92310573nastiness
nattiness9239333nattiness
neatness839153neat_ness
neediness10227733neediness
nerdiness10208333nerdiness
nerviness12226873nerviness
newsiness1236033newsiness
nuttiness9207563nuttiness
pastiness112312353pastiness
pectines121914683pectine_s
peppiness1235183peppiness
perkiness15209163perkiness
pertness10310093pert_ness
peskiness15216523peskiness
pottiness1179703pottiness
prettiness1257393prettiness
puffiness1764363puffiness
readiness102611853readiness
reediness10239613reediness
refiners114713313ref_iners
refines105426343ref_ine_s
retines75134673re_tine_s
rootiness979063rootiness
runtiness92410393runtiness
rustiness92111933rustiness
ruttiness9258793ruttiness
saltiness93312113saltiness
seaminess11310473seaminess
seediness10219173seediness
sentinels947423sentinels
sestines82717243sestine_s
sexiness1537943se_xiness
slatiness92511363slatiness
softness1136433soft_ness
sootiness999833sootiness
sweatiness1336463sweatiness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
teariness9310633teariness
thriftiness1742473thriftiness
unfitness1244843unfitness
weariness1238843weariness
weediness13247043weediness
weepiness14215963weepiness
wetness10277723we_t_ness
wheeziness2542543wheeziness
wittiness12197223wittiness
yeastiness1344883yeastiness

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 Limit1486411497.46619909.1
3Display Results1491490.0632365.1
 (SQL Overall)1786911497.95222471.2
 
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.