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

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

64 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
barnacles	13	5	533	(None)
barnacle	12	4	594	1	barnacle_
barnacled	14	4	400	1	barnacled
bernicles	13	4	540	2	bernicles
binnacles	13	24	458	2	binnacles
burnables	13	4	400	2	burnables
manacles	12	3	952	2	ma_nacles
vernacles	14	4	507	2	vernacles
arables	9	18	1498	3	_ar_ables
articles	10	3	1025	3	_articles
backaches	22	14	681	3	backaches
balances	12	7	997	3	balanc_es
bangles	10	36	1741	3	ba_n_gles
bannable	12	7	835	3	bannable_
barbascoes	16	4	252	3	barbascoes
barbecues	15	14	447	3	barbecues
barbicels	15	11	351	3	barbicels
barbules	12	3	804	3	bar_bules
barcaroles	14	4	380	3	barcaroles
baronages	12	4	715	3	barona_ges
barouches	16	4	497	3	barouches
barrable	12	4	925	3	barrable_
barracked	18	4	475	3	barracked
barracker	17	4	465	3	barracker
barrackers	18	4	376	3	barrackers
barracks	16	3	688	3	barrac_ks
barrages	11	7	1109	3	barra_ges
barwares	13	6	1009	3	barwa_res
berdaches	17	4	505	3	berdaches
bernicle	12	4	544	3	bernicle_
binnacle	12	32	563	3	binnacle_
binocles	12	3	641	3	b_inocles
boraces	11	37	1685	3	bor_ac_es
braces	10	84	2777	3	b_r_ac_es
braches	14	46	2122	3	b_r_aches
branches	15	36	1380	3	bran_ches
breaches	15	37	1412	3	b_reaches
broaches	15	32	1162	3	b_roaches
burnable	12	3	726	3	burnable_
caracoles	13	3	1009	3	car_acoles
carnages	11	3	1221	3	carna_ges
caroaches	16	3	779	3	caroaches
caruncles	13	4	501	3	caruncles
cenacles	12	3	802	3	_cenacles
coracles	12	18	1116	3	cor_acles
cornicles	13	6	825	3	cornicles
earaches	13	4	1131	3	ear_aches
furnaces	13	3	605	3	furnac_es
ganaches	14	3	743	3	ga_naches
manacle	11	3	1028	3	ma_nacle_
manacled	13	3	645	3	ma_nacled
miracles	12	3	833	3	mir_acles
oracles	9	32	1242	3	_or_acles
panaches	15	3	1029	3	pa_naches
panicles	12	10	1012	3	pa_nicles
parables	12	16	1357	3	par_ables
particles	13	3	981	3	particles
pinnacles	13	27	604	3	pinnacles
sanicles	10	14	994	3	sa_nicles
tabernacles	15	5	201	3	tabernacles
treacles	10	3	970	3	_treacles
variables	14	4	468	3	variables
vernacle	13	4	558	3	vernacle_
vernicles	14	4	613	3	vernicles

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.436	409841.7
2	DLD Change Limit	148641	64	8.160	18215.8
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.626	20715.4