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

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

69 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
sylphic	17	4	588	(None)
sylphid	16	4	596	1	sylphid
delphic	15	4	510	2	delphic
glyphic	18	4	406	2	glyphic
sapphic	16	4	455	2	sapphic
sulphid	13	4	611	2	sulphid
sylph	13	4	779	2	sylph__
sylphids	17	4	395	2	sylphids
sylphish	19	4	427	2	sylphish
sylphs	14	3	554	2	sylph_s
sylphy	17	4	415	2	sylph_y
syrphid	16	4	610	2	syrphid
dolphin	13	4	553	3	dolphin
edaphic	15	4	424	3	edaphic
glyptic	15	4	450	3	glyptic
graphic	15	3	735	3	graphic
hypnic	16	3	726	3	hy_pnic
morphic	16	4	869	3	morphic
myopic	15	30	846	3	myop_ic
myrrhic	17	4	376	3	myrrhic
mythic	16	3	727	3	my_thic
orphic	13	6	832	3	_orphic
psychic	19	4	483	3	psy_chic
pyloric	14	3	806	3	pyloric
pyrrhic	17	4	407	3	pyrrhic
salic	7	34	2471	3	sal__ic
salpid	9	5	1088	3	salp_id
sapphics	17	4	342	3	sapphics
sceptic	13	3	783	3	sceptic
scyphi	16	4	317	3	scyphi_
selenic	9	4	1066	3	selenic
sepic	9	46	1705	3	s_ep_ic
septic	10	27	1319	3	s_eptic
seraphic	15	4	663	3	seraphic
silicic	11	4	760	3	silicic
skeptic	15	4	520	3	skeptic
spathic	14	3	754	3	spathic
spic	8	52	2743	3	s__p_ic
splenic	11	4	866	3	splenic
stichic	14	4	624	3	stichic
strophic	15	6	900	3	strophic
stylitic	13	5	634	3	stylitic
styptic	14	4	545	3	styptic
sulpha	11	3	540	3	sulph_a
sulphas	12	3	624	3	sulphas
sulphide	14	4	462	3	sulphide
sulphids	14	4	437	3	sulphids
sulphite	13	4	600	3	sulphite
sulphur	12	12	388	3	sulphur
syli	7	43	1898	3	syl__i_
sylis	8	43	1602	3	syl__is
syllabic	15	4	512	3	syllabic
sylleptic	16	5	315	3	sylleptic
sylphlike	21	4	268	3	sylphlike
sylvatic	16	4	535	3	sylvatic
sylvin	12	24	730	3	syl_vin
symphonic	21	4	607	3	symphonic
synaptic	15	4	628	3	synaptic
syndic	12	3	730	3	sy_ndic
synodic	13	4	736	3	synodic
synoptic	15	4	692	3	synoptic
syph	12	54	1327	3	sy_ph__
sypher	14	31	708	3	sy_pher
syphon	14	3	685	3	sy_phon
syphs	13	51	945	3	sy_ph_s
syrphian	16	4	345	3	syrphian
syrphids	17	4	424	3	syrphids
trophic	14	3	1103	3	trophic
typic	12	45	1196	3	ty_p_ic

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	69	6.110	21935.7
3	Display Results	69	69	0.016	4312.5
	(SQL Overall)	178691	69	6.532	27356.2