Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “xerarch” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

71 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 Word	Scrabble Score	Searched Previously	Found Previously	Changes	To Transform to your Word
xerarch	19	4	384	(None)
eparch	13	25	842	2	_eparch
exarch	18	19	617	2	_exarch
hierarch	16	4	404	2	hierarch
mesarch	14	4	553	2	mesarch
overarch	16	4	724	2	overarch
search	11	33	1242	2	se_arch
tetrarch	13	10	478	2	tetrarch
anarch	11	3	1039	3	_anarch
arch	9	86	2844	3	___arch
autarch	12	4	662	3	autarch
beach	12	46	2389	3	be_a_ch
brach	12	61	2330	3	_bra_ch
branch	13	40	1477	3	_branch
breach	13	42	1372	3	brea_ch
cranch	13	36	1353	3	_cranch
cratch	13	41	1079	3	_cratch
currach	14	4	645	3	currach
dearth	10	42	1251	3	de_arth
debauch	15	13	442	3	debauch
demarche	16	4	553	3	demarche
detach	12	3	1041	3	deta_ch
each	9	55	3058	3	_e_a_ch
earth	8	50	2305	3	_e_arth
endarch	13	4	544	3	endarch
eparchs	14	19	624	3	_eparchs
eparchy	17	20	475	3	_eparchy
exarchs	19	16	519	3	_exarchs
exarchy	22	19	369	3	_exarchy
gerah	9	3	1530	3	gera__h
hearth	12	53	1521	3	he_arth
heptarch	18	4	356	3	heptarch
hexarchy	26	4	287	3	hexarchy
hierarchs	17	4	342	3	hierarchs
hierarchy	20	5	273	3	hierarchy
inarch	11	3	917	3	_inarch
interarch	14	4	671	3	interarch
larch	10	59	1979	3	__larch
leach	10	54	2252	3	le_a_ch
march	12	56	2289	3	__march
menarche	15	4	581	3	menarche
merch	12	54	1796	3	me__rch
monarch	14	4	595	3	monarch
nomarch	14	4	535	3	nomarch
orach	10	52	1923	3	_ora_ch
parch	12	51	2300	3	__parch
peach	12	54	2249	3	pe_a_ch
pentarch	15	4	494	3	pentarch
perch	12	45	1883	3	pe__rch
preach	13	36	1392	3	prea_ch
ranch	10	50	1979	3	__ranch
ratch	10	42	2136	3	__ratch
reach	10	51	2388	3	re_a_ch
rebranch	15	4	580	3	rebranch
rematch	14	3	619	3	rematch
repatch	14	3	584	3	repatch
rerack	12	25	1316	3	rera_ck
research	13	4	455	3	research
scraich	14	3	676	3	scraich
scratch	14	4	601	3	scratch
serac	7	59	2520	3	sera_c_
seracs	8	44	1857	3	sera_cs
seraph	11	40	1116	3	sera_ph
starch	11	30	1320	3	_starch
teach	10	52	2112	3	te_a_ch
teraph	11	31	909	3	tera_ph
terrace	9	33	1184	3	terrace
tetrarchs	14	10	430	3	tetrarchs
tetrarchy	17	10	333	3	tetrarchy
trierarch	14	5	270	3	trierarch
xeric	14	43	1566	3	xer_ic_

Search took 7 seconds overall (including website activity, plus SQL activity in the following phases):

Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
Display Results: Return the results, with similar words marked up to highlight differences.

Seq	Search Phase	Words Checked	Words Matched	Seconds	Words Per Sec
1	Length Filter	178691	134027	0.406	440125.6
2	DLD Change Limit	134027	71	6.500	20619.5
3	Display Results	71	71	0.016	4437.5
	(SQL Overall)	178691	71	6.922	25814.9