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

242 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
eparch1325842(None) 
eparchs14196241eparchs
eparchy17204751eparchy
exarch18196171exarch
parch125123001_parch
anarch11310392anarch
arch98628442__arch
each95530582e_a_ch
earth85023052e_arth
endarch1345442endarch
epact94921532epa_ct
epoch1248202ep_och
exarchs19165192exarchs
exarchy22193692exarchy
heptarch1843562heptarch
inarch1139162inarch
larch105919792_larch
march125622892_march
mesarch1445532mesarch
patch125221222_patch
peach125422492pea_ch
perch124518832_perch
porch125918622_porch
repatch1435842repatch
search113312422search
starch113013202starch
xerarch1943842xerarch
aargh96314083_aargh
anarchs1237093anarchs
anarchy1544933anarchy
apace94718383apa_ce
apache134210773apa_che
apart74330673apar_t
apercu1057383apercu
arc510250903__arc_
arco68331543__arco
arcs67834783__arcs
autarch1246623autarch
bach116131393_ba_ch
barca91319433_barca
batch124620103_batch
beach124623893bea_ch
birch124914023_birch
blanch133410853blanch
brach126123303bra_ch
branch134014773branch
caroch13911763_caroch
catch125120373_catch
church1636483church
clach124617823cla_ch
coach125919453coa_ch
cranch133613533cranch
cratch134110793cratch
curch124415413_curch
dearth104212513dearth
debauch15134423debauch
demarche1645533demarche
depart94720563depar_t
departs104310683departs
despatch1643223despatch
detach12310413deta_ch
diarchy1644673diarchy
dyarchy1942503dyarchy
ear36867883e_ar__
earache1239323e_arache
eared65139503e_ared
earl45838143e_ar_l
earls56127513e_arls
early85324123e_arly
earn46737553e_ar_n
earns55927563e_arns
ears46356593e_ar_s
earths95014593e_arths
earthy12399943e_arthy
eath75735663e_a_th
ecarte84313503ecarte
eldrich1354583eldrich
enact73525363ena_ct
endarchy1743343endarchy
enrich1138943enrich
epacts105010393epacts
eparchial1644403eparchial
eparchies1646973eparchies
ephah1337063ep_hah
epic86921303ep_ic_
epics95014283ep_ics
epochs1335813ep_ochs
esparto944233esparto
etch95419143e__tch
ethnarch1642403ethnarch
eunuch1154363eunuch
exact143516933exa_ct
exarchal2043723exarchal
farce104925323_farce
farci105919313_farci
farcy135217093_farcy
garth94720223_garth
harsh116418053_harsh
hatch135719593_hatch
hearth125315213hearth
heparin12410433heparin
heptarchs1943043heptarchs
heptarchy2252283heptarchy
hexarchy2642873hexarchy
hierarch1644033hierarch
hipparch2042823hipparch
klatch15445933klatch
laich105920713_laich
latch104620463_latch
leach105422523lea_ch
loach105116363loa_ch
lurch104814633_lurch
mach116134473_ma_ch
marc87034623_marc_
marcs95726623_marcs
marsh105320853_marsh
match125621103_match
menarche1545813menarche
merch125417963_merch
monarch1445953monarch
narc67127953_narc_
narco76718243_narco
narcs76122023_narcs
natch105018223_natch
nomarch1445343nomarch
opah96218403opa__h
orach105219233ora_ch
overarch1647243overarch
pac79054083_pa_c_
paca85132243_pa_ca
pace86345773_pa_ce
pacha126518063_pa_cha
pack125535443_pa_ck
pacs85842183_pa_cs
pact86648723_pa_ct
pacy115328683_pa_cy
pah88853593_pa__h
painch133511323_painch
par57467023_par__
para65242173_par_a
parae76335703_parae
paraph13311263_paraph
paras76143043_paras
parcel103915473_parcel
parched154013693_parched
parches143720003_parches
pard76441323_par_d
pardah123412823_pardah
pardi85723953_pardi
pards85634333_pards
pardy115523953_pardy
pare66760843_par_e
pared86946763_pared
pareo74632603_pareo
parer75839903_parer
pares77164483_pares
pareu74928743_pareu
parge85831853_parge
pargo86723723_pargo
pariah114320583_pariah
paris75145943_paris
parish115022353_parish
park105237493_par_k
parka115120883_parka
parks116134463_parks
parle75836163_parle
parol74826273_parol
parr65731153_par_r
parrs75928673_parrs
parry105323753_parry
pars67560793_par_s
parse75236993_parse
part65967463_par_t
parts77743373_parts
party106630613_party
parve109824853_parve
parvo107719183_parvo
pash95638133_pa_sh
patchy16509573_patchy
path99134913_pa_th
paunch13369853_paunch
peace95026083pea_ce
peachy164510843pea_chy
pear69745233pear__
pearl75324463pear_l
pearls84715383pearls
pearly116414843pearly
pears75138613pear_s
peart76440753pear_t
pech116125453_p_ech
pentarch1544943pentarch
pinch125619303_pinch
pitch125018413_pitch
planch133711443planch
poach124917863_poach
pooch124815303_pooch
pouch124617083_pouch
psych1554963_psych
punch125118423_punch
quaich2047693quaich
ranch105019793_ranch
ratch104221363_ratch
reach105123883rea_ch
rematch1436193rematch
repack142412163repa_ck
repark123511713repar_k
reparks13249513reparks
research1344553research
roach105717003roa_ch
sauch104918773_sauch
scarce104013633scarce
scarph13429603scarph
scorch13198093scorch
slatch114510533slatch
smirch1356463smirch
snatch114310603snatch
space95325673spa_ce
spacy125415623spa_cy
spar65433303spar__
spare75135563spar_e
spared95427483spared
sparer84524963sparer
spares84834553spares
sparge94216043sparge
sparid94016933sparid
spark114920893spar_k
sparks124616363sparks
sparky154511523sparky
sparry115111303sparry
spars75431543spar_s
sparse84516343sparse
speech1347563speech
stanch113812373stanch
starchy15286743starchy
swarth126012083swarth
swatch14549283swatch
tach96132753_ta_ch
teach105221123tea_ch
tetrarch13104783tetrarch
thatch1435603thatch
torch107420933_torch
watch135617063_watch

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.1231452772.4
2DLD Change Limit1127162425.43620735.1
3Display Results2422420.0932602.2
 (SQL Overall)1786912425.65231615.5
 
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.