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

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

97 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
junky	19	45	1323	(None)
funky	15	43	1513	1	funky
gunky	13	55	1411	1	gunky
hunky	15	54	1773	1	hunky
junk	15	51	2103	1	junk_
junks	16	48	1597	1	junks
punky	14	44	1939	1	punky
aunty	8	59	1981	2	aunty
bulky	14	62	1557	2	bulky
bunk	10	57	3135	2	bunk_
bunko	11	55	1451	2	bunko
bunks	11	51	2508	2	bunks
bunny	10	47	1580	2	bunny
chunky	18	46	827	2	chunky
clunky	15	44	789	2	clunky
conky	14	58	1874	2	conky
dinky	13	58	1937	2	dinky
ducky	15	42	1611	2	ducky
dumky	15	45	1134	2	dumky
dungy	10	47	1364	2	dungy
dunk	9	62	2857	2	dunk_
dunks	10	56	2119	2	dunks
dusky	13	52	1304	2	dusky
flunky	16	40	809	2	flunky
funk	11	58	2562	2	funk_
funks	12	53	1891	2	funks
funny	11	46	1483	2	funny
gunk	9	54	2357	2	gunk_
gunks	10	45	1772	2	gunks
gunny	9	44	1366	2	gunny
hanky	15	54	1829	2	hanky
hinky	15	56	1875	2	hinky
honky	15	62	1852	2	honky
hulky	15	53	1247	2	hulky
hunk	11	60	2954	2	hunk_
hunkey	16	42	1088	2	hunkey
hunks	12	53	2145	2	hunks
husky	15	61	1256	2	husky
inky	11	53	2158	2	_inky
jacky	21	54	1234	2	jacky
janty	15	68	1696	2	janty
jaunty	16	38	851	2	jaunty
jenny	15	38	1162	2	jenny
jerky	19	67	1242	2	jerky
jink	15	62	2720	2	jink_
jinks	16	50	1933	2	jinks
joky	18	62	1531	2	j_oky
jouncy	18	33	620	2	jouncy
juicy	17	3	828	2	juicy
juke	15	47	2166	2	ju_ke
juku	15	44	1485	2	ju_ku
jumpy	19	57	1281	2	jumpy
jun	10	59	3206	2	jun__
junco	14	46	1220	2	junco
jungly	17	40	769	2	jungly
junked	18	43	1169	2	junked
junker	17	42	1365	2	junker
junket	17	38	1502	2	junket
junkie	17	33	960	2	junkie
junta	12	37	1367	2	junta
junto	12	51	1456	2	junto
jury	14	67	1959	2	ju_ry
jutty	15	49	1464	2	jutty
kinky	11	58	1638	2	kinky
lanky	12	55	1748	2	lanky
linky	12	76	2238	2	linky
lucky	14	55	1501	2	lucky
lunk	8	60	3072	2	lunk_
lunks	9	48	2245	2	lunks
luny	7	73	2413	2	lun_y
mucky	16	50	1525	2	mucky
murky	14	52	1668	2	murky
musky	14	47	1529	2	musky
pinky	14	58	2340	2	pinky
plunky	15	37	795	2	plunky
punk	10	57	2997	2	punk_
punka	11	45	1548	2	punka
punkey	15	40	1117	2	punkey
punks	11	48	2268	2	punks
punny	10	42	1771	2	punny
punty	10	60	2161	2	punty
puny	9	55	2699	2	pun_y
quaky	21	43	1074	2	quaky
runny	8	46	1348	2	runny
runty	8	61	1904	2	runty
skunky	12	43	616	2	skunky
spunky	15	42	716	2	spunky
sucky	14	44	1550	2	sucky
sulky	12	47	1536	2	sulky
sunk	8	50	3181	2	sunk_
sunny	8	49	1774	2	sunny
tunny	8	65	1503	2	tunny
undy	8	50	1516	2	_undy
wonky	15	40	1177	2	wonky
yucky	17	54	1169	2	yucky
yukky	14	42	521	2	yukky
zinky	21	53	1481	2	zinky

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	97	2.483	21667.3
3	Display Results	97	97	0.016	6062.5
	(SQL Overall)	178691	97	2.592	68939.4