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

488 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
epoch124820(None) 
epochs1335811epochs
cooch124916832cooch
each95530582e_ach
epact94921532epact
eparch13258422eparch
ephah1337062ephah
epic86921302epic_
epics95014282epics
epochal1445242epochal
epode85114092epode
epos66723732epo_s
epoxy17465772epoxy
etch95419142e_tch
hooch135813702hooch
loch95527132_loch
mooch125313612mooch
peach125422492peach
pech116125452_pech
perch124518832perch
poach124917862_poach
pock126129292_pock
poco86826152_poco
poh86740532_po_h
pooch124815302pooch
pooh96027382_pooh
porch125918622_porch
posh95427322_posh
pouch124617082_pouch
acock132110213acock
aitch105216163aitch
apace94718383apace
apache134210783apache
apish105116633apish
apo511142123apo__
apod78123183apo_d
apods86316343apods
aport75432173aport
apos65433823apo_s
arch98628443_arch
avouch1434833avouch
azoth17389903azoth
bach116131393_bach
batch124620103batch
beach124623893beach
beech124315503beech
belch124415503belch
bemock1636173bemock
bench125619503bench
birch124914023birch
bitch125017763bitch
bloc85023273bloc_
block134917843block
blocs95219653blocs
blotch13197143blotch
boche124216953_boche
bock126032513_bock
booth105522013booth
bosh96328973_bosh
botch126717453botch
both96533433_both
brach126123303brach
broach133611113broach
broche133612103broche
brock136017073brock
brooch13368443brooch
broth106521093broth
bunch125118603bunch
butch125416543butch
capouch1644413capouch
caroch13911763caroch
catch125120373catch
chock164316613chock
cinch124516243cinch
clach124617823clach
cloche134312373cloche
clock134917983clock
cloth105817543cloth
coach125919453coach
coca88030643_coca
cock126332903_cock
coco87330603_coco
conch124620073conch
cosh96127623_cosh
couch125320113couch
croc85723733croc_
croci95818133croci
crock135921993crock
crocs95722433crocs
crotch133410083crotch
crouch133910203crouch
culch124512833culch
curch124415413curch
cutch125116193cutch
debouch15124253debouch
decoct11313783decoct
depict113514793depict
depone93616553depone
deport94922393deport
depose94215763depose
depot85727923depo_t
depots94716343depots
depth114311853dep_th
detach12310413detach
ditch115015093ditch
doc66841513_doc_
dock116228743_dock
docs75631153_docs
doth86225713_doth
dunch115316263dunch
dutch114713823dutch
earth85023053earth
eath75735663e_ath
ebon66821103ebo_n
ebons74316093ebons
ebony104511513ebony
ebook114510803ebook
eche97520283e__che
echo96615953e__cho
echt95722903e__cht
ecu56828233e__cu
edh76921563e__dh
edict84722283edict
educe84313453educe
educt85017103educt
ego46726053ego__
egos55821653ego_s
eh58339963e___h
eject145016043eject
elect74327033elect
eloin55923203eloin
elope75219343elope
emic86422753emic_
emote75421193emote
enact73525363enact
enoki9268873enoki
enol45823823eno_l
enols54718403enols
enorm74415643enorm
enough1045763enough
enow77819873eno_w
enows85115493enows
enrich1138943enrich
eon36052083e_o_n
eons46638713e_ons
epacts105010393epacts
eparchs14196243eparchs
eparchy17204753eparchy
epee64628503ep_ee
epees75219833epees
epha9310053ep_ha
ephahs1435503ephahs
ephas10311543ephas
ephod1139123ephod
ephods1238363ephods
ephor10310013ephor
ephori1139603ephori
ephors11311403ephors
epical10413393epical
epodes94315563epodes
eponym1345793eponym
epopee10312503epopee
eposes84418783eposes
erect74129333erect
erica7316543erica
erode64520993erode
eros45238453ero_s
erose55727273erose
eruct74022353eruct
escot75320083escot
eth66630983e__th
etic66123953etic_
eunuch1154363eunuch
evict104417143evict
evoke12478853evoke
exact143516933exact
exarch18196173exarch
exec135313943exec_
execs14539723execs
exon117116803exo_n
exons125813343exons
expect1758903expect
expo1349183expo__
export15412183export
expos1449203expo_s
expose1549523expose
fetch134913473fetch
fetich1479693fetich
filch134813323filch
finch135416973finch
fitch134816873fitch
floc95922123floc_
flock144717423flock
flocs105519233flocs
foci94521013_foci
foh98135893_fo_h
frock145314653frock
frosh115713403frosh
froth115919283froth
gosh86123423_gosh
goth86825083_goth
grouch12318473grouch
gulch113810603gulch
hatch135719593hatch
heuch135312333heuch
hitch134515473hitch
hock136031303_hock
hootch14386413hootch
hotch136214733hotch
hunch136416213hunch
hutch135414093hutch
ich86227743__ich
inch95420823_inch
itch95619173_itch
jock176522643_jock
josh145117613_josh
kench145513923kench
ketch144912023ketch
knock10487963knock
koph135816543_koph
laich105920713laich
larch105919793larch
latch104620463latch
leach105422523leach
lech96825443_lech
leech104913213leech
letch105215803letch
lich96230843_lich
loach105116363loach
loca65527683_loca
lochs106715513_lochs
loci66126283_loci
lock106134363_lock
loco67030743_loco
loth76132133_loth
lunch104917243lunch
lurch104814633lurch
lych126015763_lych
lynch13468983lynch
mach116134483_mach
march125622893march
match125621103match
mensch13387103mensch
merch125417963merch
milch124413373milch
moc77845083_moc_
mocha1249923_mocha
mock126429443_mock
mocs85834903_mocs
moloch1356483moloch
mosh95227603_mosh
moth96731333_moth
mouch124715803mouch
much115224033_much
mulch124012973mulch
munch124917103munch
mutch125016173mutch
natch105018223natch
nock106127183_nock
noh66640643_no_h
nosh76223543_nosh
notch105613323notch
oca56731733__oca
oh57447003__o_h
ooh67637093__ooh
opah96218403op_ah
orach105219233orach
ouch95724633_ouch
pac79054083_pac_
paca85132243_paca
pace86345773_pace
pacha126518063_pacha
pack125535443_pack
pacs85842183_pacs
pact86648723_pact
pacy115328683_pacy
pah88853593_p_ah
parch125123003parch
pash95638133_pash
patch125221223patch
path99134913_path
peace95026083peace
peachy164510843peachy
pec76744413_pec_
pechs125516203_pechs
peck125730683_peck
pecs84634103_pecs
peh86740963_p_eh
pence94924453pence
penoche1447043penoche
peon65635243peo_n
peons75327183peons
peony105717563peony
pepo87622153pepo__
pepos96620083pepo_s
pic76046823_pic_
pica85831493_pica
pice84641093_pice
pick125933813_pick
pics85633913_pics
pinch125619303pinch
pish96127913_pish
pitch125018413pitch
pith95432693_pith
poachy16388963_poachy
pocks135022963_pocks
pocky165314603_pocky
pod66351483_po_d
pods76540153_pods
poem86225773_poem
poet65552903_poet
pogy105623553_pogy
poi57244663_po_i
pois66539043_pois
poke105335363_poke
poky135922153_poky
pol56449383_po_l
pole65951303_pole
poll66332133_poll
polo66236633_polo
pols66044563_pols
poly96235153_poly
pom78249913_po_m
pome85636693_pome
pomo85828453_pomo
pomp106225463_pomp
poms87037743_poms
ponce95222513_ponce
poncho133310123_poncho
pond75530493_pond
pone65747533_pone
pong76231143_pong
pons65850603_pons
pony96434053_pony
poo57757113_po_o
pood75934323_pood
poof95541663_poof
poohs103915713_poohs
pool65835953_pool
poon67341263_poon
poop86532813_poop
poor65630223_poor
poos65949113_poos
pop76252253_po_p
pope85535613_pope
pops86340953_pops
pore66451263_pore
pork106929683_pork
porn65636023_porn
port66059633_port
pose66441733_pose
post67953363_post
posy96028423_posy
pot58078433_po_t
pots66452363_pots
pouchy16538663_pouchy
pouf95732643_pouf
pour611527473_pour
pout65752553_pout
pow87147283_po_w
pows95537663_pows
pox126140693_po_x
poxy166820893_poxy
psych1554963psych
puce85127883_puce
puck124927943_puck
pugh106619233_pugh
punch125118423punch
push95526623_push
qoph185911943_qoph
quoth173310353quoth
ranch105019793ranch
ratch104221363ratch
reach105123883reach
recock145112723recock
redock134311543redock
relock124713523relock
repack142412163repack
repatch1435843repatch
repo66027543repo__
repoll8410793repoll
report85326023report
repos74725793repo_s
repose84121413repose
repot75132623repo_t
repots85621003repots
repour8310993repour
reproach1544953reproach
retch104818303retch
retouch1235863retouch
rich97025543_rich
roach105717003roach
roc520243253_roc_
rock105735183_rock
rocs65533663_rocs
rotch105815933rotch
sauch104918773sauch
scooch13228123scooch
scorch13198093scorch
scotch13207523scotch
search113312423search
sepic94617053sepic_
sepoy10314303sepo_y
sepoys1138473sepoys
shock144917033shock
skosh12407273skosh
slosh84514483slosh
sloth85019453sloth
slouch11438523slouch
smock135311673smock
smooch13266803smooch
soca66330053_soca
sock105233213_sock
sooth85924063sooth
soph97024203_soph
soth75932523_soth
space95325673space
spacy125415623spacy
spec85821973spec_
speck135115653speck
specs96916673specs
speech1347563speech
spic85227433spic_
spica94717943spica
spice95528813spice
spick134519073spick
spics94123243spics
spicy125417713spicy
splosh1186543splosh
splotch1442853splotch
spode84617703spode
spoil75818653spoil
spoke114818663spoke
spoof105019013spoof
spook115416043spook
spool75219043spool
spoon74719443spoon
spoor75016353spoor
spore75428593spore
sport75935983sport
spot65540693spo_t
spots74424113spots
spout75029633spout
stich104117923stich
stock114417563stock
subepoch1742503subepoch
such96424813_such
synch135011793synch
tach96132753_tach
teach105221123teach
tech95925443_tech
tench105620003tench
tepoy10312163tepo_y
tepoys1137543tepoys
teuch105214853teuch
tooth88020183tooth
toph96326873_toph
torch107420933torch
tosh74826813_tosh
touch106519393touch
troche113112513troche
trock114817603trock
troth85622203troth
upo58925863upo__
upon65817583upo_n
veloce11310133veloce
vetch134411843vetch
vouch134611903vouch
watch135617063watch
welch134411493welch
wench136214783wench
which163910083which
wich125724743_wich
winch135016663winch
witch134517563witch
woosh113710733woosh
wroth116815883wroth
wych154011883_wych
yapock17365383yapock
yecch15558093yecch
yech127220533_yech
yock135924613_yock
yodh119916103_yodh
yogh116616143_yogh
yucch15417433yucch
yuch125818533_yuch
zeroth1837963zeroth
zilch19438123zilch

Search took 5 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 Filter178691836670.343520965.0
2DLD Change Limit836674883.78022134.1
3Display Results4884880.1403485.7
 (SQL Overall)1786914884.26341916.7
 
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.