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

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

83 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
abstractive	18	5	489	(None)
abstracting	16	4	518	2	abstracting
abstraction	15	4	588	2	abstraction
attractive	15	4	555	2	a_ttractive
distractive	17	4	677	2	distractive
obstructive	18	5	461	2	obstructive
absorptive	17	5	367	3	absor_ptive
abstract	12	4	922	3	abstract___
abstractable	18	5	219	3	abstractable
abstracted	15	4	484	3	abstract_ed
abstracter	14	4	469	3	abstract_er
abstracters	15	4	410	3	abstracters
abstractest	15	5	362	3	abstractest
abstractions	16	4	578	3	abstractions
abstractly	17	12	339	3	abstract_ly
abstractor	14	4	438	3	abstract_or
abstractors	15	5	441	3	abstractors
abstracts	13	4	659	3	abstract__s
abstricting	16	5	450	3	abstricting
arbitrative	16	5	426	3	arbitra_tive
contractive	18	4	952	3	contractive
destructive	17	5	569	3	destructive
detractive	16	4	737	3	_detractive
extractive	22	4	660	3	_extractive
instructive	16	5	648	3	instructive
obstructives	19	5	391	3	obstructives
protractive	18	5	563	3	protractive
restrictive	16	4	636	3	restrictive
subtractive	18	5	466	3	subtractive
tractive	13	3	1004	3	___tractive
ablative	13	4	824	4	ab__la_tive
abortive	13	4	688	4	ab_or__tive
abrasive	13	4	575	4	ab__ra_sive
absolutive	15	5	265	4	abs_olutive
abstractedly	20	6	177	4	abstractedly
abstractional	17	5	326	4	abstractional
abstractness	16	8	301	4	abstractness
abstrict	12	5	794	4	abstrict___
abstricted	15	4	409	4	abstrict_ed
abstricts	13	5	518	4	abstrict__s
adsorptive	16	5	336	4	adsor_ptive
agitative	13	4	687	4	agit_a_tive
ascriptive	17	5	383	4	a_scriptive
assertive	12	4	647	4	asser__tive
assortative	14	7	395	4	assortative
astatine	8	3	1353	4	a_st_a_tine
astricting	13	5	783	4	a_stricting
attracting	13	4	656	4	a_ttracting
attraction	12	7	695	4	a_ttraction
attractively	20	5	358	4	a_ttractively
attritive	12	4	607	4	a_ttr_itive
bioactive	16	4	413	4	_b_ioactive
constrictive	19	5	662	4	constrictive
constructive	19	5	744	4	constructive
contractile	15	4	735	4	contractile
contrastive	16	4	729	4	contrastive
distinctive	17	5	493	4	distinctive
distractible	17	6	354	4	distractible
distracting	15	6	925	4	distracting
distraction	14	4	911	4	distraction
extractives	23	5	455	4	_extractives
gestative	13	4	730	4	gest_a_tive
gustative	13	4	568	4	gust_a_tive
hyperactive	24	5	629	4	hyperactive
instinctive	16	5	437	4	instinctive
interactive	16	5	963	4	interactive
obstructing	16	4	457	4	obstructing
obstruction	15	13	554	4	obstruction
ostracise	11	4	629	4	_ostrac_ise
ostracize	20	4	517	4	_ostrac_ize
overactive	18	4	726	4	_overactive
protractile	15	5	410	4	protractile
refractive	18	4	669	4	_refractive
restorative	14	4	694	4	restora_tive
restrictives	17	5	508	4	restrictives
retractile	12	4	625	4	_retractile
retroactive	16	4	582	4	_retroactive
stative	10	26	1293	4	__st_a_tive
substantive	16	5	417	4	subst_antive
tractile	10	3	1107	4	___tractile
unattractive	17	5	242	4	unattractive
underactive	17	4	596	4	underactive
vasoactive	18	5	247	4	vas_oactive

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.483	369960.7
2	DLD Change Limit	148819	83	9.393	15843.6
3	Display Results	83	83	0.046	1804.3
	(SQL Overall)	178691	83	9.922	18009.6