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

Here are the results of your fuzzy-string dictionary search for “shadz” 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
shad	8	62	3091	1	shad_
shade	9	51	2558	1	shade
shads	9	51	2448	1	shads
shady	12	54	1651	1	shady
adz	13	123	3286	2	__adz
chad	10	55	2550	2	chad_
chads	11	61	2223	2	chads
had	7	76	5876	2	_had_
hade	8	54	4019	2	_hade
hadj	15	58	1867	2	_hadj
khadi	13	6	760	2	khadi
sad	4	74	5920	2	s_ad_
sade	5	55	4447	2	s_ade
sadi	5	58	3464	2	s_adi
scad	7	57	2576	2	scad_
scads	8	54	1995	2	scads
sha	6	98	3778	2	sha__
shack	14	53	2175	2	shack
shaded	11	45	1887	2	shaded
shader	10	42	1876	2	shader
shades	10	59	2453	2	shades
shadow	13	3	725	2	shadow
shaduf	13	3	706	2	shaduf
shaft	11	57	2525	2	shaft
shag	8	64	3056	2	sha_g
shags	9	51	2386	2	shags
shah	10	56	2778	2	sha_h
shahs	11	59	1951	2	shahs
shake	12	47	2640	2	shake
shako	12	55	1608	2	shako
shaky	15	46	1684	2	shaky
shale	8	53	3283	2	shale
shall	8	50	2405	2	shall
shalt	8	55	3448	2	shalt
shaly	11	43	2286	2	shaly
sham	9	64	3635	2	sha_m
shame	10	57	2670	2	shame
shams	10	58	2941	2	shams
shandy	13	47	1003	2	shandy
shank	12	54	2219	2	shank
shape	10	51	2511	2	shape
shard	9	61	2596	2	shard
shards	10	43	1917	2	shards
share	8	64	3708	2	share
shark	12	62	2502	2	shark
sharn	8	48	2370	2	sharn
sharp	10	49	2253	2	sharp
shat	7	64	5659	2	sha_t
shaul	8	54	1810	2	shaul
shave	11	44	2589	2	shave
shaw	10	81	3255	2	sha_w
shawl	11	62	1757	2	shawl
shawm	13	53	1614	2	shawm
shawn	11	64	1761	2	shawn
shaws	11	62	2626	2	shaws
shay	10	71	3334	2	sha_y
shays	11	60	2143	2	shays
shed	8	65	3615	2	shed_
sheds	9	61	2270	2	sheds
shod	8	62	2505	2	shod_
spade	8	44	2332	2	spade
spado	8	37	1370	2	spado
spaz	15	56	2616	2	spa_z
spazz	15	58	1113	2	spazz
stade	6	48	2530	2	stade

Search took 4 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.190	940478.9
2	DLD Change Limit	53800	65	3.686	14595.8
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	3.906	45747.8