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

248 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
beastly127756(None) 
basely114412312b_asely
bassly114610072b_assly
beadily1378842beadily
beamily1477392beamily
beast76338642beast__
beastie92412432beastie
beasts84519722beast_s
beauty115410162beaut_y
blasty115611052blast_y
brashly15427612brashly
bristly12178062bristly
easily9313022_easily
featly123711752fea_tly
ghastly14354562ghastly
lastly93310872_lastly
measly113610442meas_ly
neatly93812482nea_tly
peartly1267452peartly
vastly12508722_vastly
weasely13317852weasely
yeastily1444572yeastily
yeasty12438692yeast_y
aptly105111813__aptly
badly114918763b_a_dly
baldly12479833b_aldly
bally105530103b_a_lly
banty106624003b_ant_y
barely114716793b_arely
barfly14339653b_arfly
basal75722283b_asal_
basally1237963b_asally
basalt83519583b_asalt
bashlyk1942463b_ashlyk
basify1437513b_asify
basil75122273b_asil_
basils85717473b_asils
bassy1012917103b_as_sy
bast66362413b_ast__
baste74829983b_ast_e
basted95227233b_asted
baster85333593b_aster
bastes85330383b_astes
bastile9313913b_astile
basts75936933b_ast_s
battle85217863b_attle
batty105422243b_a_tty
bawty135614103b_awt_y
beachy164011253bea_chy
beadle93314683bea_dle
beady114719923bea__dy
beagle93612593bea_gle
beaky146118023bea__ky
beamishly1973343beamishly
beamy126218573bea__my
beanery1237563beanery
beanstalk1542053beanstalk
bearably15177933bearably
bearishly1774293bearishly
beasties102514653beasties
beastlier1144193beastlier
beat66168303bea_t__
beaten84617063bea_ten
beater84729393bea_ter
beatify1536593beatify
beats76042243bea_t_s
beaut75135213beaut__
beautify1643183beautify
beauts86015283beaut_s
beefily1535613beefily
beetle8311673be_etle
belly104625493be__lly
best66355323be_st__
bested94922753be_sted
bestir8311163be_stir
bestow1149463be_stow
bests75932613be_st_s
bestud9439303be_stud
bheesty1542493bheest_y
bialy105119323bia__ly
biasedly1443953biasedly
blackly1835253blackly
blandly1336043blandly
blankly1634263blankly
blast76532573blast__
blasted104213473blasted
blaster94017303blaster
blastie92411393blastie
blasts85116773blast_s
blastula1043823blastula
bleakly1634663blea_kly
blearily1365953blearily
bluntly1235223bluntly
boast75935703boast__
boasted104113743boasted
boaster94616433boaster
boasts85017923boast_s
bobstay1443983bobstay
bossily1237563bossily
brambly16296253brambly
brashy145210593bras_hy
brasil8713863brasil_
brasils9410973brasils
brassily1336623brassily
brassy11509233bras_sy
brattle9249253brattle
bratty1159683bra_tty
bravely15428233bravely
brawly144312353bra_wly
breast8319633breast__
breasted1138823breasted
breasts939703breast_s
breathy15328033brea_thy
briskly16165403briskly
bristle91910103bristle
brittly12165973brittly
busily112211503b_usily
bustle84015483b_ustle
busty105621013b_ust_y
castle84918963_castle
chastely1635813chastely
costly114012333_costly
crassly1276653crassly
daftly1335443_daftly
deadly113811473dea_dly
deafly13389123dea_fly
dearly104615323dea_rly
deasil71110983deasil_
deathly14336863deathly
deathy134210233dea_thy
deftly1336533de_ftly
densely1146713densely
early85324123_ea_rly
earthly13387383_earthly
earthy12399943_earthy
easel54521113_easel_
easels65914553_easels
east46659103_east__
easter65027983_easter
easterly11246643_easterly
easts57530323_east_s
easy76224493_eas__y
exactly1953823exactly
fatly115716803_fa_tly
fealty122910223fealt_y
feasibly1644743feasibly
feast85932723feast__
feasted11310843feasted
feaster10812983feaster
feasts95116093feast_s
feistily1445263feistily
feisty12449293feist_y
firstly1335643firstly
flatly123110213fla_tly
gently103710913ge_ntly
ghostly14355103ghostly
greasily1236233greasily
greatly1137613grea_tly
gristly11187333gristly
hastily133010663_hastily
hasty115718763_hast_y
headily1478623headily
headstay1543903headstay
healthy16416083healthy
heartily1436563heartily
hearty126313633heart_y
heathy156111213hea_thy
heavily1665903heavily
hostly124210863_hostly
inaptly1244413inaptly
justly16307253_justly
leakily1436473leakily
leally94012613lea_lly
lealty92910603lealt_y
leanly93811503lea_nly
least56134883least__
leasts64616413least_s
mealy104422183mea__ly
meanly115412043mea_nly
measle83513223meas_le
meatily12311093meatily
meaty107021313mea_t_y
meetly1138673me_etly
mesally12119793mesally
messily12298813messily
moistly1236613moistly
mostly113110943_mostly
nastily103011033_nastily
nasty85717283_nast_y
nearly94813733nea_rly
nestle63013953ne_stle
nettly9459453ne_ttly
obesely1245113obe_sely
partly116315473_partly
pastry114913033_pastry
pasty105725053_past_y
patly105020583_pa_tly
pearly116414843pea_rly
peaty105725693pea_t_y
pertly115312553pe_rtly
pestle83215843pe_stle
pesty106421713pe_st_y
queasily2043693queasily
raptly11338913_raptly
rashly123410213_rashly
rattly94111543_rattly
readily11711403readily
really93315613rea_lly
realty92713693realt_y
reapply1434323reapply
riantly1037613riantly
scantly12419553scantly
secantly1345983secantly
slantly10399323slantly
smartly12497433smartly
tartly96014023_tartly
tastily103311643_tastily
tasty84820313_tast_y
tautly9499503_tautly
tearily10311153tearily
teasel63914983teasel_
teasels74311313teasels
tensely1037363tensely
tersely1038113tersely
testily102910803te_stily
testy85419063te_st_y
thistly1395963thistly
toasty9509563toast_y
unaptly1244793unaptly
uneasily1146453uneasily
vasty116215923_vast_y
vealy115817773vea__ly
vestry1238623ve_stry
wastry12388773_wastry
weakly1636483wea_kly
wealthy16314333wealthy
wearily1338783wearily
weasel93410523weasel_
weaselly14284373weaselly
weasels10468503weasels
wetly114511713we__tly
wrastle10368993wrastle
yearly125210273yea_rly
yeast85327943yeast__
yeasted1138503yeasted
yeasts96413053yeast_s
zestily19167563ze_stily
zesty176512163ze_st_y

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.420425454.8
2DLD Change Limit1340272486.84619577.4
3Display Results2482480.0932666.7
 (SQL Overall)1786912487.35924282.0
 
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.