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

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

60 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
thiol	8	76	1604	(None)
thill	8	59	1873	1	thill
thio	7	72	2541	1	thio_
thiols	9	51	1276	1	thiols
thirl	8	54	1682	1	thirl
triol	5	55	2136	1	triol
chiel	10	49	1897	2	chiel
chill	10	56	1987	2	chill
diol	5	73	2913	2	_diol
dithiol	11	4	543	2	dithiol
ethion	9	3	881	2	ethion
hill	7	64	3949	2	_hill
phial	10	3	1320	2	phial
sheol	8	43	1837	2	sheol
shiel	8	110	2377	2	shiel
shill	8	53	2533	2	shill
shool	8	45	2315	2	shool
tail	4	54	4365	2	tai_l
taxol	12	40	1136	2	taxol
thiazol	19	4	262	2	thiazol
thick	14	56	1335	2	thick
thief	11	45	1630	2	thief
thigh	12	4	1012	2	thigh
thills	9	55	1538	2	thills
thin	7	67	3239	2	thi_n
thine	8	50	2686	2	thine
thing	9	66	2298	2	thing
think	12	50	1880	2	think
thinly	12	3	867	2	thinly
thins	8	58	2633	2	thins
thiolic	12	4	732	2	thiolic
thionyl	13	4	371	2	thionyl
thir	7	64	2054	2	thi_r
third	9	59	1249	2	third
thirls	9	50	1206	2	thirls
this	7	60	2738	2	thi_s
tho	6	74	3396	2	th_o_
thole	8	56	2084	2	th_ole
thou	7	67	2221	2	th_ou
thrill	9	49	1059	2	thrill
thro	7	77	2642	2	thro_
throb	10	98	1685	2	throb
throe	8	93	2142	2	throe
throw	11	87	1973	2	throw
thurl	8	49	1268	2	thurl
thymol	14	3	446	2	thymol
til	3	63	5026	2	t_i_l
till	4	59	4120	2	t_ill
tirl	4	50	2992	2	t_irl
toil	4	65	3628	2	toi_l
tool	4	67	3568	2	t_ool
trial	5	49	2635	2	trial
trill	5	51	2293	2	trill
trio	4	52	3334	2	trio_
triols	6	61	1780	2	triols
trios	5	55	2809	2	trios
twill	8	56	1272	2	twill
twirl	8	50	1194	2	twirl
viol	7	65	2359	2	_viol
whirl	11	49	1382	2	whirl

Search took 2 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.296	603685.8
2	DLD Change Limit	53800	60	1.516	35488.1
3	Display Results	60	60	0.016	3750.0
	(SQL Overall)	178691	60	1.828	97752.2