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

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

75 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
devastators	15	5	292	(None)
devastator	14	5	314	1	devastator_
devastates	14	4	466	2	devastat_es
devastations	16	4	582	2	devastations
deaerators	11	10	771	3	de_aerators
decapitators	17	5	326	3	decapitators
defalcators	17	4	286	3	defalcators
devastate	13	4	495	3	devastat__e
devastated	15	4	412	3	devastat_ed
devastating	16	4	470	3	devastating
devastation	15	4	673	3	devastation
devastative	18	5	343	3	devastative
deviators	13	5	853	3	dev__iators
dilatators	11	4	401	3	dila_tators
evacuators	15	10	448	3	_evacuators
evaluators	13	7	459	3	_evaluators
levitators	13	4	540	3	lev_itators
testators	9	4	733	3	te__stators
castrators	12	4	744	4	__castrators
deactivators	18	5	257	4	de_activators
deaerator	10	12	811	4	de_aerator_
decantations	15	4	794	4	decantations
decapitator	16	5	380	4	decapitator_
decimators	15	4	750	4	de_cimators
decorators	13	4	787	4	de_corators
dedicators	14	4	774	4	de_dicators
defalcator	16	4	317	4	defalcator_
defamatory	19	4	348	4	defa_matory
defecators	16	5	625	4	de_fecators
deflators	13	34	815	4	de__flators
defoliators	15	4	372	4	defoliators
degustations	14	4	483	4	degustations
dehydrators	19	5	285	4	dehydrators
delators	9	23	1482	4	de___lators
delegators	12	4	563	4	de_legators
delineators	12	5	396	4	delineators
demonstrators	16	7	341	4	demonstrators
denigrators	13	4	452	4	denigrators
depilators	13	4	733	4	de_pilators
depositors	13	4	403	4	depos_itors
depredators	15	4	373	4	depredators
depurators	13	4	648	4	de_purators
desalinators	13	5	360	4	desalinators
desecrators	14	4	523	4	desecrators
desiccators	16	4	380	4	desiccators
designators	13	4	430	4	designators
desolators	11	4	628	4	de_solators
detestations	13	4	758	4	detestations
detonators	11	4	585	4	de_tonators
devaluates	14	26	606	4	devaluat_es
devaluations	16	4	635	4	devaluations
deviator	12	4	831	4	dev__iator_
deviatory	16	6	644	4	dev__iatory
devisors	12	34	725	4	devis___ors
dictators	12	4	736	4	d__ictators
dilatator	10	4	414	4	dila_tator_
downstaters	15	5	207	4	downstaters
emanators	11	4	703	4	_ema_nators
evacuator	14	11	493	4	_evacuator_
evaluator	12	10	496	4	_evaluator_
evaporators	16	5	348	4	_evaporators
evocators	14	4	671	4	_ev_ocators
gestatory	13	4	452	4	ge__statory
hesitators	13	8	585	4	he_sitators
legislators	12	7	305	4	legislators
levators	11	24	928	4	lev___ators
levitator	12	4	549	4	lev_itator_
lovastatins	14	5	166	4	lovastatins
meditators	13	4	626	4	me_ditators
megastars	12	4	365	4	megasta__rs
revelators	13	11	642	4	rev_elators
separators	12	4	650	4	sepa_rators
stators	7	39	1558	4	____stators
testator	8	4	737	4	te__stator_
valuators	12	8	646	4	__valuators

Search took 10 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	148819	0.436	409841.7
2	DLD Change Limit	148819	75	9.266	16060.8
3	Display Results	75	75	0.046	1630.4
	(SQL Overall)	178691	75	9.748	18331.0