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

155 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
exarch1819617(None) 
eparch13258421eparch
exarchs19165191exarchs
exarchy22193691exarchy
anarch11310392anarch
arch98628442__arch
each95530582e_a_ch
earth85023052e_arth
endarch1345442endarch
eparchs14196242eparchs
eparchy17204752eparchy
exact143516932exa_ct
exarchal2043722exarchal
hexarchy2642872hexarchy
inarch1139172inarch
larch105919792_larch
march125622892_march
mesarch1445532mesarch
parch125123002_parch
search113312422search
starch113013202starch
xerarch1943842xerarch
aargh96314083_aargh
anarchs1237093anarchs
anarchy1544933anarchy
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
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
epact94921533epa_ct
epoch1248203e_poch
etch95419143e__tch
ethnarch1642413ethnarch
eunuch1154363eunuch
exacta15337393exacta
exacts15359613exacts
exalt123018533exa_lt
exalts13328313exalts
exam132514623exa__m
examen1538283examen
exams14199083exa_ms
exarchate2144453exarchate
exarchies2145213exarchies
exec135313943ex_ec_
execs14539723ex_ecs
exert124624143exer_t
exerts133712293exerts
expect1758903expect
exsect1558503exsect
extra1239003extr_a
extract16311013extract
extras13310223extras
exurb1457703exur_b
exurbs1534423exurbs
farce104925323_farce
farci105919313_farci
farcy135217093_farcy
garth94720223_garth
harsh116418053_harsh
hatch135719593_hatch
hearth125315213hearth
heptarch1843563heptarch
hierarch1644043hierarch
klatch15445933klatch
laich105920713_laich
latch104620463_latch
leach105422523lea_ch
loach105116363loa_ch
lurch104814633_lurch
mach116134483_ma_ch
marc87034633_marc_
marcs95726623_marcs
marsh105320853_marsh
match125621103_match
menarche1545813menarche
merch125417963_merch
monarch1445953monarch
narc67127953_narc_
narco76718243_narco
narcs76122023_narcs
natch105018223_natch
nomarch1445353nomarch
orach105219233ora_ch
overarch1647243overarch
patch125221223_patch
peach125422493pea_ch
pentarch1544943pentarch
perch124518833_perch
planch133711443planch
poach124917863poa_ch
porch125918623_porch
quaich2047693quaich
ranch105019793_ranch
ratch104221363_ratch
reach105123883rea_ch
rematch1436193rematch
repatch1435843repatch
research1344553research
roach105717003roa_ch
sauch104918773_sauch
scarce104013633scarce
scarph13429603scarph
scorch13198093scorch
slatch114510533slatch
smirch1356463smirch
snatch114310603snatch
stanch113812373stanch
starchy15286743starchy
swarth126012083swarth
swatch14549283swatch
tach96132753_ta_ch
teach105221123tea_ch
tetrarch13104783tetrarch
thatch1435613thatch
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.390458182.1
2DLD Change Limit1127161555.48320557.4
3Display Results1551550.0463369.6
 (SQL Overall)1786911555.91930189.4
 
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.