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

Here are the results of your fuzzy-string dictionary search for “casky” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

105 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
casky	14	45	1268	(None)
caky	13	62	2244	1	ca_ky
cask	10	56	2643	1	cask_
casks	11	57	2006	1	casks
alky	11	59	2034	2	_alky
ashy	10	77	1735	2	_ashy
ask	7	71	3070	2	_ask_
asks	8	57	2121	2	_asks
balky	14	54	1824	2	balky
barky	14	57	2161	2	barky
bask	10	51	3142	2	bask_
basks	11	56	2176	2	basks
bassy	10	129	1710	2	bassy
bosky	14	56	1239	2	bosky
cabby	14	53	1456	2	cabby
caddy	12	54	1402	2	caddy
cadgy	12	52	1078	2	cadgy
cagey	11	59	1782	2	cagey
cagy	10	63	2199	2	ca_gy
cake	10	54	3996	2	ca_ke
cakey	14	55	1727	2	cakey
calk	10	55	2766	2	calk_
calks	11	54	2160	2	calks
campy	14	51	1618	2	campy
candy	11	51	1982	2	candy
canny	10	58	1769	2	canny
canty	10	52	2680	2	canty
cark	10	55	3927	2	cark_
carks	11	55	3421	2	carks
carny	10	58	2292	2	carny
carry	10	58	2378	2	carry
casa	6	56	3086	2	cas_a
casas	7	53	2784	2	casas
case	6	58	4808	2	cas_e
cased	8	60	3241	2	cased
casefy	14	3	627	2	casefy
cases	7	50	4838	2	cases
cash	9	66	3628	2	cas_h
casked	13	48	1551	2	casked
casket	12	48	2099	2	casket
cast	6	71	5990	2	cas_t
caste	7	59	3236	2	caste
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
catty	10	45	2041	2	catty
causey	11	35	1327	2	causey
cavy	12	59	2000	2	ca_vy
cay	8	71	5598	2	ca__y
chalky	18	46	877	2	chalky
chasmy	16	46	854	2	chasmy
choky	17	57	1122	2	choky
cissy	10	48	1107	2	cissy
clanky	15	46	907	2	clanky
classy	11	37	904	2	classy
cocky	16	42	1593	2	cocky
coky	13	75	2682	2	c_oky
conky	14	58	1874	2	conky
cooky	14	53	2136	2	cooky
corky	14	52	2115	2	corky
cosey	10	62	2671	2	cosey
cosy	9	72	3270	2	cos_y
cracky	17	50	1022	2	cracky
cranky	15	39	1063	2	cranky
cushy	13	44	1232	2	cushy
cusk	10	55	2163	2	cusk_
cusks	11	49	1605	2	cusks
darky	13	60	1883	2	darky
dashy	12	56	1238	2	dashy
dusky	13	52	1304	2	dusky
easy	7	62	2449	2	eas_y
ensky	12	3	509	2	ensky
gassy	9	55	1402	2	gassy
gawky	16	56	999	2	gawky
hanky	15	54	1829	2	hanky
hasty	11	57	1876	2	hasty
husky	15	61	1256	2	husky
jacky	21	54	1234	2	jacky
laky	11	67	2582	2	la_ky
lanky	12	55	1748	2	lanky
larky	12	52	1887	2	larky
mashy	13	60	1650	2	mashy
mask	10	52	2735	2	mask_
masks	11	53	2053	2	masks
massy	10	45	1896	2	massy
musky	14	47	1529	2	musky
narky	12	60	1780	2	narky
nasty	8	57	1728	2	nasty
oaky	11	64	1995	2	oa_ky
pasty	10	57	2505	2	pasty
pawky	17	38	1015	2	pawky
pesky	14	59	1156	2	pesky
raspy	10	65	1170	2	raspy
risky	12	63	1152	2	risky
sarky	12	55	2178	2	sarky
sassy	8	58	1381	2	sassy
sky	10	64	2099	2	__sky
tacky	14	56	1744	2	tacky
talky	12	62	1568	2	talky
task	8	53	2665	2	task_
tasks	9	49	1758	2	tasks
tasty	8	48	2031	2	tasty
vasty	11	62	1592	2	vasty
wacky	17	47	1493	2	wacky
washy	14	59	1184	2	washy
waspy	13	54	1099	2	waspy

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.093	1921408.6
2	DLD Change Limit	53800	105	1.983	27130.6
3	Display Results	105	105	0.033	3181.8
	(SQL Overall)	178691	105	2.109	84727.8