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

229 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
zestily1916756(None) 
testily102910801testily
chestily1645522chestily
destiny113111462destiny
dustily113211522dustily
feistily1445262feistily
fustily133111372fustily
gustily113010902gustily
hastily133010662hastily
heftily1635762heftily
lustily103611242lustily
meatily12311092meatily
messily12298812messily
mistily122612342mistily
mustily123613632mustily
nastily103011032nastily
peskily1635082peskily
pettily1238172pettily
rustily103112992rustily
tastily103311642tastily
testify13246942testify
yeastily1444572yeastily
zestier163010222zestier
zesting174515332zesting
zesty176512162zest__y
aerily93017013ae_rily
artily92814713_artily
bastile9313913bastile
beadily1378843beadily
beamily1477393beamily
beastly1277563beast_ly
beatify1536593beatify
beefily1535613beefily
besmile1137463besmile
bestial9311643bestial
bestially1447043bestially
bestiary1344813bestiary
besting104923923besting
bestir8311163besti_r
bestirs9311133bestirs
bossily1237563bossily
bushily15268893bushily
busily112211503bus_ily
cattily123210853cattily
centile94217183centile
certify1546243certify
cesti75217423cesti__
cosily113613853cos_ily
costly114012333cost_ly
crustily13328173crustily
cushily15257923cushily
deathly14336863deathly
deftly1336533deft_ly
dentil74017883dentil_
dentils84115583dentils
destine83719953destine
destroy1138153destroy
dewily1338343de_wily
dirtily1138583dirtily
distil73616433distil_
distill83011323distill
distils83015803distils
dottily1147283dottily
dressily1246443dressily
duskily15236743duskily
easily9313023_easily
edgily1136063_edgily
eerily92913563_eerily
emptily1445813emptily
entity9312053_entity
estray95713333_estray
fattily13379463fattily
featly123711753feat_ly
fertile10311733fertile
festal94213563festal_
festally1437543festally
festive1339773festive
festively1845773festively
fetidly1435013fe_tidly
fishily1637643fishily
fleshily1744533fleshily
frostily1436693frostily
fussily13267603fussily
gassily1137813gassily
gemmily1534603gemmily
gentil74115123gentil_
gentile83515293gentile
gently103710913gent_ly
gestalt8411173gestalt
gestic9312773gesti_c
goutily1137933goutily
gushily14257823gushily
gutsily11267223gutsily
headily1478623headily
heartily1436563heartily
heavily1665903heavily
hecticly1843003hecticly
hostile10312553hostile
hostly124210863host_ly
huskily17236333huskily
instil61111383instil_
instill789063instill
instils7811453instils
jerkily2134623jerkily
jesting154317713jesting
jestingly2045953jestingly
joltily1746323joltily
justify2034663justify
justly16307253just_ly
lastly93310873last_ly
leakily1436473leakily
leerily1037633leerily
lentil64315393lentil_
lentils73912973lentils
loftily1336353loftily
meetly1138673meet_ly
merrily1238633merrily
mesally12119793mesally
mestino9411643mestino
mestiza1835383mestiza
mestizo1845943mestizo
mostly113110943most_ly
mushily152410093mushily
muskily16289043muskily
mussily12279773mussily
mysticly1843323mysticly
mystify1843563mystify
nattily103610323nattily
neatly93812483neat_ly
needily1166323needily
nervily1336863nervily
nesting84320443nesting
nestle63013953nest_le
nettly9459453ne_ttly
niftily1335753niftily
nosily93712683nos_ily
nuttily10308633nuttily
pastil85018323pastil_
pastils94416173pastils
peppily1335133peppily
perkily1637813perkily
pertly115312553pert_ly
pestier94317403pestier
pestle83215843pest_le
pesty106421713pest__y
pistil83915073pistil_
pistils93314303pistils
prettily1337283prettily
pushily15247983pushily
readily11711403readily
rectify1536453rectify
reedily1179613reedily
reptile93914083reptile
resail64418733resail_
resails74616743resails
resile64627673res_ile
resiny94617363res_iny
resting85031183resting
restive10315933restive
restively1548313restively
restudy1144763restudy
restyle1038763restyle
retile65929673re_tile
riskily1436413riskily
rosily93914713ros_ily
rusticly1345183rusticly
ruttily10338613ruttily
saltily10310543saltily
sassily1038723sassily
sectile9311973sectile
seedily1178583seedily
sessile739523sessile
sestina72711973sestina
sestine73017923sestine
sexily1638853se_xily
sextile1438573sextile
shily115222013__shily
slily85820033__slily
sootily101810523sootily
stile54931573__stile
still54922083__still
stilly93714093__stilly
stilt54831983__stilt
stimy105114743__stimy
sweatily1435473sweatily
tartily103511573tartily
tattily10409993tattily
tearily10311153tearily
techily1537123techily
tenthly1335743tenthly
testacy1235963testacy
testicle1037443testicle
testier74015643testier
testing86021053testing
testis64916713testi_s
testy85419063test__y
textile1437223textile
trustily11257103trustily
tuftily1335573tuftily
vastity1336203vastity
vastly12508723vast_ly
verily122616053ve_rily
vestal94615573vestal_
vestally1437413vestally
vestals104612333vestals
vestiary1444313vestiary
vestige1137433vestige
vesting114618683vesting
vestry1238623vest_ry
waspily1535513waspily
wearily1338783wearily
weedily1476123weedily
weevily1694643weevily
westerly1445553westerly
westing115020273westing
wetly114511713we_t_ly
wispily1535653wispily
wittily1336173wittily
zanily18310183z_anily
zeatin15412823zeati_n
zeatins16311733zeatins
zest136035703zest___
zested164214043zest_ed
zester153617793zest_er
zesters163517293zesters
zestful1945243zestful
zestfully2443913zestfully
zestiest173011103zestiest
zests145419743zest__s

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.393454684.5
2DLD Change Limit1340272296.40620922.1
3Display Results2292290.0763013.2
 (SQL Overall)1786912296.87525991.4
 
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.