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

292 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
epopee1031250(None) 
epopees1137231epopees
apogee9312562apogee
elope75219342elop_e
eloped95914142eloped
eloper85414152eloper
elopes85918162elopes
epee64628502e__pee
epode85114092epo_de
epodes94315562epodes
eposes84418782eposes
people10310192people
pope85535612_pop_e
popes95933812_popes
topee76029952_topee
adoptee1048413adoptee
apogees1037103apogees
appel94615893ap_pel
apple94517673ap_ple
appose10411993appose
bootee84323023bootee
bopeep1236763_bopeep
bopped134413403bopped
bopper123813833bopper
cooee74531023_cooee
cooped114821603cooped
cooper104221123cooper
cope86847383_cop_e
coped105036843_coped
copen94826433_copen
coper95336093_coper
copes97747103_copes
copped135221253copped
copper124321893copper
copse95623923_copse
depeople1344343depeople
depone93616553depo_ne
deponed113712873deponed
depones103717093depones
deportee11510353deportee
depose94215763depo_se
deposed113412023deposed
deposer104011843deposer
deposes103117213deposes
devotee113811823devotee
donee66931013_donee
doolee73018953doolee
dope76038893_dop_e
doped95326713_doped
doper86128393_doper
dopes84935043_dopes
dopey116020353_dopey
elapse857523elapse
elodea738673elodea
elopers95112943elopers
emcee9315943e_mcee
emote75421193emo_te
emoted94614923emoted
emoter85415193emoter
emotes84620283emotes
employee1555203employee
empower14217033empower
entree61817883entree
eocene8311613e_ocene
epees75219833ep_ees
ephebe1336063ephebe
epicene1148593epicene
epigene1037893epigene
epimer10109153epimer
epimere1186983epimere
epitope1147053epitop_e
epitopes1246973epitopes
epoch1248203epo_ch
epochs1335813epochs
eponym1345793eponym
epopoeia1254673epopoeia
epos66723733epo__s
epoxide1745343epoxide
epoxied1734813epoxied
epoxies1637753epoxies
epoxy17465773epo_xy
epoxyed2032293epoxyed
erode64520993ero_de
eroded84313583eroded
erodes74819883erodes
erose55727273ero_se
eroses65327053eroses
escapee113310463escapee
espouse936403espouse
etape74413703etap_e
etapes85415293etapes
etoile6312263etoile
etwee84115333e_twee
evoke12478853evo_ke
evoked14457883evoked
evoker13467913evoker
evokes13459683evokes
evolve12306503evolve
exogen1436513exogen
expel1448233e_xpel
expose1549523expo_se
exposed1737443exposed
exposer1637413exposer
exposes1639963exposes
fopped144012673fopped
grope84821613grop_e
groped107515053groped
groper94517253groper
gropes95220403gropes
hepper133412663hep_per
hooped125518183hooped
hooper114518313hooper
hoopoe11911233hoopoe
hope96639673_hop_e
hoped115628183_hoped
hoper105829143_hoper
hopes105835643_hopes
hopped144318113hopped
hopper134218483hopper
hopple132910483hopple
kepped15309543kep_ped
keppen14346573kep_pen
kopek1037813_kopek
kopje1835273_kopje
koppie14277883koppie
looped95217173looped
looper83817113looper
lope65941923_lop_e
loped85128333_loped
loper75129233_loper
lopes76437343_lopes
lopped114218623lopped
lopper103717203lopper
metopae1147743metopae
metope10611123metop_e
metopes11311363metopes
mope86838043_mop_e
moped105424733_moped
moper94925923_moper
mopes95134983_mopes
mopey124821823_mopey
mopped134114323mopped
mopper126215003mopper
moppet126915093moppet
myope124010973myop_e
myopes13419963myopes
nope65934193_nop_e
ogee57629883__ogee
ope56845243__op_e
oped76230153__oped
open66427003__open
opes65942613__opes
oppose1039193oppose
paper95128663_paper
payee105524723_payee
pee56066513___pee
peeped113915393peeped
peeper103614803peeper
peewee11311963peewee
pensee8417313pensee
peones83821043peones
peopled1238503peopled
peopler1138083peopler
peoples11312223peoples
pepped103113403pepped
pepper93512943pepper
pewee10319973_pewee
pipe86434433_pip_e
piped105123163_piped
piper96523193_piper
pipes96030143_pipes
pipet95533323_pipet
poem86225773_po_em
poet65552903_po_et
pogey116017893_pogey
poise75127893_poise
poke105335363_po_ke
poked125425393_poked
poker115122883_poker
pokes116133013_pokes
pokey145318973_pokey
pole65951303_po_le
poled84934843_poled
poler74431793_poler
poles75351003_poles
pollee83623273_pollee
pome85636693_po_me
pomes94833933_pomes
pommee122813283_pommee
ponce95222513_ponce
pone65747533_po_ne
pones74547043_pones
pongee94920193_pongee
pooed85226243_pooed
pooped113915943pooped
poove104514303_poove
pop76252253_pop__
popery134511703_popery
popeyed1535713_popeyed
poppa8409893_poppa
popped104117813_popped
popper93615963_popper
poppet92717323_poppet
popple92710983_popple
poppy114813193_poppy
pops86340953_pop_s
popsie103013053_popsie
popsy125713403_popsy
pore66451263_po_re
pored85234513_pored
pores75849033_pores
pose66441733_po_se
posed85828413_posed
poser75128773_poser
poses74642763_poses
posse74722273_posse
poteen83514263_poteen
potpie103412433_potpie
power105325953_power
poxed154817863_poxed
poxes145325723_poxes
pree67044733_p_ree
propel103714063propel
propene112716043propene
proper104319953proper
pupae96515643_pupae
puree74632843_puree
rappee103618673rappee
reopen8311573reopen
repaper11310023repaper
repeople1245063repeople
repose84121413repo_se
reposed103616273reposed
reposer93715333reposer
reposes94021263reposes
repower12329883repower
repped114616723rep_ped
rope65542913_rop_e
roped84630803_roped
roper75431913_roper
ropes75940063_ropes
ropey106021873_ropey
rupee7321283_rupee
scope94821483scop_e
scoped115116653scoped
scopes104719593scopes
shoppe133110323shoppe
slope75823563slop_e
sloped94216853sloped
sloper84615913sloper
slopes84820453slopes
sopped114819903sopped
spahee11313443spahee
spode84617703spo_de
spodes94817433spodes
spoke114818663spo_ke
spoked134413893spoked
spoken124610003spoken
spokes124417213spokes
spondee10310593spondee
sponge939663sponge
spore75428593spo_re
spored94821793spored
spores84726613spores
spouse84112513spouse
spree74830863sp_ree
stope74727243stop_e
stoped94721013stoped
stoper84320103stoper
stopes84525893stopes
teepee8314363teepee
tepee74724213_tepee
tope65946383_top_e
toped85631313_toped
topees85519703_topees
toper75231023_toper
topes76941763_topes
tophe106718973_tophe
topped114617723topped
topper103817603topper
topple104411323topple
toupee8316133toupee
trope75725803trop_e
tropes84824353tropes
unopen838913unopen
upped103715163up_ped
upper93714263up_per
veepee11311483veepee
whoopee15287513whoopee
yippee132810743yippee
yogee9518063_yogee
zeppole2043493zeppole

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.373479064.3
2DLD Change Limit1127162925.47020606.2
3Display Results2922920.0933139.8
 (SQL Overall)1786912925.93630102.9
 
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.