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

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

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.

56 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
flycatchers	24	5	94	(None)
flycatcher	23	5	107	1	flycatcher_
bycatches	21	4	268	3	_bycatche_s
catchers	15	31	1406	3	___catchers
cowcatchers	20	5	156	3	cowcatchers
dogcatchers	20	5	160	3	dogcatchers
fletchers	17	33	553	3	fl__etchers
batchers	15	36	1327	4	___batchers
blanchers	16	30	743	4	bl__anchers
blathers	13	47	1379	4	bl__at_hers
bleachers	16	29	792	4	bl_ea_chers
catcher	14	31	1582	4	___catcher_
catches	14	43	2077	4	___catche_s
cowcatcher	19	5	172	4	cowcatcher_
dispatchers	19	7	246	4	dispatchers
dogcatcher	19	5	201	4	dogcatcher_
fathers	13	39	1650	4	f___at_hers
feathers	14	35	1324	4	f__eat_hers
fetchers	16	32	886	4	f___etchers
flashers	14	39	1265	4	fl__a_shers
flatcars	13	4	462	4	fl__atc_ars
flatters	11	38	1420	4	fl__at_ters
fletcher	16	30	666	4	fl__etcher_
fletches	16	30	885	4	fl__etche_s
flichters	17	7	417	4	flicht__ers
flinchers	17	29	547	4	fl__inchers
flitches	16	38	846	4	fl__itche_s
floaters	11	27	1151	4	fl_oat__ers
flypapers	19	4	203	4	flypa__pers
flysches	19	3	312	4	fly__sche_s
flyswatters	20	5	90	4	flyswat_ters
flytiers	14	25	448	4	fly__t_iers
forgathers	17	4	355	4	forgat_hers
gnatcatchers	20	6	65	4	gnatcatchers
hatchers	16	31	1317	4	___hatchers
klatches	17	15	714	4	kl__atche_s
latches	12	33	2013	4	_l__atche_s
latchets	13	34	1001	4	_l__atchets
lathers	10	43	2188	4	_l__at_hers
leachers	13	37	1281	4	_l_ea_chers
leathers	11	42	1508	4	_l_eat_hers
loathers	11	33	1044	4	_l_oat_hers
locaters	10	27	1007	4	_locat__ers
lynchers	16	28	545	4	_ly__nchers
matchers	15	30	1243	4	___matchers
outcatches	17	4	378	4	outcatche_s
patchers	15	34	1330	4	___patchers
placaters	13	3	647	4	placat__ers
pleathers	14	4	645	4	pl_eat_hers
scratchers	17	4	429	4	_scratchers
scutchers	16	17	564	4	__scutchers
slatches	13	15	1153	4	sl__atche_s
slathers	11	39	1478	4	sl__at_hers
snatchers	14	14	631	4	__snatchers
thatchers	17	4	458	4	__thatchers
watchers	16	35	1179	4	___watchers

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	148819	0.423	422437.4
2	DLD Change Limit	148819	56	8.220	18104.5
3	Display Results	56	56	0.013	4307.7
	(SQL Overall)	178691	56	8.656	20643.6