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

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

73 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
instinctive	16	5	437	(None)
distinctive	17	5	493	2	distinctive
indistinctive	19	9	228	2	indistinctive
instigative	15	5	512	2	instigative
instinctively	21	5	308	2	instinctively
instructive	16	5	648	2	instructive
extinctive	22	5	345	3	_extinctive
infinitive	16	4	534	3	in_finitive
inflictive	18	10	463	3	infli_ctive
initiative	13	4	690	3	initi_ative
injunctive	22	5	403	3	in_junctive
insinuative	14	5	402	3	ins_inuative
inspective	17	4	640	3	ins_pective
instinct	10	4	872	3	instinct___
instincts	11	4	453	3	instinct__s
instinctual	13	5	199	3	instinctual
intinction	12	4	778	3	in_tinction
abstractive	18	5	489	4	abstractive
constitutive	17	5	410	4	constitutive
constrictive	19	5	662	4	constrictive
constructive	19	5	744	4	constructive
destructive	17	5	569	4	destructive
disjunctive	24	13	332	4	disjunctive
distinction	14	4	732	4	distinction
distinctively	22	6	332	4	distinctively
distractive	17	4	677	4	distractive
estimative	15	4	648	4	_estimative
imaginative	17	5	384	4	imaginative
inactive	13	4	820	4	in___active
inattentive	14	5	256	4	inattentive
incentive	14	8	960	4	in_cen_tive
indicative	16	4	771	4	in_dicative
inductive	15	4	726	4	in__ductive
ineffective	22	7	394	4	ineffective
infective	17	10	897	4	in__fective
infinitives	17	4	468	4	in_finitives
inflective	18	12	657	4	in_flective
inhibitive	18	5	404	4	in_hibitive
initiatives	14	4	428	4	initi_atives
injective	21	7	802	4	in__jective
inquisitive	23	8	319	4	inquisitive
inscriptive	18	5	384	4	inscriptive
insectile	11	4	711	4	ins__ectile
insensitive	14	5	481	4	insensitive
insincere	11	4	368	4	ins_inc_ere
instance	10	4	988	4	instanc___e
instancies	12	4	661	4	instanc_ies
instancing	13	4	464	4	instanc_ing
instantiate	11	5	401	4	instan_tiate
instigate	10	4	861	4	instigat__e
instigating	13	4	715	4	instigating
instigation	12	4	924	4	instigation
institute	9	4	644	4	insti__tute
instituting	12	4	480	4	instituting
institution	11	4	529	4	institution
instructing	14	4	629	4	instructing
instruction	13	13	794	4	instruction
instructively	21	6	442	4	instructively
intensive	12	4	840	4	in_ten_sive
interactive	16	5	963	4	interactive
intinctions	13	4	700	4	in_tinctions
intuitive	12	4	616	4	in_t_uitive
invective	17	9	804	4	in__vective
inventive	15	8	804	4	in_ven_tive
investigative	20	6	263	4	investigative
nominative	15	9	768	4	_nominative
nondistinctive	20	7	191	4	nondistinctive
obstructive	18	5	461	4	obstructive
restrictive	16	4	636	4	restrictive
uninstructive	18	6	294	4	uninstructive
unselective	16	5	376	4	unselective
unstinting	11	4	730	4	unstin_ting
vindictive	19	4	354	4	vin_di_ctive

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.423	422437.4
2	DLD Change Limit	148819	73	8.610	17284.4
3	Display Results	73	73	0.046	1587.0
	(SQL Overall)	178691	73	9.079	19681.8