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

110 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
emptiness133537(None) 
emetines10611052emetine_s
emptiers1275192empti_ers
empties11712242empti_e_s
emptiest1278102empti_est
emptinesses1545992emptinesses
emptings1364822emptin_gs
emptins1179402emptin__s
matiness102114752_matiness
meatiness11311182meatiness
ampleness1345303ampleness
aptness9268573_apt_ness
artiness81615403_artiness
battiness11239843battiness
bittiness11228333bittiness
bumpiness1535283bump_iness
bustiness111810473bustiness
campiness1537543camp_iness
cattiness112310633cattiness
dippiness1435973dippiness
dirtiness1039473dirtiness
dopiness11289973dop_iness
dottiness1058043dottiness
dumpiness1435653dump_iness
dustiness102211033dustiness
earliness939693earliness
earthiness1377243earthiness
easiness8313043e_asiness
edginess1036053e_dginess
eeriness8311873e_eriness
emetine9712943emetine__
emetins9812653emetin__s
emotionless1352853emotionless
empanels1244823emp_anels
empires1139853emp_ire_s
emplanes1239503emplane_s
empress1138163emp__ress
emprises12311003emprise_s
emprizes2138133emprize_s
emptied1297393empti_e_d
emptier1187603empti_e_r
exoticness1942543exoticness
fattiness12239373fattiness
feistiness1345073feistiness
fustiness121910243fustiness
gemminess1464643gem_miness
goutiness1038763goutiness
gustiness10189893gustiness
happiness1636003happiness
hastiness122410883hastiness
heartiness1338033heartiness
heftiness1536313heftiness
hematines141312203hematine_s
hippiness1635463hippiness
humpiness1635773hump_iness
jettiness1675693jettiness
jumpiness2034293jump_iness
lippiness1335413lippiness
loftiness1236573loftiness
lumpiness1336483lump_iness
lustiness92010453lustiness
maltiness112910573maltiness
matinees102110423_matinees
maziness19239543_maziness
mealiness11310063mealiness
meetness1036653meet_ness
merriness1138293merriness
messiness11248223messiness
miriness10310463_miriness
mistiness111911633mistiness
mopiness12259063_mopiness
mustiness112211663mustiness
muteness1039013_muteness
mutines93117823_mutine_s
nappiness1335233nappiness
nastiness92310573nastiness
nattiness9239333nattiness
niftiness1236363niftiness
nippiness1334713nippiness
nuttiness9207563nuttiness
pastiness112312353pastiness
peppiness1235183peppiness
pettiness1178703pettiness
pipiness1238003pip_iness
pottiness1179703pottiness
raptness1046733rapt_ness
remoteness1246683remoteness
rootiness979063rootiness
ropiness102311073rop_iness
runtiness92410393runtiness
rustiness92111933rustiness
ruttiness9258793ruttiness
saltiness93312113saltiness
sappiness1337443sappiness
slatiness92511363slatiness
smokiness1535543smokiness
smuttiness1244403smuttiness
sootiness999833sootiness
soppiness1336543soppiness
tartiness92112053tartiness
tastiness92311143tastiness
tattiness9239413tattiness
temptress1343133tempt_ress
testiness9209753testiness
tipsiness1135703tipsiness
uppitiness1442753uppitiness
weepiness14215963weep_iness
wimpiness1635293wimp_iness
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 Limit1486411106.98321286.1
3Display Results1101100.0462391.3
 (SQL Overall)1786911107.45223978.9
 
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.