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

Here are the results of your fuzzy-string dictionary search for “deviative” 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
deviative	16	4	772	(None)
derivative	17	4	668	2	derivative
deviate	11	3	1271	2	deviat__e
deviating	14	3	1108	2	deviating
deviation	13	3	1239	2	deviation
mediative	15	4	812	2	mediative
dative	10	3	1181	3	d___ative
deceptive	17	4	685	3	deceptive
decisive	14	4	663	3	deci_sive
decoctive	17	4	586	3	decoctive
decorative	16	4	892	3	decorative
decretive	15	4	749	3	decretive
deductive	16	4	547	3	deductive
defective	18	4	800	3	defective
definitive	17	4	508	3	definitive
delineative	15	5	466	3	delineative
denigrative	16	5	548	3	denigrative
denotative	14	5	672	3	denotative
denotive	12	3	867	3	de_notive
depletive	15	4	562	3	depletive
derisive	12	4	750	3	deri_sive
derivatives	18	4	464	3	derivatives
derivatize	23	4	598	3	derivatize
derogative	15	4	698	3	derogative
desiccative	19	5	394	3	desiccative
designative	16	5	433	3	designative
detective	15	4	810	3	detective
detonative	14	4	713	3	detonative
detractive	16	4	737	3	detractive
devastative	18	5	343	3	devastative
deverbative	20	5	362	3	deverbative
deviance	14	7	708	3	devia_nce
deviated	13	3	1104	3	deviat_ed
deviates	12	3	1273	3	deviat_es
deviations	14	3	1116	3	deviations
deviator	12	4	831	3	deviat_or
deviators	13	5	853	3	deviators
deviatory	16	6	644	3	deviatory
devitalize	23	10	765	3	devitalize
dilative	12	3	952	3	d_ilative
divisive	15	4	501	3	divi_sive
dominative	16	7	739	3	dominative
donative	12	13	987	3	d_onative
durative	12	3	907	3	d_urative
educative	15	13	655	3	educative
elative	10	3	1245	3	_e_lative
ergative	12	3	897	3	_ergative
evasive	13	4	466	3	_ev_asive
evincive	16	4	285	3	_evincive
evocative	17	4	629	3	_evocative
genitive	12	4	764	3	geni_tive
gestative	13	4	730	3	gestative
ideative	12	3	857	3	ide__ative
lenitive	11	4	849	3	leni_tive
mediatize	21	4	690	3	mediatize
meditative	16	4	628	3	meditative
negative	12	3	908	3	ne_gative
privative	17	18	829	3	privative
radiative	13	4	817	3	radiative
recitative	15	4	818	3	recitative
relative	11	3	1314	3	re_lative
resistive	12	4	758	3	resistive
revertive	15	4	885	3	revertive
sedative	12	3	885	3	se_dative
tentative	12	4	781	3	tentative

Search took 9 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.423	422437.4
2	DLD Change Limit	148641	65	7.716	19264.0
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	8.172	21866.3