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

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

91 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
shaven	12	42	1330	(None)
haven	11	47	1853	1	_haven
shaken	13	41	1361	1	shaken
shapen	11	44	1465	1	shapen
shave	11	44	2589	1	shave_
shaved	13	51	1838	1	shaved
shaver	12	37	1891	1	shaver
shaves	12	52	2493	1	shaves
craven	11	41	1393	2	craven
daven	9	49	1647	2	_daven
graven	10	45	1352	2	graven
haen	7	62	2945	2	_ha_en
have	10	61	3707	2	_have_
havens	12	45	1404	2	_havens
haver	11	51	2446	2	_haver
haves	11	60	3487	2	_haves
heaven	12	39	1260	2	heaven
khazen	22	3	377	2	khazen
leaven	9	50	1307	2	leaven
maven	10	48	1689	2	_maven
raven	8	47	2344	2	_raven
reshaven	14	3	519	2	reshaven
save	7	57	4136	2	s_ave_
saved	9	51	2711	2	s_aved
saver	8	48	3125	2	s_aver
saves	8	58	3863	2	s_aves
savin	8	46	2508	2	s_avin
seamen	8	45	1856	2	seamen
seven	8	41	1831	2	s_even
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
shake	12	47	2640	2	shake_
shaker	13	43	1946	2	shaker
shakes	13	50	2459	2	shakes
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
shape	10	51	2511	2	shape_
shaped	12	50	2010	2	shaped
shaper	11	41	1993	2	shaper
shapes	11	51	2495	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
sharn	8	48	2370	2	sha_rn
sharpen	12	38	972	2	sharpen
shavers	13	41	1509	2	shavers
shavie	12	43	1242	2	shavie
shavies	13	42	1321	2	shavies
shaving	14	34	1433	2	shaving
shawed	13	48	1723	2	shawed
shawn	11	64	1761	2	sha_wn
sheave	12	45	1400	2	sheave_
sheaved	14	34	1163	2	sheaved
sheaves	13	44	1297	2	sheaves
sheen	8	50	2331	2	sh_een
shive	11	44	2342	2	shive_
shiver	12	45	1737	2	shiver
shives	12	49	2141	2	shives
shove	11	44	2104	2	shove_
shoved	13	42	1428	2	shoved
shovel	12	46	1132	2	shovel
shover	12	45	1599	2	shover
shoves	12	49	1942	2	shoves
shriven	13	37	965	2	shriven
slave	8	42	2403	2	slave_
slaved	10	40	1704	2	slaved
slaver	9	44	1961	2	slaver
slaves	9	50	2302	2	slaves
slavey	12	40	1180	2	slavey
sloven	9	38	963	2	sloven
soave	8	42	1905	2	soave_
soaves	9	42	1867	2	soaves
spavin	11	42	1065	2	spavin
stamen	8	41	1594	2	stamen
stave	8	53	2499	2	stave_
staved	10	39	1805	2	staved
staves	9	45	2519	2	staves
suave	8	35	1987	2	suave_
suaver	9	30	1423	2	suaver
sweven	12	3	598	2	sweven
unshaven	14	15	488	2	unshaven

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	91	2.360	34979.2
3	Display Results	91	91	0.016	5687.5
	(SQL Overall)	178691	91	2.719	65719.4