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

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

65 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
clanky	15	46	907	(None)
clank	11	47	1952	1	clank_
clanks	12	46	1518	1	clanks
clunky	15	44	789	1	clunky
cranky	15	39	1063	1	cranky
lanky	12	55	1748	1	_lanky
blank	11	54	1855	2	blank_
blankly	16	3	426	2	blankly
blanks	12	41	1289	2	blanks
caky	13	62	2244	2	c_a_ky
candy	11	51	1982	2	c_andy
canny	10	58	1769	2	c_anny
canty	10	52	2680	2	c_anty
casky	14	45	1268	2	c_asky
chalky	18	46	877	2	chalky
chancy	16	40	1086	2	chancy
chanty	14	52	1582	2	chanty
chinky	18	56	1054	2	chinky
chunky	18	46	827	2	chunky
clack	13	47	2017	2	clack_
clacks	14	45	1634	2	clacks
clammy	15	35	633	2	clammy
clan	6	56	3392	2	clan__
clang	8	60	1931	2	clan_g
clangs	9	51	1361	2	clangs
clanked	14	38	1225	2	clanked
clans	7	50	3101	2	clan_s
clary	10	57	1961	2	cla_ry
classy	11	37	904	2	classy
clay	9	59	2741	2	cla__y
clayey	14	40	766	2	clayey
cleanly	12	3	632	2	cleanly
clingy	12	65	906	2	clingy
clink	11	53	2004	2	clink_
clinks	12	58	1506	2	clinks
clonk	11	44	1744	2	clonk_
clonks	12	50	1347	2	clonks
clunk	11	42	1508	2	clunk_
clunks	12	48	1101	2	clunks
conky	14	58	1874	2	c_onky
cracky	17	50	1022	2	cracky
crank	11	48	1961	2	crank_
crankly	16	35	812	2	crankly
cranks	12	50	1531	2	cranks
cranny	11	42	1027	2	cranny
flaky	15	57	1558	2	fla_ky
flank	12	46	1809	2	flank_
flanks	13	39	1340	2	flanks
flunky	16	40	809	2	flunky
hanky	15	54	1829	2	_hanky
laky	11	67	2582	2	_la_ky
lank	8	47	3444	2	_lank_
lankly	13	43	962	2	_lankly
larky	12	52	1887	2	_larky
linky	12	76	2238	2	_linky
plank	11	52	2114	2	plank_
planks	12	41	1675	2	planks
plunky	15	37	795	2	plunky
skanky	12	47	696	2	skanky
slangy	10	54	1139	2	slangy
slank	9	58	2277	2	slank_
slanty	9	51	1484	2	slanty
slinky	13	39	910	2	slinky
swanky	16	44	797	2	swanky
twanky	16	44	577	2	twanky

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	82551	0.123	1452772.4
2	DLD Change Limit	82551	65	2.686	30733.8
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	2.825	63253.5