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

163 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
heftily163576(None) 
chestily1645522chestily
deftly1336532deft_ly
hastily133010662hastily
headily1478622headily
heartily1436562heartily
heavily1665902heavily
hecticly1843002hecticly
heftier1337202heftier
hefting144510912hefting
hefty146112132heft__y
huffily1934692huffily
loftily1336352loftily
meatily12311092meatily
niftily1335752niftily
pettily1238172pettily
shiftily1744552shiftily
testily102910802testily
tuftily1335572tuftily
zestily19167562zestily
aerily93017013ae_rily
artily92814713_artily
beadily1378843beadily
beamily1477393beamily
beatify1536593beatify
beefily1535613beefily
cattily123210853cattily
centile94217183centile
certify1546243certify
chattily1634603chattily
cheekily2053473cheekily
cheerily1655423cheerily
cheesily1654413cheesily
craftily1644783craftily
daffily1735133daffily
daftly1335443daft_ly
deathly14336863deathly
defile105216663def_ile
dentil74017883dentil_
dentils84115583dentils
destiny113111463destiny
dewily1338343de_wily
dirtily1138583dirtily
dottily1147283dottily
draftily1534413draftily
dustily113211523dustily
easily9313023_easily
edgily1136063_edgily
eerily92913563_eerily
effigy1642213_effigy
emptily1445813emptily
entity9312053_entity
fattily13379463fattily
featly123711753feat_ly
feistily1445263feistily
fertile10311733fertile
fetidly1435013fe_tidly
fifthly1943093fifthly
fitly115114973__fitly
fustily133111373fustily
gemmily1534603gemmily
gentil74115123gentil_
gentile83515293gentile
gently103710913gent_ly
goutily1137933goutily
gustily113010903gustily
hafting144014173hafting
hammily1736063hammily
handily143610873handily
happily1745763happily
hardily143310273hardily
hazily2179063h_azily
healthily1843103healthily
heatedly1546053heatedly
heathy156111213heat_hy
heating114024323heating
hectic132311523hecti_c
heft106736293heft___
hefted134911423heft_ed
hefter124313923heft_er
hefters134312003hefters
heftiest1439183heftiest
hefts116218153heft__s
heil76328933he__il_
heils85222193he__ils
henting113719653henting
hoarily1338973hoarily
hokily16409093h_okily
holily123612953h_olily
homily144712333h_omily
hornily1338283hornily
horsily1338843horsily
hostile10312553hostile
hostly124210863host_ly
hotly115815483h_ot_ly
huskily17236333huskily
jerkily2134623jerkily
joltily1746323joltily
leakily1436473leakily
leerily1037633leerily
lefties10312073lefties
leftish13197253leftish
leftism12226093leftism
leftist10279353leftist
lefty115613563left__y
lentil64315393lentil_
lentils73912973lentils
lustily103611243lustily
meetly1138673meet_ly
merrily1238633merrily
messily12298813messily
mistily122612343mistily
mustily123613633mustily
nastily103011033nastily
nattily103610323nattily
neatly93812483neat_ly
needily1166323needily
nervily1336863nervily
nettly9459453ne_ttly
nuttily10308633nuttily
peppily1335133peppily
perkily1637813perkily
pertly115312553pert_ly
peskily1635083peskily
prettily1337283prettily
puffily1834843puffily
readily11711403readily
rectify1536453rectify
reedily1179613reedily
refile95122373ref_ile
refill94514053ref_ill
refilm114311403ref_ilm
refly113914563ref__ly
reptile93914083reptile
retile65929673re_tile
rustily103112993rustily
ruttily10338613ruttily
saltily10310543saltily
sectile9311973sectile
seedily1178583seedily
sexily1638853se_xily
sextile1438573sextile
softly12457763soft_ly
sootily101810523sootily
sweatily1435473sweatily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tearily10311153tearily
techily1537123techily
tenthly1335743tenthly
testify13246943testify
textile1437223textile
thriftily1842003thriftily
unfitly1335573unfitly
verily122616053ve_rily
wearily1338783wearily
weedily1476123weedily
weevily1694643weevily
wetly114511713we_t_ly
wheezily2642303wheezily
wittily1336173wittily
yeastily1444573yeastily

Search took 7 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 Limit1340271636.12321889.1
3Display Results1631630.0632587.3
 (SQL Overall)1786911636.59227107.3
 
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.