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

106 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
emptily144581(None) 
emptied1297392emptied
emptier1187602emptier
empties11712242empties
emptins1179402emptins
empty1247762empt__y
meatily12311092meatily
amplify1744083amplify
amply125012913amp__ly
aptly105111813_apt_ly
artily92814713_artily
bumpily1665653bump_ily
campily1638273camp_ily
cattily123210853cattily
dirtily1138583dirtily
dopily123510463dop_ily
dottily1147283dottily
dumpily1566233dump_ily
dustily113211523dustily
earthily1445613earthily
earthly13387383earthly
easily9313023e_asily
edgily1136063e_dgily
eerily92913563e_erily
email74715103em_ail_
emails84412343em_ails
emboly1336723em_boly
emetic10614453emeti_c
emetics11610723emetics
emetin8613463emeti_n
emetine9712943emetine
emetins9812643emetins
emoting10313563emoting
emotion9711303emotion
emotive1239193emotive
emotively1744403emotively
empale102611263emp_ale
empathy1743483empathy
empery1348683emp_ery
empire1039323emp_ire
employ1346493emp_loy
emprise11310723emprise
emprize2038843emprize
emptiable1544843emptiable
emptiers1275193emptiers
emptiest1278103emptiest
emptings1364823emptings
emptying1634243emptying
entity9312053e_ntity
expiry1834653exp_iry
fattily13379463fattily
feistily1445263feistily
fustily133111373fustily
gemmily1534603gem_mily
goutily1137933goutily
gustily113010903gustily
happily1745763happily
hastily133010663hastily
heartily1436563heartily
heftily1635763heftily
imply124911843imp__ly
joltily1746323joltily
jumpily2174983jump_ily
loftily1336353loftily
lumpily1476563lump_ily
lustily103611243lustily
mazily20610393_mazily
meetly1138673meet_ly
merrily1238633merrily
messily12298813messily
mistily122612343mistily
motile83818343_motile
mustily123613633mustily
mutely113811653_mutely
mutiny113612683_mutiny
nastily103011033nastily
nattily103610323nattily
niftily1335753niftily
nippily1444713nippily
nuttily10308633nuttily
peppily1335133peppily
pettily1238173pettily
pily96132733__p_ily
raptly11338913rapt_ly
remotely1345623remotely
reptile93914083reptile
ropily113312443rop_ily
rustily103112993rustily
ruttily10338613ruttily
saltily10310543saltily
sappily1437163sappily
smokily1635373smokily
smuttily1344273smuttily
sootily101810523sootily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tempting1357343tempting
temptingly1842893temptingly
testily102910803testily
tipsily1236043tipsily
tuftily1335573tuftily
uptilt8410803_uptilt
wittily1336173wittily
yeastily1444573yeastily
zestily19167563zestily

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271067.04619021.7
3Display Results1061060.0333212.1
 (SQL Overall)1786911067.48523873.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.