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

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

64 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
intensive	12	4	840	(None)
intensives	13	4	739	1	intensives
extensive	19	4	572	2	extensive
incentive	14	8	960	2	incentive
intense	7	25	1190	2	intens__e
intensify	15	4	399	2	intensify
intension	9	4	849	2	intension
intensity	12	4	720	2	intensity
intensively	17	5	620	2	intensively
intrusive	12	4	597	2	intrusive
inventive	15	8	804	2	inventive
inversive	15	5	719	2	inversive
ostensive	12	4	473	2	ostensive
tensive	10	26	991	2	__tensive
ascensive	14	4	418	3	ascensive
attentive	12	4	585	3	attentive
defensive	16	4	500	3	defensive
detersive	13	4	634	3	detersive
expensive	21	4	584	3	expensive
extensile	16	4	503	3	extensile
inattentive	14	5	256	3	inattentive
incense	9	24	1030	3	incens__e
incensing	12	9	766	3	incensing
incentives	15	7	805	3	incentives
inceptive	16	7	784	3	inceptive
incisive	13	4	628	3	in_cisive
inclusive	14	4	532	3	inclusive
incursive	14	4	525	3	incursive
indecisive	16	5	334	3	indecisive
inexpensive	23	5	256	3	inexpensive
infective	17	10	897	3	infective
infusive	14	4	518	3	in_fusive
ingestive	13	4	739	3	ingestive
ingressive	14	5	526	3	ingressive
injective	21	7	802	3	injective
inoffensive	20	5	174	3	inoffensive
insensate	9	4	539	3	insensate
insensible	12	4	668	3	insensible
insensitive	14	5	481	3	insensitive
intending	11	3	998	3	intending
intensely	12	4	539	3	intensely
intenser	8	19	944	3	intens_er
intensest	9	4	910	3	intensest
intensified	15	10	401	3	intensified
intensifier	14	11	349	3	intensifier
intensifies	14	10	533	3	intensifies
intensions	10	4	840	3	intensions
intensities	11	10	891	3	intensities
intention	9	4	1201	3	intention
interfile	12	4	1104	3	interfile
interline	9	12	1801	3	interline
interstice	12	4	960	3	interstice
intertie	8	3	1761	3	interti_e
interwove	15	4	714	3	interwove
intestine	9	4	1185	3	intestine
intrusives	13	4	450	3	intrusives
intuitive	12	4	616	3	intuitive
invasive	14	4	483	3	in_vasive
invective	17	9	804	3	invective
offensive	18	4	277	3	offensive
pensive	12	26	1039	3	__pensive
protensive	15	4	620	3	protensive
retentive	12	4	985	3	retentive
tensile	7	26	1273	3	__tensile

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	148641	0.423	422437.4
2	DLD Change Limit	148641	64	8.780	16929.5
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	9.236	19347.2