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

144 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
beefily153561(None) 
beadily1378842beadily
beamily1477392beamily
beefalo1244082beefalo
beefier12329092beefier
beefing133911472beefing
beefy135313832beef__y
breezily2243652breezily
eerily92913562_eerily
leerily1037632leerily
needily1166322needily
reedily1179602reedily
seedily1178582seedily
weedily1476122weedily
weevily1694642weevily
aerily93017013_aerily
baggily1436043baggily
balkily16266693balkily
balmily14216463balmily
barfly14339653barf_ly
bawdily1635803bawdily
beastly1277563beastly
beatify1536593beatify
bedevil1344513bedevil_
bedevils1444373bedevils
beechy16397503bee_chy
beedi8711663beedi__
beedies10314203beedies
beef96233683beef___
beefalos1343653beefalos
beefed123510873beef_ed
beefiest13269013beefiest
beefs105618563beef__s
beehive1554033beehive
beelike13379783beelike
beeline93314723beeline
beeping124013913beeping
beerier93613023beerier
beery105220123bee__ry
beetle8311673bee_tle
befall114410643b_efall
befell11428713b_efell
befit105222663b_efi_t
befits114711503b_efits
beguile1056933beguile
beigy111110583b_e_igy
belfry1435073belf_ry
belly104625493b_e_lly
benefic1446043benefi_c
benefice1545003benefice
benefit1248073benefi_t
benefits1345713benefits
besmile1137463besmile
bewail1189583bewail_
bewails1277553bewails
bezil163812883b_ezil_
bezils1711310603b_ezils
bifidly1684233b_ifidly
biofilm1444333biofilm
bleakly1634663bleakly
blearily1365953blearily
bluffly1833433bluffly
bodily12310993b_odily
bonnily1236873bonnily
boozily2135623boozily
bossily1237563bossily
botfly1436093botf_ly
boxily1877843b_oxily
brevity1534783brevity
briefly1534573brief_ly
bulkily16227123bulkily
bumpily1665653bumpily
burlily1237713burlily
bushily15268893bushily
busily112211503b_usily
cheekily2053473cheekily
cheerily1655423cheerily
cheesily1654413cheesily
creepily1574953creepily
daffily1735133daffily
deafly13389123deaf_ly
deeply1257013dee_ply
deerfly1443983deerfly
defile105216663_defile
deftly1336533_deftly
dewily1338343_dewily
easily9313023_easily
edgily1136063_edgily
eely77725213_ee__ly
effigy1642213_effigy
feebly1436653fee_bly
fierily1339023fierily
fleecily1644013fleecily
gemmily1534603gemmily
goofily14105353goofily
greedily1345173greedily
headily1478623headily
heavily1665903heavily
heftily1635763heftily
huffily1934693huffily
jerkily2134623jerkily
keenly1336373kee_nly
leakily1436473leakily
liefly1266363lief_ly
meatily12311093meatily
medfly1535223medf_ly
meekly1535193mee_kly
meetly1138673mee_tly
merrily1238633merrily
messily12298813messily
nervily1336863nervily
peppily1335123peppily
perfidy1635263perfidy
perkily1637803perkily
peskily1635083peskily
pettily1238173pettily
prefile123413183prefile
puffily1834843puffily
readily11711403readily
reedify1465763reedify
reefier102912553reefier
reefing114016863reefing
reefy114217703reef__y
refile95122373_refile
refill94514053_refill
refilm114311403_refilm
refly113914563_ref_ly
seely84522633see__ly
seemly1138433see_mly
sexily1638853_sexily
sleepily1344823sleepily
speedily1465173speedily
tearily10311153tearily
techily1537123techily
telefilm1343453telefilm
testily102910803testily
verily122616053_verily
wearily1338783wearily
weekly1635313wee_kly
weevil1295433weevil_
weevilly1782623weevilly
weevils1384683weevils
wheezily2642303wheezily
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.1561145455.1
2DLD Change Limit1340271447.01619103.1
3Display Results1441440.0463130.4
 (SQL Overall)1786911447.21824756.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.