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

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

86 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
fleck	14	82	1359	(None)
feck	13	49	2343	1	f_eck
flack	14	45	1941	1	flack
flecks	15	43	1080	1	flecks
flecky	18	38	765	1	flecky
flick	14	50	1721	1	flick
flock	14	47	1742	1	flock
alack	11	48	2006	2	alack
alec	6	64	3006	2	alec_
alecs	7	66	2073	2	alecs
beck	12	62	2657	2	_beck
befleck	18	4	394	2	befleck
black	13	47	1907	2	black
bleak	11	59	1538	2	bleak
block	13	49	1784	2	block
check	16	47	1471	2	check
clack	13	47	2017	2	clack
cleek	11	55	1491	2	cleek
clerk	11	58	1245	2	clerk
click	13	52	1795	2	click
clock	13	49	1798	2	clock
cluck	13	49	1489	2	cluck
deck	11	58	2775	2	_deck
dreck	12	48	1280	2	dreck
elect	7	43	2703	2	elect
fecks	14	54	1785	2	f_ecks
flacks	15	41	1453	2	flacks
flak	11	60	2617	2	fl_ak
flank	12	46	1809	2	flank
flask	12	55	1242	2	flask
flea	7	56	2849	2	fle_a
fleam	10	60	1728	2	fleam
fleas	8	64	2366	2	fleas
fleche	14	29	930	2	fleche
flecked	17	35	807	2	flecked
fled	8	54	2977	2	fle_d
flee	7	62	3879	2	fle_e
fleece	11	36	990	2	fleece
fleech	14	36	734	2	fleech
fleecy	14	26	648	2	fleecy
fleer	8	60	2077	2	fleer
flees	8	58	2875	2	flees
fleet	8	59	3233	2	fleet
flench	14	40	1081	2	flench
flesh	11	50	1374	2	flesh
fletch	14	38	819	2	fletch
flew	10	58	2425	2	fle_w
flews	11	53	1644	2	flews
flex	14	61	2347	2	fle_x
fley	10	66	2685	2	fle_y
fleys	11	70	1560	2	fleys
flic	9	62	2373	2	flic_
flicks	15	45	1299	2	flicks
flics	10	54	1836	2	flics
floc	9	59	2212	2	floc_
flocks	15	47	1353	2	flocks
flocky	18	46	842	2	flocky
flocs	10	55	1923	2	flocs
flunk	12	50	1438	2	flunk
freak	12	51	1524	2	freak
frock	14	53	1465	2	frock
fuck	13	49	2463	2	f_uck
geck	11	57	2199	2	_geck
gleek	10	53	1510	2	gleek
heck	13	58	2649	2	_heck
keck	9	49	2071	2	_keck
klick	10	53	1143	2	klick
lack	10	58	3768	2	_lack
leak	8	62	3371	2	_leak
lech	9	68	2544	2	_lech
leek	8	53	3173	2	_leek
lek	7	56	4030	2	_le_k
lick	10	69	3507	2	_lick
lock	10	61	3436	2	_lock
luck	10	53	2982	2	_luck
neck	10	54	2366	2	_neck
peck	12	57	3068	2	_peck
plack	13	50	1784	2	plack
pluck	13	42	1230	2	pluck
reck	10	61	3056	2	_reck
slack	11	50	2176	2	slack
sleek	9	46	1904	2	sleek
slick	11	55	2052	2	slick
sneck	11	47	1366	2	sneck
speck	13	51	1565	2	speck
wreck	14	46	1104	2	wreck

Search took 2 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	53800	0.313	570897.8
2	DLD Change Limit	53800	86	1.513	35558.5
3	Display Results	86	86	0.016	5375.0
	(SQL Overall)	178691	86	1.842	97009.2