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

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

100 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
flock	14	47	1742	(None)
block	13	49	1784	1	block
clock	13	49	1798	1	clock
flack	14	45	1941	1	flack
fleck	14	82	1359	1	fleck
flick	14	50	1721	1	flick
floc	9	59	2212	1	floc_
flocks	15	47	1353	1	flocks
flocky	18	46	842	1	flocky
flocs	10	55	1923	1	flocs
frock	14	53	1465	1	frock
lock	10	61	3436	1	_lock
acock	13	21	1021	2	acock
alack	11	48	2006	2	alack
black	13	47	1907	2	black
bloc	8	50	2327	2	bloc_
blocks	14	45	1394	2	blocks
blocky	17	38	835	2	blocky
blocs	9	52	1965	2	blocs
bock	12	60	3251	2	_bock
brock	13	60	1707	2	brock
chock	16	43	1661	2	chock
clack	13	47	2017	2	clack
click	13	52	1795	2	click
cloak	11	52	1401	2	cloak
clocks	14	49	1623	2	clocks
clonk	11	44	1744	2	clonk
cluck	13	49	1489	2	cluck
cock	12	63	3290	2	_cock
crock	13	59	2199	2	crock
dock	11	62	2874	2	_dock
elflock	16	4	297	2	elflock
feck	13	49	2343	2	f_eck
fetlock	16	4	532	2	fetlock
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
flecks	15	43	1080	2	flecks
flecky	18	38	765	2	flecky
flic	9	62	2373	2	flic_
flicks	15	45	1299	2	flicks
flics	10	54	1836	2	flics
float	8	59	2857	2	float
flocci	13	3	502	2	flocci
flocked	17	45	1025	2	flocked
floe	7	61	2977	2	flo_e
floes	8	55	2814	2	floes
flog	8	55	2389	2	flo_g
flogs	9	59	1996	2	flogs
flong	9	58	1568	2	flong
flood	9	52	1560	2	flood
floor	8	42	1523	2	floor
flop	9	69	2545	2	flo_p
flops	10	59	2014	2	flops
flora	8	53	1710	2	flora
floss	8	51	1826	2	floss
flota	8	53	1564	2	flota
flour	8	49	1645	2	flour
flout	8	62	2620	2	flout
flow	10	59	2492	2	flo_w
flown	11	62	1399	2	flown
flows	11	58	2236	2	flows
flunk	12	50	1438	2	flunk
foci	9	45	2101	2	f_oci
folk	11	60	2154	2	f_olk
fork	11	59	3094	2	f_ork
frocks	15	41	1121	2	frocks
fuck	13	49	2463	2	f_uck
hock	13	60	3130	2	_hock
jock	17	65	2264	2	_jock
klick	10	53	1144	2	klick
knock	10	48	796	2	knock
lack	10	58	3768	2	_lack
lick	10	69	3508	2	_lick
loca	6	55	2768	2	_loca
loch	9	55	2713	2	_loch
loci	6	61	2628	2	_loci
locks	11	51	2692	2	_locks
loco	6	70	3074	2	_loco
look	8	73	3347	2	_look
luck	10	53	2982	2	_luck
mock	12	64	2944	2	_mock
nock	10	61	2718	2	_nock
plack	13	50	1784	2	plack
plonk	11	46	1398	2	plonk
pluck	13	42	1230	2	pluck
pock	12	61	2929	2	_pock
relock	12	47	1352	2	relock
rock	10	57	3518	2	_rock
shlock	15	37	819	2	shlock
shock	14	49	1703	2	shock
slack	11	50	2176	2	slack
slick	11	55	2052	2	slick
smock	13	53	1167	2	smock
sock	10	52	3321	2	_sock
stock	11	44	1756	2	stock
trock	11	48	1760	2	trock
unlock	12	4	853	2	unlock
yock	13	59	2461	2	_yock

Search took 3 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	100	1.656	32487.9
3	Display Results	100	100	0.030	3333.3
	(SQL Overall)	178691	100	1.999	89390.2