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

Here are the results of your fuzzy-string dictionary search for “advective” 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
advective	18	4	523	(None)
adjective	22	4	481	1	adjective
adventive	16	4	581	1	adventive
addictive	16	4	456	2	addictive
adductive	16	4	396	2	adductive
adjectives	23	4	373	2	adjectives
advecting	16	4	511	2	advecting
advection	15	4	555	2	advection
adventives	17	4	512	2	adventives
advertise	13	4	610	2	advertise
advertize	22	4	538	2	advertize
advocative	19	4	396	2	advocative
affective	20	13	541	2	affective
invective	17	9	804	2	invective
acceptive	18	4	507	3	acceptive
active	11	3	1374	3	a___ctive
adaptive	14	4	513	3	ad_aptive
additive	13	4	586	3	ad_ditive
adhesive	15	4	380	3	adhe_sive
adjectival	23	5	183	3	adjectival
adjectively	27	5	363	3	adjectively
adjunctive	23	5	257	3	adjunctive
adjustive	20	4	324	3	adjustive
adoptive	14	4	550	3	ad_optive
advect	12	30	912	3	advect___
advected	15	3	453	3	advect_ed
advections	16	4	555	3	advections
advects	13	27	601	3	advect__s
adventure	13	4	439	3	adventure
adversative	18	5	324	3	adversative
adverting	14	3	722	3	adverting
advertised	15	4	409	3	advertised
advertiser	14	4	361	3	advertiser
advertises	14	4	591	3	advertises
advertized	24	4	379	3	advertized
advertizes	23	4	467	3	advertizes
agentive	12	4	804	3	a_gentive
arrestive	12	4	675	3	arrestive
assentive	12	4	574	3	assentive
assertive	12	4	647	3	assertive
attentive	12	4	585	3	attentive
aversive	14	4	744	3	a_versive
bijective	23	4	391	3	bijective
convective	20	4	911	3	convective
deceive	13	3	781	3	_d_eceive
defective	18	4	800	3	defective
detective	15	4	810	3	detective
directive	15	5	777	3	directive
eductive	14	7	686	3	ed_uctive
effective	20	7	619	3	effective
ejective	20	3	715	3	_ejective
elective	13	3	1100	3	_elective
erective	13	3	1183	3	_erective
ideative	12	3	857	3	id_eative
infective	17	10	897	3	infective
injective	21	7	802	3	injective
invectives	18	8	590	3	invectives
inventive	15	8	804	3	inventive
objective	23	4	537	3	objective
orective	13	3	935	3	_orective
refective	17	4	911	3	refective
rejective	21	4	825	3	rejective
revertive	15	4	885	3	revertive
selective	14	4	952	3	selective

Search took 8 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	6.810	21826.9
3	Display Results	64	64	0.033	1939.4
	(SQL Overall)	178691	64	7.266	24592.8