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

Here are the results of your fuzzy-string dictionary search for “berdaches” 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.

73 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
berdaches	17	4	505	(None)
berdache	16	4	403	1	berdache_
beaches	14	41	2065	2	be__aches
braches	14	46	2122	2	b_r_aches
breaches	15	37	1412	2	b_reaches
broaches	15	32	1162	2	b_roaches
headaches	18	4	503	2	headaches
baches	13	54	2694	3	b___aches
backaches	22	14	681	3	backaches
barnacles	13	5	533	3	barnacles
barouches	16	4	497	3	barouches
beached	15	45	1655	3	be__ached
bedrapes	13	8	696	3	bedra_pes
bedrenches	18	4	345	3	bedrenches
beeches	14	34	1388	3	be__eches
belches	14	35	1434	3	be__lches
beldames	13	3	680	3	belda_mes
bellyaches	20	5	204	3	bellyaches
benches	14	39	1860	3	be__nches
berakes	13	48	1577	3	ber_a_kes
berates	9	41	2687	3	ber_a_tes
bereaves	13	3	827	3	berea_ves
bernicles	13	4	540	3	bernicles
beseeches	16	4	395	3	beseeches
bewitches	19	4	382	3	bewitches
birches	14	34	1232	3	bir__ches
birdcages	15	4	338	3	birdcages
birdwatches	22	8	101	3	birdwatches
bleaches	15	34	1067	3	b_leaches
boraces	11	37	1685	3	bor_ac_es
borsches	15	3	600	3	bor_sches
braces	10	84	2777	3	b_r_ac_es
brachet	14	40	2031	3	b_r_achet
brachets	15	43	1198	3	b_r_achets
brachs	13	44	1575	3	b_r_ach_s
branches	15	36	1380	3	b_ranches
brashes	12	45	1846	3	b_r_ashes
breached	16	34	1164	3	b_reached
breacher	15	30	1150	3	b_reacher
breachers	16	36	985	3	b_reachers
breathes	13	42	1290	3	b_reathes
breeches	15	25	867	3	b_reeches
brioches	15	22	725	3	b_rioches
britches	15	27	868	3	b_ritches
broached	16	30	912	3	b_roached
broacher	15	32	926	3	b_roacher
broachers	16	32	815	3	b_roachers
brooches	15	28	819	3	b_rooches
brunches	15	37	1045	3	b_runches
caroaches	16	3	779	3	caroaches
detaches	14	3	965	3	de_taches
earaches	13	4	1130	3	_earaches
emdashes	14	22	430	3	_emdashes
endashes	12	21	745	3	_endashes
headache	17	4	470	3	headache_
headachey	21	4	255	3	headachey
heartaches	18	4	404	3	heartaches
leaches	12	33	1934	3	le__aches
merches	14	40	1376	3	mer__ches
oraches	12	42	1647	3	_or_aches
peaches	14	41	2005	3	pe__aches
perches	14	37	1795	3	per__ches
preaches	15	32	1489	3	_preaches
reaches	12	34	2320	3	__reaches
reproaches	17	5	543	3	reproaches
reteaches	14	3	712	3	reteaches
roaches	12	36	1621	3	__roaches
teaches	12	27	1835	3	te__aches
terraces	10	27	1225	3	terrac_es
upreaches	16	5	463	3	upreaches
vendaces	14	5	718	3	vendac_es
verdancies	16	4	523	3	verdancies
vernacles	14	4	507	3	vernacles

Search took 9 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	148641	0.453	394461.4
2	DLD Change Limit	148641	73	7.750	19179.5
3	Display Results	73	73	0.030	2433.3
	(SQL Overall)	178691	73	8.233	21704.2