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

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

73 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
flecks	15	43	1080	(None)
fecks	14	54	1785	1	f_ecks
flacks	15	41	1453	1	flacks
fleck	14	82	1359	1	fleck_
flecky	18	38	765	1	flecky
flicks	15	45	1299	1	flicks
flocks	15	47	1353	1	flocks
alecs	7	66	2073	2	alec_s
becks	13	55	2201	2	_becks
beflecks	19	4	375	2	beflecks
blacks	14	49	1495	2	blacks
bleaks	12	51	1243	2	bleaks
blocks	14	45	1394	2	blocks
checks	17	49	1270	2	checks
clacks	14	45	1634	2	clacks
cleeks	12	50	1054	2	cleeks
clerks	12	45	884	2	clerks
clicks	14	53	1511	2	clicks
clocks	14	49	1623	2	clocks
clucks	14	45	1207	2	clucks
decks	12	48	2219	2	_decks
drecks	13	45	920	2	drecks
elects	8	33	1500	2	elects
faeces	11	47	1312	2	faeces
feces	10	56	2536	2	f_eces
feck	13	49	2343	2	f_eck_
flack	14	45	1941	2	flack_
flanks	13	39	1340	2	flanks
flasks	13	48	867	2	flasks
fleams	11	50	1194	2	fleams
fleas	8	64	2366	2	fle_as
fleche	14	29	930	2	fleche
fleches	15	34	1144	2	fleches
flecked	17	35	807	2	flecked
fleeces	12	39	964	2	fleeces
fleers	9	60	1579	2	fleers
flees	8	58	2875	2	fle_es
fleets	9	69	1506	2	fleets
flews	11	53	1644	2	fle_ws
flexes	16	45	1295	2	flexes
fleys	11	70	1560	2	fle_ys
flick	14	50	1721	2	flick_
flics	10	54	1836	2	flic_s
flock	14	47	1742	2	flock_
flocky	18	46	842	2	flocky
flocs	10	55	1923	2	floc_s
flunks	13	46	986	2	flunks
freaks	13	47	1306	2	freaks
frocks	15	41	1121	2	frocks
fucks	14	44	1925	2	f_ucks
gecks	12	51	1709	2	_gecks
gleeks	11	48	967	2	gleeks
hecks	14	52	2065	2	_hecks
kecks	10	54	1657	2	_kecks
klicks	11	46	872	2	klicks
lacks	11	61	2920	2	_lacks
leaks	9	59	2391	2	_leaks
leeks	9	53	1889	2	_leeks
leks	8	54	2760	2	_le_ks
licks	11	53	2539	2	_licks
locks	11	51	2692	2	_locks
lucks	11	57	2356	2	_lucks
necks	11	51	1933	2	_necks
pecks	13	57	2443	2	_pecks
placks	14	44	1415	2	placks
plucks	14	37	973	2	plucks
recks	11	56	2513	2	_recks
slacks	12	44	1653	2	slacks
sleeks	10	45	1246	2	sleeks
slicks	12	48	1611	2	slicks
snecks	12	44	1003	2	snecks
specks	14	43	1270	2	specks
wrecks	15	41	888	2	wrecks

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	82551	0.953	187503.7
2	DLD Change Limit	82551	73	6.873	12010.9
3	Display Results	73	73	0.063	1158.7
	(SQL Overall)	178691	73	7.889	22650.7