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

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

22 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
branchy	17	35	791	(None)
branch	13	40	1477	1	branch_
beachy	16	40	1125	2	bea_chy
blanch	13	34	1085	2	blanch_
brach	12	61	2330	2	bra_ch_
brachs	13	44	1575	2	bra_chs
branched	16	32	1045	2	branched
branches	15	36	1380	2	branches
branchia	15	21	771	2	branchia
brandy	12	47	1206	2	bran_dy
branny	11	51	1183	2	bran_ny
brashy	14	52	1059	2	bra_shy
bronchi	14	17	631	2	bronchi
broncho	14	20	646	2	broncho
brunch	13	32	935	2	brunch_
bunchy	16	43	746	2	b_unchy
cranch	13	36	1353	2	cranch_
crunchy	17	32	476	2	crunchy
ranch	10	50	1979	2	_ranch_
rancho	11	43	1085	2	_rancho
raunchy	15	28	431	2	_raunchy
tranche	12	33	1222	2	tranche

Search took 4 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	22	3.626	29694.2
3	Display Results	22	22	0.013	1692.3
	(SQL Overall)	178691	22	3.779	47285.3