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

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

78 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
befleck	18	4	394	(None)
beflecks	19	4	375	1	beflecks
bedeck	15	3	621	2	be_deck
beflea	11	4	712	2	befle_a
befleas	12	3	697	2	befleas
beflecked	21	4	265	2	beflecked
belleek	13	4	724	2	belleek
deflect	13	39	997	2	deflect
fleck	14	82	1359	2	__fleck
reflect	12	39	1371	2	reflect
beck	12	62	2657	3	b___eck
becloak	15	4	504	3	becloak
bedecks	16	3	579	3	be_decks
bedless	10	3	970	3	bedless
bedrock	16	4	564	3	bedrock
bedtick	16	4	523	3	bedtick
beech	12	43	1550	3	be__ech
beefless	13	3	549	3	beefless
befell	11	42	871	3	bef_ell
beflag	12	6	588	3	befl_ag
beflags	13	5	549	3	beflags
befleaed	14	5	466	3	befleaed
beflecking	22	4	303	3	befleck~~ing~~
befret	11	3	1596	3	befre_t
befrets	12	3	761	3	befrets
belch	12	44	1550	3	be_l_ch
beleap	10	4	1028	3	be_leap
belle	7	58	2783	3	belle__
belled	9	46	2619	3	belle_d
belleeks	14	4	436	3	belleeks
belles	8	53	2599	3	belle_s
bemock	16	3	617	3	be_mock
berserk	13	3	491	3	berserk
beseech	14	5	387	3	beseech
bespeak	15	4	457	3	bespeak
beylic	13	3	782	3	beylic_
beylics	14	3	618	3	beylics
beylik	15	4	588	3	beyl_ik
biflex	18	3	495	3	bifle_x
black	13	47	1907	3	b__lack
bleak	11	59	1538	3	b__leak
block	13	49	1784	3	b__lock
bullneck	16	4	293	3	bullneck
bullock	15	3	719	3	bullock
burlesk	13	3	546	3	burlesk
defect	12	48	1617	3	def_ect
deflea	10	3	744	3	defle_a
defleas	11	4	722	3	defleas
deflects	14	33	673	3	deflects
defrock	17	4	464	3	defrock
effect	14	3	744	3	_effect
elect	7	43	2703	3	_e_lect
elflock	16	4	297	3	elflock
feck	13	49	2343	3	__f_eck
fetlock	16	4	532	3	fetlock
flack	14	45	1941	3	__flack
flecks	15	43	1080	3	__flecks
flecky	18	38	765	3	__flecky
flick	14	50	1721	3	__flick
flock	14	47	1742	3	__flock
hemlock	18	4	563	3	hemlock
henpeck	18	4	308	3	henpeck
inflect	12	4	922	3	inflect
neglect	10	4	736	3	neglect
rebeck	14	41	991	3	re_beck
recheck	18	3	561	3	recheck
redneck	14	4	511	3	redneck
reelect	9	115	1563	3	reelect
refect	11	43	1933	3	ref_ect
reflects	13	28	887	3	reflects
reflet	9	40	2423	3	refle_t
reflets	10	35	1315	3	reflets
reflew	12	38	945	3	refle_w
reflex	16	35	951	3	refle_x
relock	12	47	1352	3	re_lock
select	8	26	2117	3	se_lect
wedlock	17	4	455	3	wedlock
zebeck	23	25	520	3	ze_beck

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.406	440125.6
2	DLD Change Limit	134027	78	7.453	17983.0
3	Display Results	78	78	0.030	2600.0
	(SQL Overall)	178691	78	7.889	22650.7