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

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

65 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
decorators	13	4	787	(None)
decorator	12	4	857	1	decorator_
deaerators	11	10	771	2	deaerators
decimators	15	4	750	2	decimators
decorates	12	3	1474	2	decorat_es
decorations	14	3	1288	2	decorations
depurators	13	4	648	2	depurators
desolators	11	4	628	2	desolators
detonators	11	4	585	2	detonators
perorators	12	4	935	2	perorators
redecorators	15	5	266	2	redecorators
aerators	8	3	1561	3	ae__rators
cocurators	14	4	730	3	cocurators
curators	10	3	1172	3	__curators
deaerator	10	12	811	3	deaerator_
decelerators	15	5	349	3	decelerators
decimator	14	4	773	3	decimator_
declaratory	17	5	285	3	declaratory
decolors	11	8	771	3	deco__lors
decorate	11	3	1519	3	decorat__e
decorated	13	3	1220	3	decorat_ed
decorating	14	3	1207	3	decorating
decoration	13	3	1442	3	decoration
decorative	16	4	892	3	decorative
decorous	11	3	885	3	decor__ous
decorticators	18	6	249	3	decor~~tic~~ators
decretory	15	4	468	3	dec_retory
dedicators	14	4	774	3	dedicators
defecators	16	5	625	3	defecators
deflators	13	34	815	3	de_flators
defoliators	15	4	372	3	defoliators
dehydrators	19	5	285	3	dehydrators
delators	9	23	1482	3	de__lators
delegators	12	4	563	3	delegators
denigrators	13	4	452	3	denigrators
depilators	13	4	733	3	depilators
deporters	12	7	779	3	depor_ters
depositors	13	4	403	3	depositors
depurator	12	4	702	3	depurator_
derogatory	15	4	511	3	derogatory
desecrators	14	4	523	3	desecrators
desolaters	11	4	604	3	desolaters
desolator	10	4	667	3	desolator_
detonator	10	4	598	3	detonator_
detractors	13	14	729	3	de_tractors
deviators	13	5	853	3	de_viators
dictators	12	4	736	3	dic_tators
donators	9	3	1040	3	d__onators
evocators	14	4	671	3	_evocators
execrators	19	4	602	3	exec_rators
federators	14	4	619	3	federators
generators	11	4	753	3	generators
macerators	14	16	748	3	macerators
meliorators	13	11	500	3	meliorators
orators	7	3	1382	3	___orators
peculators	14	8	698	3	peculators
percolators	15	4	536	3	percolators
perforators	16	4	485	3	perforators
perorator	11	4	974	3	perorator_
redecorator	14	5	298	3	redecorator_
renovators	13	4	484	3	renovators
resonators	10	4	581	3	resonators
secretors	11	4	584	3	sec_retors
separators	12	4	650	3	separators
venerators	13	4	706	3	venerators

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	140603	0.436	409841.7
2	DLD Change Limit	140603	65	5.750	24452.7
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	6.219	28733.1