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

347 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
beacons1141073(None) 
bacons104917581b_acons
beacon10511371beacon_
deacons10310391deacons
bacon95620592b_acon_
barons85025382b_arons
batons85519422b_atons
beaches144120652beaches
beaconed1336982beaconed
beanos85516512beano_s
beans75734692bea__ns
beckons15279142beckons
belons84119412be_lons
betons84919552be_tons
blazons1836162blazons
deacon9510422deacon_
flacons1238052flacons
macons104017242_macons
neocons936912neocons
racons84319342_racons
reasons72514942reasons
recons84922992re_cons
seasons72614232seasons
weakons14287802weakons
weapons12278602weapons
weasons102310582weasons
acorns85013013__acorns
aeons57624653__aeons
agons66423783__agons
alencons1045483alencons
amazons1836653amazons
axons125517933__axons
azons146518253__azons
baboons113211083baboons
baboos103517013b_aboos
baches135426943b_aches
backs135729623b_ac_ks
bairns86710873b_airns
balcony1435853balcony
ballons93916963ballons
bancos104713893banco_s
banns75321233b_a_nns
bans66555143b_a__ns
barns76335143b_a_rns
baron78131243b_aron_
barong96015823b_arong
barongs105310833b_arongs
barony115915303b_arony
baryons121010473baryons
basins85722763b_asins
basions94213953basions
baton75822423b_aton_
bayous11411153b_ayous
bazoos173212623b_azoos
beach124623893beac__h
beachboys2142673beachboys
beached154516553beached
beaching164114143beaching
beachy164011253beac_hy
beaconing1436633beaconing
beaders104120183beaders
beading113221863beading
beadings123711783beadings
beadles103414733beadles
beads85429503bea__ds
beagles103212123beagles
beakers134216873beakers
beaks115326623bea__ks
beaming123618803beaming
beams95328173bea__ms
bean66443863bea__n_
beanies93821093beanies
beaning103820683beaning
beano75421553bea__no
bearcats1267023bearcats
beards94116673bea_rds
bearers94619593bearers
bearing103624773bearing
bearings113912253bearings
bears75739043bea__rs
beasts84519723bea_sts
beaten84617063beaten_
beaters94925043beaters
beating104326873beating
beatings114113233beatings
beats76042243bea__ts
beaucoup1442193beaucoup
beaucoups1541763beaucoups
beaus75127113bea__us
beauts86015283bea_uts
beavers124417323beavers
bebops1237623be_bops
becalms1335743becalms
becaps123811403be_caps
beckon14309383beckon_
becks135522013be_c_ks
beclogs1237073beclogs
beclowns1544683beclowns
become123312593be_come
becomes132911963be_comes
bedamns1235733bedamns
bedgowns1543113bedgowns
bedpans1237173bedpans
beduins1039123beduins
beeches143413883beeches
befogs1246453be_fogs
befools1236433befools
begins94415303be_gins
begone9512133be_gone
begroans1145503begroans
beknots1335083beknots
belabors1236403belabors
belches143514343belches
bellows124313303bellows
belon73924113be_lon_
belong93411043be_long
belongs10408223be_longs
belows114614183be_lows
bemeans1148743bemeans
bemoans1138253bemoans
bemocks1735373bemocks
benches143918603benches
benisons1037043benisons
bens65945703be___ns
benthons1337973benthons
bentos86218303bento_s
benzins1838693benzins
benzoins1945573benzoins
benzols1836673benzols
berlins93216013berlins
bescour1145203bescour
bescours1245093bescours
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bestows1248863bestows
betatrons1145083betatrons
bethorns1337323bethorns
beton76022063be_ton_
betony114211583be_tony
bettors93312473bettors
bevatrons1443713bevatrons
bevors111610343be_vors
beyond1237073be_yond
beyonds1335063be_yonds
bicorns11338763b_icorns
bicrons113410473bicrons
billons93013363billons
bisons83914373b_isons
blackens16388103blackens
blacks144914953blac_ks
blains84516373bla_ins
blazon1736763blazon_
bleaches153410673bleaches
bolsons969483bolsons
bonbons1139333bonbons
boocoos1137753boocoos
boons75031913b__oons
borons85520543b_orons
bosons85016653b_osons
bostons9312903bostons
boutons9310783boutons
bracers114616703bracers
braces108427773brac_es
braches144621223braches
brachs134415753brac_hs
bracing123817613bracing
bracings13369293bracings
brackens16327923brackens
braconid1345633braconid
braconids1444193braconids
bracts105617773brac_ts
bradoons1136763bradoons
brains85125473bra_ins
brans75437433bra__ns
bravoes12418533bravoes
bravos114711393bravo_s
brawns115614083bra_wns
brazens18418713brazens
breaches153714123breaches
brucins1158003brucins
buncos104011593bunco_s
bunions92210473bunions
burtons9310853burtons
buttons9310333buttons
canons85522063_canons
capons104119503_capons
celadons1137003celadons
claxons1635803claxons
cons66057693___cons
cratons94316033cratons
crayons12439233crayons
dacrons103211033_dacrons
daemons10269233daemons
deaconed1237493deaconed
deaconess1245543deaconess
deaconry1443323deaconry
deadens93410693deadens
deafens11317253deafens
deans66131393dea__ns
decagons1235893decagons
decors94017773de_cors
decos85522123de_co_s
decoys123911283de_coys
demons94917723de_mons
devons104512253de_vons
dragons938383dragons
earns55927563_ea_rns
ebons74316093_e_bons
eikons1038503_eikons
eons46638713_e__ons
escots84211743_escots
etalons739073etalons
exons125813343_e_xons
falcons1239123falcons
fanons96115213_fanons
felons93615763fe_lons
flacon1138633flacon_
flagons1137973flagons
garcons102411643garcons
gascons10289103gascons
guacos94410313guaco_s
halons95720713_halons
heavens13439303heavens
helicons1337613helicons
herons94820543he_rons
hexagons1943943hexagons
icons76516493__icons
jealous1438093jealous
jeans126022113jea__ns
jetons134512613je_tons
jettons1437273jettons
kaons95014853_ka_ons
kelsons1137323kelsons
klaxons1833263klaxons
leaches123319343leaches
leadens83610983leadens
leans55536253lea__ns
learns65513743lea_rns
leavens10409303leavens
legions84611783legions
lemons84415053le_mons
leptons91910433leptons
lesions73813873lesions
lessons73811023lessons
leucins938103leucins
leukons1135753leukons
lexicons1743893lexicons
limacons1243953limacons
macon94519953_macon_
macrons113514893_macrons
mascons113411583mascons
masons83916513_masons
meadows1337333meadows
means75831233mea__ns
megatons11279703megatons
melons84117713me_lons
meltons9410923meltons
menazons1945733menazons
merlons93311273merlons
mesons83215843me_sons
neatens73310403neatens
negatons9299273negatons
nektons1136393nektons
nelsons738003nelsons
neocon836713neocon_
neons55818683ne__ons
neurons7410453neurons
newtons1036813newtons
niacins938543niacins
paeons83915523_paeons
peaces106324083peac_es
peaches144120053peaches
peacing124117073peacing
peacoat11412913peacoat
peacoats1247833peacoats
peacock1745143peacock
peacocks1844993peacocks
peahens12307573peahens
peans75437643pea__ns
peascods1344063peascods
pecans101515833pe_cans
pennons939713pennons
peons75327183pe__ons
pereons92815003pereons
perrons93115483perrons
persons93717013persons
racon75422143_racon_
racoons93912433_racoons
radons74118533_radons
rayons94113343_rayons
reaches123423203reaches
reactions11711713reactions
reactors103212293reactors
reacts83616603reac_ts
readorns938283readorns
reagins84215643reagins
reason62616333reason_
reavows1335273reavows
reckons13269653reckons
recoins94019243re_coins
recon75624243re_con_
redons75222183re_dons
regions83613473regions
salons63823693_salons
seacoast1047783seacoast
seacock1545573seacock
seacocks1645643seacocks
seadogs958643seadogs
season62714903season_
seawans10379943seawans
seccos1039923secco_s
second9411153se_cond
seconds1038283se_conds
sermons9311783sermons
setons64620173se_tons
sextons143710413sextons
subdeacons1552653subdeacons
tacos77023553_taco_s
talons64019443_talons
tauons63412673_tauons
taxons134211503_taxons
teaches122718353teaches
teacups1133963teacups
teapots939053teapots
teapoys1235963teapoys
teflons1036543teflons
telcos8710683telco_s
telsons739223telsons
tendons8311473tendons
tenons62916603te_nons
testons7313563testons
treasons848683treasons
wagons103911213_wagons
weakens14367063weakens
weakon13357623weakon_
weans85326743wea__ns
weapon11288113weapon_
weason93210823weason_
xenons132710483xe_nons
yapons114411773_yapons
yeans86624883yea__ns
yearns9509543yea_rns
zealots1636763zealots
zealous1637813zealous
zeatins16311733zeatins
zircons1854963zircons

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.390458182.1
2DLD Change Limit1340273477.00019146.7
3Display Results3473470.1262754.0
 (SQL Overall)1786913477.51623774.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.