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

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

86 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
shaken	13	41	1361	(None)
shake	12	47	2640	1	shake_
shaker	13	43	1946	1	shaker
shakes	13	50	2459	1	shakes
shapen	11	44	1465	1	shapen
shaven	12	42	1330	1	shaven
awaken	13	46	886	2	awaken
haen	7	62	2945	2	_ha_en
hake	11	56	3784	2	_hake_
hakes	12	60	3430	2	_hakes
harken	13	51	1634	2	_harken
haven	11	47	1853	2	_haven
khazen	22	3	377	2	khazen
kraken	9	5	588	2	kraken
oaken	9	58	1438	2	_oaken
sake	8	52	4496	2	s_ake_
saker	9	51	3202	2	s_aker
sakes	9	55	4075	2	s_akes
seamen	8	45	1856	2	seamen
shacked	17	40	1539	2	shacked
shade	9	51	2558	2	shade_
shaded	11	45	1887	2	shaded
shader	10	42	1876	2	shader
shades	10	59	2453	2	shades
shairn	9	26	906	2	shairn
shakers	14	40	1556	2	shakers
shakeup	16	3	276	2	shakeup
shakier	14	34	1115	2	shakier
shaking	15	33	1725	2	shaking
shako	12	55	1609	2	shak_o
shakoes	14	45	1002	2	shakoes
shakos	13	49	1219	2	shakos
shaky	15	46	1684	2	shak_y
shale	8	53	3283	2	shale_
shaled	10	50	2395	2	shaled
shales	9	47	3125	2	shales
shaley	12	37	1499	2	shaley
shaman	11	33	1428	2	shaman
shame	10	57	2670	2	shame_
shamed	12	51	2021	2	shamed
shames	11	47	2622	2	shames
shanked	15	32	1212	2	shanked
shape	10	51	2511	2	shape_
shaped	12	50	2010	2	shaped
shaper	11	41	1993	2	shaper
shapes	11	51	2494	2	shapes
share	8	64	3708	2	share_
shared	10	58	2906	2	shared
sharer	9	50	2548	2	sharer
shares	9	52	3641	2	shares
sharked	15	36	1391	2	sharked
sharker	14	43	1381	2	sharker
sharn	8	48	2370	2	sha_rn
sharpen	12	38	972	2	sharpen
shave	11	44	2589	2	shave_
shaved	13	51	1838	2	shaved
shaver	12	37	1891	2	shaver
shaves	12	52	2493	2	shaves
shawed	13	48	1723	2	shawed
shawn	11	64	1761	2	sha_wn
sheen	8	50	2331	2	sh_een
shekel	13	3	838	2	shekel
sicken	12	46	1525	2	sicken
silken	10	44	1085	2	silken
slacken	13	39	993	2	slacken
slake	9	37	2405	2	slake_
slaked	11	43	1827	2	slaked
slaker	10	42	1927	2	slaker
slakes	10	40	2188	2	slakes
snake	9	48	2111	2	snake_
snaked	11	50	1759	2	snaked
snakes	10	39	1960	2	snakes
snakey	13	50	1127	2	snakey
soaked	11	47	1759	2	soaked
soaker	10	57	1753	2	soaker
spake	11	43	2274	2	spake_
spoken	12	46	1000	2	spoken
stake	9	59	2753	2	stake_
staked	11	46	2194	2	staked
stakes	10	39	2729	2	stakes
stamen	8	41	1594	2	stamen
sunken	10	35	1178	2	sunken
taken	9	48	1914	2	_taken
unshaken	15	17	540	2	unshaken
waken	12	48	1847	2	_waken
weaken	13	34	960	2	weaken

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.343	520965.0
2	DLD Change Limit	82551	86	2.503	32980.8
3	Display Results	86	86	0.013	6615.4
	(SQL Overall)	178691	86	2.859	62501.2