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

Here are the results of your fuzzy-string dictionary search for “shadowy” with Change Limit: [1] [2] [3] [4]

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.

94 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
shadowy	17	4	472	(None)
shadow	13	3	725	1	shadow_
shadows	14	3	719	1	shadows
meadowy	16	4	404	2	meadowy
shadfly	17	3	378	2	shadfly
shadily	14	3	772	2	shadily
shadoof	14	4	613	2	shadoof
shadowed	16	4	447	2	shadowed
shadower	15	4	486	2	shadower
shadowily	19	8	202	2	shadowily
shady	12	54	1651	2	shad__y
shamoy	14	37	991	2	shamo_y
showy	14	57	1401	2	sh__owy
adown	9	56	1166	3	__adown
beshadow	17	4	230	3	beshadow_
beshadows	18	4	251	3	beshadows
chador	12	3	867	3	chado_r
chadors	13	3	875	3	chadors
meadow	12	3	740	3	meadow_
meadows	13	3	733	3	meadows
sadly	9	45	1912	3	s_ad_ly
sallowy	13	36	934	3	sallowy
savory	12	43	1056	3	s_avory
savoy	11	47	1388	3	s_avo_y
saxony	16	3	623	3	s_axony
seadog	8	3	874	3	seado_g
seadogs	9	5	864	3	seadogs
seafowl	13	4	391	3	seafowl
shabby	16	3	580	3	sha_bby
shad	8	62	3091	3	shad___
shadblow	17	4	231	3	shadblow_
shadblows	18	4	247	3	shadblows
shaddock	19	4	327	3	shaddock
shade	9	51	2558	3	shad__e
shaded	11	45	1887	3	shad_ed
shader	10	42	1876	3	shad_er
shaders	11	59	1555	3	shaders
shades	10	59	2453	3	shad_es
shadier	11	31	1115	3	shadier
shading	12	31	1556	3	shading
shadoofs	15	5	423	3	shadoofs
shadowbox	25	5	136	3	shadowbox
shadowers	16	4	430	3	shadowers
shadowier	16	4	289	3	shadowier
shadowing	17	4	426	3	shadowing
shads	9	51	2448	3	shad__s
shaduf	13	3	706	3	shad_uf
shadufs	14	3	367	3	shadufs
shaggy	14	47	804	3	sha_ggy
shahdom	16	4	397	3	shahdo_m
shahdoms	17	4	377	3	shahdoms
shakedown	20	5	257	3	shakedown
shakily	17	3	690	3	shakily
shako	12	55	1609	3	shako__
shakoes	14	45	1002	3	shakoes
shakos	13	49	1219	3	shako_s
shaky	15	46	1684	3	sha__ky
shaley	12	37	1499	3	sha_ley
shallow	13	38	887	3	shallow_
shallowly	18	4	261	3	shallowly
shallows	14	38	886	3	shallows
shalom	11	8	1092	3	shalo_m
shaloms	12	8	898	3	shaloms
shaly	11	43	2286	3	sha__ly
shammy	16	38	850	3	sha_mmy
shamois	12	32	1042	3	shamois
shamos	11	42	1698	3	shamo_s
shamoys	15	36	728	3	shamoys
shandy	13	47	1003	3	sha_ndy
shanny	12	41	1009	3	sha_nny
shantey	13	42	1004	3	shantey
shanty	12	47	1512	3	sha_nty
shapely	15	3	689	3	shapely
sharny	12	47	1183	3	sha_rny
sharply	15	40	683	3	sharply
sharpy	14	52	1103	3	sha_rpy
shaw	10	81	3255	3	sha__w_
shawl	11	62	1757	3	sha__wl
shawm	13	53	1615	3	sha__wm
shawn	11	64	1761	3	sha__wn
shaws	11	62	2626	3	sha__ws
shay	10	71	3334	3	sha___y
shoddy	14	3	454	3	shod_dy
show	10	62	2919	3	sh__ow_
showdown	18	4	357	3	showdown
shown	11	52	1648	3	sh__own
shows	11	53	2458	3	sh__ows
shutdown	15	4	270	3	shutdown
snowy	11	50	1156	3	s__nowy
sodomy	12	7	667	3	s_odomy
spado	8	37	1370	3	spado__
suasory	10	4	604	3	suasory
sundown	11	8	631	3	sundown
windowy	17	4	464	3	windowy

Search took 7 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	134027	0.406	440125.6
2	DLD Change Limit	134027	94	6.016	22278.4
3	Display Results	94	94	0.030	3133.3
	(SQL Overall)	178691	94	6.452	27695.4