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

217 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
bemock163617(None) 
bemocks1735371bemocks
beck126226572be__ck
bedeck1536212bedeck
bedrock1645642bedrock
bemoan10310252bemoan
bemocked1934072bemocked
betook12439602betook
block134917842b_lock
bock126032512b__ock
brock136017072b_rock
hemlock1845632hemlock
mock126429442__mock
recock145112722recock
redock134311542redock
relock124713522relock
smock135311672_smock
abelmosk1641203abelmosk
acock132110213_acock
amok10217403_amo_k
amuck1389563_amuck
armlock1544313armlock
back125535763b__ack
bannock1545043bannock
bawcock20144033bawcock
beach124623893be_ach
beacon10511373beacon
beak106534383be__ak
bebop11410793bebo_p
bebops1237623bebops
becks135522013be__cks
becloak1545043becloak
become123312593become
bedecks1635793bedecks
bedrocks1745333bedrocks
bedtick1645233bedtick
beech124315503be_ech
befleck1843943befleck
befog1159013befo_g
befogs1246453befogs
befool1137713befool
before11410153before
befoul1137253befoul
begone9512133begone
begot84625953bego_t
behold1247343behold
behoof1458683behoof
behove14207203behove
behowl1445533behowl
belch124415503be_lch
belon73924113belo_n
belong93411043belong
belons84119413belons
below104617193belo_w
belows114614183belows
bema85825253bem__a
bemas96424283bem_as
bemata10411693bemata
bemean10410683bemean
bemire103312803bemire
bemist105216963bemist
bemix165011453bem_ix
bemixt174510363bemixt
bemoans1138253bemoans
bemocking2034653bemocking
bemuse1038943bemuse
bench125619503be_nch
berk105929843be__rk
besmoke15416623besmoke
besom95716973beso_m
besoms105712733besoms
besot76429713beso_t
besots86415453besots
beton76022063beto_n
betons84919553betons
betony114211583betony
bevor101510813bevo_r
bevors111610343bevors
beworm1339993beworm
beylik1545883beylik
beyond1237073beyond
bezoar1736913bezoar
bibcock1943533bibcock
binocs1039923binocs
bipack1636523bipack
bittock1544433bittock
black134719073b_lack
bloc85023273b_loc_
blocks144513943b_locks
blocky17388353b_locky
blocs95219653b_locs
bocks134526573b__ocks
bonk105531713b__onk
bonnock1545203bonnock
book106836333b__ook
bork106933823b__ork
bosk105825733b__osk
brick134618153b_rick
brocks145214153b_rocks
brooch13368443brooch
brook114717763b_rook
buck125129903b__uck
bullock1537193bullock
burdock1644603burdock
buttock1545563buttock
bywork1834863bywork
chock164316613_chock
clock134917983_clock
cock126332903__cock
crock135921993_crock
deck115827753de__ck
decoct11313783decoct
defrock1744643defrock
demark134211023demark
demic105119193demic_
demo77427553demo__
demob104913503demo_b
demobs11429483demobs
demode104013463demode
demoed103713443demoed
demon86520313demo_n
demons94917723demons
demos86022993demo_s
demote94817803demote
detick1339383detick
dock116228743__dock
ebook114510803_ebook
embosk1464863_embosk
emic86422753_emic_
emote75421193_emote
epoch1248203_epoch
feck134923433fe__ck
femora1149583femora
fetlock1645323fetlock
flock144717423_flock
frock145314653_frock
geck115721993ge__ck
gemot84024233gemo_t
gemote94613023gemote
gemots93712153gemots
hammock2064633hammock
heck135826493he__ck
hemic125718623hemic_
hemlocks1944993hemlocks
hemoid12313513hemoid
hock136031303__hock
hommock2043993hommock
hummock2063793hummock
jock176522643__jock
kebbock1643613kebbock
keck94920713ke__ck
knock10487963_knock
lemon75618183lemo_n
lemons84415053lemons
lemony11419553lemony
lock106134363__lock
mack125733653__mack
mammock1664393mammock
medick154010133medick
memo85924793memo__
memoir1037213memoir
memory1338803memory
memos95719113memo_s
mick126333433__mick
moc77845083__moc_
mocks135023823__mocks
mocs85834903__mocs
monk105928523__monk
mosk105622443__mosk
muck125727853__muck
neck105423663ne__ck
nock106127183__nock
peacock1745143peacock
peck125730683pe__ck
petcock1744603petcock
pock126129293__pock
prerock1536723prerock
rebeck14419913rebeck
rebook125213203rebook
reck106130563re__ck
recocks154711463recocks
recook125513923recook
recork126315493recork
redocks14409933redocks
relocks134411293relocks
relook104813743relook
remark123512373remark
remold93412973remold
remora8414593remora
remote84222603remote
remove116115573remove
repack142412163repack
rerack122513163rerack
resoak10311093resoak
restock1338673restock
retack122612823retack
retook104313443retook
rework136619793rework
rimrock1544383rimrock
rock105735183__rock
seacock1545573seacock
shlock15378193shlock
shmuck1734243shmuck
shock144917033_shock
smack134615453_smack
smocks145710013_smocks
sock105233213__sock
stock114417563_stock
trock114817603_trock
uncock1438563uncock
undock1337703undock
unlock1248533unlock
veloce11310133veloce
wedlock1744553wedlock
yapock17365383yapock
yock135924613__yock
zebeck23255203zebeck

Search took 6 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 Filter1786911127160.390458182.1
2DLD Change Limit1127162175.25321457.5
3Display Results2172170.0762855.3
 (SQL Overall)1786912175.71931245.1
 
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.