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

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

61 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
knock	10	48	796	(None)
knack	10	43	1104	1	knack
knocks	11	39	744	1	knocks
nock	10	61	2718	1	_nock
acock	13	21	1021	2	acock
block	13	49	1784	2	block
bock	12	60	3251	2	_bock
brock	13	60	1707	2	brock
chock	16	43	1661	2	chock
clock	13	49	1798	2	clock
cock	12	63	3290	2	_cock
crock	13	59	2199	2	crock
dock	11	62	2874	2	_dock
flock	14	47	1742	2	flock
frock	14	53	1465	2	frock
hock	13	60	3130	2	_hock
jock	17	65	2264	2	_jock
keck	9	49	2071	2	k_eck
kick	9	60	2607	2	k_ick
kiosk	8	3	623	2	kiosk
klick	10	53	1143	2	klick
knacks	11	42	854	2	knacks
knob	10	74	1701	2	kno_b
knobs	11	51	971	2	knobs
knocked	13	23	630	2	knocked
knocker	12	29	639	2	knocker
knoll	9	38	960	2	knoll
knop	10	71	1659	2	kno_p
knops	11	59	1181	2	knops
knosp	11	57	682	2	knosp
knot	8	56	3050	2	kno_t
knots	9	56	1472	2	knots
knout	9	50	1826	2	knout
know	11	61	1584	2	kno_w
known	12	56	834	2	known
knows	12	49	1241	2	knows
konk	7	93	2061	2	k_onk
kook	7	58	2260	2	k_ook
kyack	13	46	826	2	kyack
lock	10	61	3436	2	_lock
mock	12	64	2944	2	_mock
neck	10	54	2366	2	_neck
nick	10	66	2760	2	_nick
nocks	11	51	2101	2	_nocks
nook	8	57	2849	2	_nook
pock	12	61	2929	2	_pock
rock	10	57	3518	2	_rock
shock	14	49	1703	2	shock
smock	13	53	1167	2	smock
snack	11	47	1806	2	snack
sneck	11	47	1366	2	sneck
snick	11	44	1601	2	snick
snook	9	51	1557	2	snook
snuck	11	44	1191	2	snuck
sock	10	52	3321	2	_sock
stock	11	44	1756	2	stock
trock	11	48	1760	2	trock
uncock	14	3	856	2	uncock
undock	13	3	770	2	undock
unlock	12	4	853	2	unlock
yock	13	59	2461	2	_yock

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	61	1.500	35866.7
3	Display Results	61	61	0.016	3812.5
	(SQL Overall)	178691	61	1.829	97698.7