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

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

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.

37 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
deteriorating	15	5	339	(None)
deterioration	14	14	528	2	deterioration
deteriorations	15	16	469	2	deteriorations
deteriorative	17	6	258	2	deteriorative
decerebrating	19	5	320	3	decerebrating
deteriorate	12	5	509	3	deteriorat__e
deteriorated	14	5	346	3	deteriorat_ed
deteriorates	13	5	444	3	deteriorat_es
ameliorating	15	5	307	4	_ameliorating
deaerating	12	3	1156	4	deae___rating
decarbonating	19	5	323	4	decarbonating
decelerating	16	4	559	4	dece_lerating
decorating	14	3	1207	4	d__e_corating
degenerating	15	4	566	4	dege_nerating
demeriting	14	4	868	4	demeri___ting
denervating	16	4	592	4	dener__vating
denigrating	14	14	692	4	d__enigrating
denitrating	13	12	833	4	d__enitrating
derogating	13	4	863	4	d__er_ogating
desecrating	15	4	809	4	dese__crating
deterring	11	3	862	4	deter__r__ing
detonating	12	4	882	4	det___onating
detoxicating	23	5	386	4	detoxi_cating
deuterating	13	4	727	4	deute___rating
etiolating	11	4	697	4	_et__iolating
exteriorising	21	7	276	4	exteriorising
exteriorizing	30	6	333	4	exteriorizing
interiorising	14	14	491	4	interiorising
interiorizing	23	14	497	4	interiorizing
interpolating	16	5	779	4	interpolating
interrogating	15	5	666	4	interrogating
meliorating	14	4	656	4	__meliorating
metricating	16	4	736	4	met_ri_cating
perforating	17	4	702	4	__perforating
perorating	13	3	1313	4	__per_orating
redecorating	16	11	505	4	rede_corating
reverberating	19	5	320	4	reverberating

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	95024	0.360	496363.9
2	DLD Change Limit	95024	37	6.173	15393.5
3	Display Results	37	37	0.013	2846.2
	(SQL Overall)	178691	37	6.546	27297.7