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

220 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
epopees113723(None) 
epopee10312501epopee_
apogees1037102apogees
elopers95112942elopers
elopes85918162elop_es
epees75219832e__pees
epodes94315562epo_des
eposes84418782epo_ses
epoxies1637752epoxies
peoples11312212peoples
popes95933812_pop_es
topees85519702_topees
adoptees1145123adoptees
apoapses1244713apoapses
apogee9312553apogee_
appels104312793ap_pels
apples104315763ap_ples
apposes11511473apposes
atopies92816433atopies
bootees94114473bootees
bopeep1236763_bopeep
bopeeps1333103_bopeeps
boppers133911923boppers
cooees85621893_cooees
coopers114019483coopers
copens106119963_copens
copers104629843_copers
copes97747103_cop_es
copies104130303_copies
coppers133519753coppers
copses104922473_copses
depeoples1444223depeoples
depones103717093depo_nes
deportees1256643deportees
deposers11359243deposers
deposes103117213depo_ses
devotees12286283devotees
donees74519493_donees
doolees83711613doolees
dopers95522483_dopers
dopes84935043_dop_es
ebonies9312883ebonies
egoless836983egoless
elapses957663elapses
elodeas836963elodeas
elope75219343elop_e_
eloped95914143elop_ed
eloper85414153elop_er
emcees1037813e_mcees
emoters94712873emoters
emotes84620283emo_tes
employees1653393employees
empowers15276843empowers
entrees71813773entrees
epee64628503e__pee_
ephebes1436153ephebes
epicenes1249253epicenes
epimeres12117653epimeres
epimers11109493epimers
epitopes1246973epitop_es
epochs1335813epo_chs
epode85114093epo_de_
eponyms1444853eponyms
epopoeia1254673epopoeia
epopoeias1353973epopoeias
epos66723733epo___s
epoxides1844863epoxides
epoxied1734813epoxied
epoxyed2032293epoxyed
erodes74819883ero_des
eroses65327053ero_ses
escapees12336333escapees
espies83716803e_spies
espouses1037303espouses
etapes85415293etap_es
etoiles7411293etoiles
etwees9348793e_twees
evokers14386793evokers
evokes13459683evo_kes
evolves13286743evolves
exogens1536883exogens
expels1547173e_xpels
exposers1736133exposers
exposes1639963expo_ses
gropers104813853gropers
gropes95220403grop_es
hoopers123616483hoopers
hoopoes121212483hoopoes
hopers114222973_hopers
hopes105835643_hop_es
hoppers143115143hoppers
hopples142810713hopples
kopeks1134603_kopeks
kopjes1935363_kopjes
koppies153210013koppies
loopers93914033loopers
lopers84424143_lopers
lopes76437343_lop_es
loppers113014103loppers
metopes11311363metop_es
mopeds11499663_mopeds
mopers104220373_mopers
mopes95134983_mop_es
moppers133412453moppers
moppets13307163moppets
myopes13419963myop_es
myopies14309723myopies
ogees65119143__ogees
opens76118553__opens
opes65942613__op_es
opposes1149243opposes
papers105125323_papers
payees114812903_payees
peepers113713673peepers
pees65257373___pees
peewees1236803peewees
pensees9311203pensees
peones83821043peo_nes
peonies93620153peonies
people10310183people_
peopled1238493peopled
peopler1138073peopler
peoplers1237153peoplers
peppers103311443peppers
pewees11311393_pewees
pipers104318663_pipers
pipes96030143_pip_es
pipets105714773_pipets
poems95715553_po_ems
poets76024443_po_ets
pogeys124110353_pogeys
pogies94123543_pogies
poises84226543_poises
pokers124617923_pokers
pokes116133013_po_kes
pokeys15529513_pokeys
pokies125921333_pokies
poleis86018353_poleis
polers84225643_polers
poles75351003_po_les
polies84034583_polies
pollees93215333_pollees
pomes94833933_po_mes
ponces104720843_ponces
pones74547043_po_nes
pongees104212543_pongees
ponies84833463_ponies
pontes83627853_pontes
pooves113914713_pooves
pope85535613_pop_e_
popeless1288473_popeless
poperies12316793_poperies
popery134511703_popery
popeyed1535703_popeyed
poppas93710713_poppas
popped104117813_popped
popper93615963_popper
poppers103414863_poppers
poppet92717323_poppet
poppets10338853_poppets
poppies102816193_poppies
popples103011873_popples
pops86340953_pop__s
popsies112816463_popsies
pores75849033_po_res
posers84223973_posers
poses74642763_po_ses
posies84431433_posies
posses85128803_posses
poteen83514263_poteen
poteens92910883_poteens
potpies113116173_potpies
powers113822323_powers
poxes145325723_po_xes
prees75937173_p_rees
propels113412843propels
propenes122816513propenes
propers113619033propers
purees84721683_purees
rappees113611453rappees
recopies12313733recopies
reopens939373reopens
repapers1258833repapers
repeoples1345413repeoples
reposers102911603reposers
reposes94021263repo_ses
repowers13288533repowers
ropers84325903_ropers
ropes75940063_rop_es
rupees8312573_rupees
scopes104719593scop_es
shoppes143411383shoppes
slopers94213093slopers
slopes84820453slop_es
spahees1238263spahees
spodes94817433spo_des
spokes124417213spo_kes
spondees1136483spondees
sponges10311043sponges
spores84726613spo_res
spouses92912813spouses
sprees85620643sp_rees
stopers94217363stopers
stopes84525893stop_es
teepees939263teepees
tepees84215243_tepees
topee76029953_topee_
topers85025323_topers
topes76941763_top_es
tophes115218423_tophes
toppers113914603toppers
topples113111653topples
toupees938513toupees
tropes84824353trop_es
uppers102912283up_pers
veepees1245813veepees
whoopees16294823whoopees
woopses1237883woopses
yogees10510633_yogees
zeppoles2143583zeppoles

Search took 9 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.1701051123.5
2DLD Change Limit1340272208.34316064.6
3Display Results2202200.0962291.7
 (SQL Overall)1786912208.60920756.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.