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

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

63 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
deviatory	16	6	646	(None)
deviator	12	4	833	1	deviator_
deviators	13	5	855	1	deviators
dedicatory	17	4	567	2	dedicatory
depilatory	16	4	574	2	depilatory
deviltry	15	4	298	2	devilt_ry
divinatory	17	4	394	2	divinatory
mediatory	15	4	644	2	mediatory
aviator	10	22	968	3	_aviator_
aviators	11	16	992	3	_aviators
damnatory	15	4	414	3	damnatory
decimator	14	4	773	3	decimator_
decimators	15	4	750	3	decimators
decretory	15	4	468	3	decretory
dedicator	13	4	825	3	dedicator_
dedicators	14	4	774	3	dedicators
defamatory	19	4	349	3	defamatory
deflator	12	32	834	3	deflator_
deflators	13	34	815	3	deflators
delator	8	30	1503	3	de_lator_
delators	9	23	1483	3	de_lators
denigratory	16	5	351	3	denigratory
depictor	13	5	551	3	depictor_
depictors	14	6	594	3	depictors
depilator	12	4	765	3	depilator_
depilators	13	4	733	3	depilators
derisory	12	4	516	3	deri_sory
derogatory	15	4	511	3	derogatory
designatory	16	5	338	3	designatory
desultory	13	4	340	3	desultory
deviancy	17	5	418	3	devia_ncy
deviate	11	3	1272	3	deviat__e
deviated	13	3	1105	3	deviat_ed
deviates	12	3	1275	3	deviat_es
deviating	14	3	1109	3	deviating
deviation	13	3	1240	3	deviation
deviations	14	3	1117	3	deviations
deviative	16	4	773	3	deviative
devilry	14	3	397	3	devi__lry
devisor	11	35	704	3	devi_sor_
devisors	12	34	725	3	devi_sors
dilatory	12	27	928	3	d_ilatory
educatory	15	4	544	3	educatory
evictor	12	34	637	3	_evictor_
evictors	13	27	686	3	_evictors
expiatory	21	4	518	3	expiatory
feudatory	16	4	406	3	feudatory
gestatory	13	4	452	3	gestatory
invitatory	16	4	478	3	invitatory
lavatory	14	4	570	3	lav_atory
levator	10	29	897	3	lev_ator_
levators	11	24	929	3	lev_ators
levitator	12	4	550	3	levitator_
levitators	13	4	541	3	levitators
mediator	11	3	905	3	mediator_
mediators	12	4	893	3	mediators
obviator	13	4	476	3	obviator_
obviators	14	4	486	3	obviators
revelatory	16	10	468	3	revelatory
revisory	14	30	602	3	revi_sory
viator	9	32	1184	3	__viator_
viators	10	27	1203	3	__viators
victory	15	32	698	3	__victory

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	148641	0.436	409841.7
2	DLD Change Limit	148641	63	6.516	22811.7
3	Display Results	63	63	0.033	1909.1
	(SQL Overall)	178691	63	6.985	25582.1