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

209 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
beclogs123707(None) 
beclog1136861beclog_
backlogs1746632backlogs
beckons15279142beckons
becloak1545042becloak
becloaks1644932becloaks
becloud1246292becloud
beclouds1345372beclouds
beclown1435422beclown
beclowns1544682beclowns
beflags1355492beflags
befogs1246452be_fogs
bellows124313302bellows
belongs10408222be_longs
belons84119412be_lons
belows114614182be_lows
blogs85319232b__logs
clogs85519552__clogs
decalogs1245632decalogs
unclogs1036802unclogs
weblogs1334222weblogs
analogs82810453analogs
apologs1038593apologs
backlog1635773backlog_
bacons104917583bac_ons
bailors93212413bailors
ballons93916963ballons
ballots94116033ballots
bandogs1138363bandogs
barlows12259983barlows
beacons11410733beacons
beanos85516513beano_s
beblood12106083beblood
bebloods13115233bebloods
bebops1237623be_bops
becalms1335743becalms
becaps123811403bec_aps
beckets15399823beckets
beckon14309383becko_n
becks135522013bec__ks
beclamors1574223beclamors
beclasp1335263beclasp
beclasps1444353beclasps
beclogged1643153beclogged
beclothe1545023beclothe
beclothes1645023beclothes
become123312593bec_ome
becomes132911963becomes
becrowd1555183becrowd
becrowds1683773becrowds
bedbugs13193503bedbugs
bedlams1237053bedlams
bedless1039703bedless
bedrugs11194283bedrugs
beflag1265883beflag_
befleas1236973befleas
befog1159013be_fog_
befools1236433befools
beglads11127263beglads
begloom1255243begloom
beglooms1344273beglooms
begs75733833be___gs
beholds1336423beholds
beings94613033be_ings
beknots1335083beknots
belays114313853be_lays
belches143514343belches
belga8313233be_l_ga
belgas9311713be_lgas
belies84631053be_lies
bellboys1544523bellboys
belles85325993be_lles
bellhops1544873bellhops
bellies94023723bellies
bellings113811153bellings
bellow114213353bello_w
bells76432163be_l_ls
belon73924113be_lo_n
belong93411043be_long
below104617193be_lo_w
bels66142493be_l__s
belts75931163be_l_ts
beluga936233be_luga
belugas1035903be_lugas
bentos86218303bento_s
benzols1836673benzols
bergs84718043be__rgs
berlins93216013berlins
besnows1245153besnows
besoms105712733be_soms
besots86415453be_sots
bestows1248863bestows
betons84919553be_tons
bettors93312473bettors
bevors111610343be_vors
bewigs1246533be_wigs
beylics1436183beylics
beyliks1634853beyliks
bicolors1256163bicolors
bicrons113410473bicrons
billons93013363billons
billows123611293billows
biogs85016113b__iogs
biology1337363biology
blobs95620033b__lobs
blocs95219653b__locs
blog75723823b__log_
blots75626173b__lots
blows105423833b__lows
bogs75742753b___ogs
bolos75531373b_olo_s
bowlegs13366823bowlegs
brulots946223brulots
buckoes153810393buckoes
buckos143710893bucko_s
bugloss1035893bugloss
bulldogs1274243bulldogs
bullous9311663bullous
cellos84517803cello_s
celoms10412123ce_loms
clags85621123__clags
clods85320863__clods
clog76123243__clog_
clons75228133__clons
clops95924853__clops
clots75627643__clots
cloys104916943__cloys
cogs77340033__c_ogs
cologs96517353_cologs
cyclops1635383cyclops
cyclos1338073cyclo_s
decalog1136003decalog_
declass1038733declass
declaws1336253declaws
decolors1187713decolors
decors94017773dec_ors
decos85522123dec_o_s
decoys123911283dec_oys
defogs1156683de_fogs
deploys1336523deploys
dialogs938103dialogs
duologs935363duologs
echoes114715523_echoes
echos105216463_echo_s
eclats8313033_eclats
eclogue1044503_eclogue
eclogues1144573_eclogues
ecology13218823_ecology
epilogs1076583epilogs
eulogy1035633_eulogy
felloes104114383felloes
fellows134212433fellows
felons93615763fe_lons
flogs95919963__flogs
geckoes14325793geckoes
geckos13457433gecko_s
geology12257323geology
hectors123513263hectors
helloes103717473helloes
hellos95321683hello_s
helos84928063he_lo_s
helots95217703he_lots
incogs937903inc_ogs
isologs837433isologs
jealous1438093jealous
jellos134714283jello_s
jetlags1533863jetlags
lectors93415773lectors
logs57343113___logs
mellows123812233mellows
melons84117713me_lons
merlons93311273merlons
merlots92710123merlots
neology11238293neology
ocelots977233ocelots
oecology14227273oecology
peplos101211543peplo_s
prologs103512133prologs
putlogs1065083putlogs
reckons13269653reckons
reclads1049993reclads
recolors1078813recolors
recons84922993rec_ons
recooks134711233recooks
recross989843recross
rectors93520523rectors
rectos85718783recto_s
redlegs936823redlegs
reflags1156953reflags
reflows13258983reflows
regloss8218023regloss
reglows11288843reglows
replots93412633replots
replows12329703replows
sawlogs1135393sawlogs
seadogs958643seadogs
seccos1039923secco_s
sectors93116453sectors
slogs64521843__slogs
teflons1036543teflons
telcos8710683telco_s
telos55424523te_lo_s
theologs1246153theologs
unclog956603unclog_
vectors123212593vectors
weblog1234223weblog_
yellows13329603yellows
zealots1636763zealots
zealous1637813zealous

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.406440125.6
2DLD Change Limit1340272097.36018210.2
3Display Results2092090.0762750.0
 (SQL Overall)1786912097.84222786.4
 
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.