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

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

70 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
sunshiny	14	4	525	(None)
sunshine	11	4	792	1	sunshine
sunshines	12	4	658	2	sunshines
bunchily	18	4	454	3	bunchily
bunching	16	34	1070	3	bunching
bushily	15	26	889	3	bu_shily
bushing	13	40	1858	3	bu_shing
cushily	15	25	792	3	cu_shily
cushiony	16	4	258	3	cu_shiony
gunship	13	4	538	3	gunshi_p
gunships	14	4	517	3	gunships
gushily	14	25	782	3	gu_shily
gushing	12	40	1422	3	gu_shing
hunching	17	30	911	3	hunching
hushing	14	45	1447	3	hu_shing
lunching	14	31	1000	3	lunching
lushing	11	43	1611	3	lu_shing
moonshiny	17	4	299	3	moonshiny
munching	16	29	997	3	munching
mushily	15	24	1009	3	mu_shily
mushing	13	42	1763	3	mu_shing
outshine	11	3	1072	3	outshine
punchily	18	4	486	3	punchily
punching	16	33	1012	3	punching
punishing	15	4	538	3	punishing
pushily	15	24	798	3	pu_shily
pushing	13	36	1545	3	pu_shing
quashing	21	3	709	3	quashing
rushing	11	38	1770	3	ru_shing
sashing	11	46	2147	3	s_ashing
sensing	8	41	1695	3	sens_ing
shiny	11	51	2214	3	___shiny
shushing	15	31	774	3	shushing
slashing	12	37	1341	3	slashing
sloshing	12	25	882	3	sloshing
slushily	14	4	501	3	slushily
slushing	12	29	964	3	slushing
smashing	14	33	1024	3	smashing
smushing	14	28	745	3	smushing
sonship	12	10	865	3	sonshi_p
sonships	13	5	746	3	sonships
squashily	24	4	279	3	squashily
squashing	22	3	470	3	squashing
squishing	22	3	495	3	squishing
squushing	22	4	294	3	squushing
stashing	12	35	1158	3	stashing
subsidy	13	4	597	3	subs_idy
sudsing	9	29	1032	3	suds_ing
sughing	12	35	971	3	su_ghing
sundrily	12	4	606	3	sundrily
sunnily	10	3	783	3	sun_nily
sunning	8	37	1567	3	sun_ning
sunny	8	49	1774	3	sun___ny
sunshade	12	4	435	3	sunshade
sunstone	8	4	779	3	sunstone
sunsuit	7	4	869	3	sunsui_t
sunsuits	8	4	596	3	sunsuits
sushi	8	3	1049	3	su_shi__
sushis	9	3	1118	3	su_shi_s
sussing	8	40	1370	3	su_ssing
swashing	15	36	974	3	swashing
swishing	15	27	781	3	swishing
synching	17	22	771	3	synching
tushing	11	42	1401	3	tu_shing
unshift	13	8	742	3	_unshift
unship	11	4	803	3	_unshi_p
unships	12	3	720	3	_unships
unshowy	16	4	417	3	_unshowy
unsling	8	3	1364	3	_unsling
unthink	14	5	700	3	_unthink

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	146162	0.436	409841.7
2	DLD Change Limit	146162	70	6.453	22650.2
3	Display Results	70	70	0.033	2121.2
	(SQL Overall)	178691	70	6.922	25814.9