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

231 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
merrily123863(None) 
aerily93017012ae_rily
eerily92913562_eerily
furrily1337612furrily
jerkily2134622jerkily
leerily1037632leerily
meatily12311092meatily
merely111312592me_rely
merrier92612302merrier
merry104721492merr__y
messily12298812messily
metrify1535622metrify
mirkily16266402mirkily
murkily16287112murkily
nervily1336862nervily
perkily1637812perkily
sorrily1039832sorrily
tearily10311152tearily
terribly1344922terribly
terrify1336352terrify
verily122616052ve_rily
wearily1338782wearily
aerify122810113ae_rify
airily93014823_airily
angrily1137723angrily
artily92814713_artily
beadily1378843beadily
beamily1477393beamily
beefily1535613beefily
berried103714043berried
berries94423553berries
berry104521773berr__y
blearily1365953blearily
blurrily1343913blurrily
burlily1237713burlily
certify1546243certify
charily15310283charily
cheerily1655423cheerily
cornily12410853cornily
curlily1238383curlily
dearly104615323dear_ly
deerfly1443983deerfly
derail74218813derail_
derails84216393derails
derrick1435803derrick
derries83124623derries
derris73615273derri_s
derry94721373derr__y
dewily1338343de_wily
dirtily1138583dirtily
drearily1236083drearily
drily95816523__drily
early85324123_ear_ly
easily9313023_easily
edgily1136063_edgily
emptily1445813emptily
erring73816483_erring
erringly1237773_erringly
ervil8310303_ervil_
ervils948773_ervils
febrile1237153febrile
ferity122813343fe_rity
ferly115517353fe_r_ly
ferrel92810203ferrel_
ferrels10248623ferrels
ferrety13287013ferrety
ferric1139993ferri_c
ferried113411523ferried
ferries103521083ferries
ferrite103312753ferrite
ferrule1035863ferrule
ferry116020803ferr__y
fertile10311733fertile
fervidly1863323fervidly
fierily1339023fierily
gemmily1534603gemmily
gerbil938343gerbil_
gerbils1037303gerbils
gorily10612503_gorily
hardily143310273hardily
headily1478623headily
heartily1436563heartily
heavily1665903heavily
heftily1635763heftily
herried113514453herried
herries104025073herries
herring113615883herring
herry114922473herr__y
hoarily1338973hoarily
hornily1338283hornily
horribly16114313horribly
horridly15114793horridly
horrify1635023horrify
horsily1338843horsily
jerrid14259143jerri_d
jerrids15277743jerrids
jerries143817513jerries
jerry155016183jerr__y
kerria10339913kerri_a
kerrias11289513kerrias
kerries113317913kerries
kerry124916093kerr__y
leakily1436473leakily
mangily1339753mangily
manlily1238743manlily
marbly134111933m_arbly
marly106925613m_ar_ly
married104715303married
marrier93817523marrier
marries93825283marries
marring103319553marring
marrowy15236083marrowy
marry104821693marr__y
mazily20610393m_azily
meagrely1443013meagrely
mealy104422183me__aly
meanly115412043me_anly
measly113610443me_asly
medfly1535223me_dfly
meekly1535193me_ekly
meetly1138673me_etly
megilp1135833me_gilp
megrim1178043megri_m
megrims1276103megrims
meiny104015413me__iny
mercery14397623mercery
mercies113817563mercies
mercury14364893mercury
mercy125916183me_r_cy
merging112711763merging
merino8315093me_rino
merit7339183me_ri_t
merits8320873me_rits
merl65830973me_r_l_
merle75824373me_r_le
merlin83916683merli_n
merlins93015813merlins
merls77423903me_r_ls
merriest10311483merriest
mesally12119793mesally
metric10314683metri_c
metrics11312363metrics
metring103215293metring
metrist9317063metrist
micrify1744693micrify
milkily16216553milkily
misrely12319613misrely
mistily122612343mistily
moodily1358203moodily
moonily1248943moonily
morally12411493morally
morbidly1643833morbidly
morrion959003morrion
morris83814733morri_s
mortify1536223mortify
mousily1239393mousily
muckily18277743muckily
muddily1435963muddily
muggily1435103muggily
murkly15368303m_urkly
murrey114312263murr_ey
murries94118673murries
murrine9411483murrine
murry105120233murr__y
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mustily123613633mustily
muzzily2045023muzzily
nearly94813733near_ly
needily1166323needily
overwily1736663overwily
pearly116414843pear_ly
peartly1267453peartly
peppily1335133peppily
perfidy1635273perfidy
peril75425953pe_ril_
perils84121853pe_rils
perries93226603perries
perry105222713perr__y
pertly115312553pe_rtly
peskily1635083peskily
petrify1536573petrify
pettily1238173pettily
pursily1238213pursily
readily11711403readily
redrill857893redrill
reedily1179613reedily
roily86121113__roily
scarily12311703scarily
seedily1178583seedily
serail64222673serail_
serails73318363serails
serried82513963serried
serriedly1343433serriedly
serries73925353serries
serry84824123serr__y
servile10310643servile
sexily1638853se_xily
smarmily1543523smarmily
smirkily1753333smirkily
surlily10310003surlily
tardily11269583tardily
tartily103511573tartily
techily1537123techily
termly1138433te_rmly
terrible1046643terrible
terrier73414963terrier
terries73425633terries
terrine72517573terrine
territ63421373terri_t
territs72714503territs
terry84721873terr__y
tersely1038113tersely
testily102910803testily
torridly1284473torridly
torrify1335013torrify
verbify1834993verbify
verbile1249863verbile
verify153110163ve_rify
verity123714853ve_rity
versify1636333versify
warily122915093_warily
weedily1476123weedily
weevily1694643weevily
weirdly14274493weirdly
wergild1234043wergild
wirily123310783_wirily
wordily1437853wordily
yearly125210273year_ly
zestily19167563zestily

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 Limit1340272316.03322215.6
3Display Results2312310.0932483.9
 (SQL Overall)1786912316.53227356.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.