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

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

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.

66 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
branches	15	36	1380	(None)
blanches	15	33	1160	1	blanches
braches	14	46	2122	1	bra_ches
branched	16	32	1045	1	branched
brunches	15	37	1045	1	brunches
cranches	15	31	1454	1	cranches
ranches	12	36	2011	1	_ranches
tranches	13	29	1551	1	tranches
baches	13	54	2694	2	b_a_ches
batches	14	40	1961	2	b_atches
beaches	14	41	2065	2	bea_ches
benches	14	39	1860	2	b_enches
blanched	16	30	860	2	blanched
blancher	15	33	863	2	blancher
blanchers	16	30	743	2	blanchers
blenches	15	33	1076	2	blenches
braces	10	84	2777	2	bra_c_es
brachet	14	40	2031	2	bra_chet
brachets	15	43	1198	2	bra_chets
brachs	13	44	1575	2	bra_ch_s
branch	13	40	1478	2	branch__
branchia	15	21	771	2	branchia
branchier	16	3	713	2	branchier
branchiest	17	4	671	2	branchiest
branchless	17	4	330	2	branchless
branchlet	16	4	718	2	branchlet
branchlets	17	4	380	2	branchlets
branchy	17	35	791	2	branch_y
brandies	11	7	1456	2	brandies
brashes	12	45	1846	2	bra_shes
breaches	15	37	1412	2	breaches
breeches	15	25	867	2	breeches
brioches	15	22	725	2	brioches
britches	15	27	868	2	britches
broaches	15	32	1162	2	broaches
bronchos	15	20	617	2	bronchos
bronchus	15	20	474	2	bronchus
brooches	15	28	819	2	brooches
brunched	16	31	785	2	brunched
bruncher	15	34	778	2	bruncher
brunchers	16	29	625	2	brunchers
bunches	14	41	1603	2	b_unches
cranched	16	32	1041	2	cranched
cratches	15	30	1254	2	cratches
craunches	16	5	572	2	craunches
crunches	15	37	1135	2	crunches
drenches	14	30	980	2	drenches
frenches	16	33	1163	2	frenches
grinches	14	3	695	2	grinches
manches	14	38	1862	2	_manches
oraches	12	42	1647	2	ora_ches
planches	15	31	1186	2	planches
prances	11	36	1878	2	pranc_es
rances	8	46	2544	2	_ranc_es
ranched	13	31	1360	2	_ranched
rancher	12	30	1363	2	_rancher
ranchers	13	33	1179	2	_ranchers
ranchos	12	39	1139	2	_ranchos
ratches	12	36	2046	2	_ratches
raunches	13	6	805	2	_raunches
rebranches	17	4	519	2	rebranches
stanches	13	23	1279	2	stanches
trances	9	39	1964	2	tranc_es
tranche	12	33	1222	2	tranche_
trenches	13	35	1260	2	trenches
wrenches	16	32	1023	2	wrenches

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	66	3.860	31362.4
3	Display Results	66	66	0.033	2000.0
	(SQL Overall)	178691	66	4.283	41721.0