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

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

45 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
bycatch	19	4	206	(None)
batch	12	46	2010	2	b__atch
bycatches	21	4	268	2	bycatches
bypath	16	4	535	2	bypat_h
catch	12	51	2037	2	__catch
bach	11	61	3139	3	b__a_ch
bath	9	59	4008	3	b__at_h
beach	12	46	2389	3	b_ea_ch
bewitch	17	4	332	3	bewitch
bitch	12	50	1776	3	b__itch
blanch	13	34	1085	3	b_lanch
bleach	13	36	1140	3	blea_ch
blotch	13	19	714	3	b_lotch
botch	12	67	1745	3	b__otch
brach	12	61	2330	3	b_ra_ch
branch	13	40	1478	3	b_ranch
breach	13	42	1372	3	brea_ch
breath	11	39	1626	3	breat_h
broach	13	36	1111	3	broa_ch
butch	12	54	1654	3	b__utch
bypaths	17	4	319	3	bypaths
catchy	16	55	958	3	__catchy
cratch	13	41	1079	3	_cratch
cutch	12	51	1619	3	__cutch
hatch	13	57	1959	3	__hatch
klatch	15	44	593	3	_klatch
latch	10	46	2046	3	__latch
match	12	56	2110	3	__match
natch	10	50	1822	3	__natch
outcatch	15	4	429	3	outcatch
patch	12	52	2122	3	__patch
ratch	10	42	2136	3	__ratch
rematch	14	3	619	3	rematch
repatch	14	3	584	3	repatch
scotch	13	20	752	3	_scotch
scratch	14	4	601	3	scratch
scutch	13	24	708	3	_scutch
seecatch	15	4	269	3	seecatch
slatch	11	45	1053	3	_slatch
snatch	11	43	1060	3	_snatch
swatch	14	54	928	3	_swatch
thatch	14	3	561	3	_thatch
uncatchy	18	4	256	3	uncatchy
unlatch	12	4	505	3	unlatch
watch	13	56	1706	3	__watch

Search took 8 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.420	425454.8
2	DLD Change Limit	134027	45	6.736	19897.1
3	Display Results	45	45	0.013	3461.5
	(SQL Overall)	178691	45	7.169	24925.5