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

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

86 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
infective	17	10	897	(None)
inflective	18	12	657	1	inflective
injective	21	7	802	1	injective
invective	17	9	804	1	invective
affective	20	13	541	2	affective
defective	18	4	800	2	defective
effective	20	7	619	2	effective
inactive	13	4	820	2	in_active
incentive	14	8	960	2	incentive
inceptive	16	7	782	2	inceptive
inductive	15	4	726	2	inductive
ineffective	22	7	394	2	ineffective
infecting	15	10	967	2	infecting
infection	14	4	1047	2	infection
infertile	12	4	867	2	infertile
inflictive	18	10	463	2	inflictive
ingestive	13	4	739	2	ingestive
insectile	11	4	711	2	insectile
inspective	17	4	640	2	inspective
invectives	18	8	590	2	invectives
inventive	15	8	804	2	inventive
refective	17	4	911	2	refective
adjective	22	4	481	3	adjective
advective	18	4	523	3	advective
bijective	23	4	391	3	bijective
connective	17	4	925	3	connective
convective	20	4	911	3	convective
defectives	19	4	568	3	defectives
deflective	19	5	609	3	deflective
detective	15	4	810	3	detective
directive	15	5	777	3	directive
effectives	21	13	456	3	effectives
ejective	20	3	715	3	_ejective
elective	13	3	1100	3	_elective
enactive	13	3	851	3	en_active
erective	13	3	1183	3	_erective
festive	13	3	977	3	__festive
fictive	15	3	702	3	__fictive
ideative	12	3	857	3	i_deative
impactive	18	4	528	3	impactive
incentives	15	7	804	3	incentives
inceptives	17	7	579	3	inceptives
indecisive	16	5	334	3	indecisive
indicative	16	4	771	3	indicative
inductile	12	4	612	3	inductile
inertiae	8	4	1147	3	in_ertiae
infantile	12	4	541	3	infantile
infantine	12	4	714	3	infantine
infect	11	34	1344	3	infect___
infectant	14	4	683	3	infectant
infected	14	22	940	3	infect_ed
infecter	13	22	915	3	infect_er
infecters	14	25	758	3	infecters
infections	15	5	1023	3	infections
infectious	15	4	560	3	infectious
infectivity	22	5	470	3	infectivity
infector	13	47	885	3	infect_or
infectors	14	21	855	3	infectors
infects	12	27	971	3	infect__s
infesting	13	10	951	3	infesting
infinitive	16	4	534	3	infinitive
inflecting	16	4	631	3	inflecting
inflection	15	4	763	3	inflection
infusive	14	4	517	3	inf_usive
injecting	19	9	769	3	injecting
injection	18	3	865	3	injection
injunctive	22	5	403	3	injunctive
insectivore	16	13	196	3	insectivore
intensive	12	4	840	3	intensive
interactive	16	5	963	3	interactive
intertie	8	3	1761	3	interti_e
intestine	9	4	1185	3	intestine
intuitive	12	4	616	3	intuitive
invectively	22	5	518	3	invectively
inversive	15	5	719	3	inversive
noninfective	20	5	458	3	~~non~~infective
objective	23	4	537	3	objective
olfactive	17	4	346	3	olfactive
orective	13	3	935	3	_orective
perfective	20	4	719	3	perfective
reflective	18	5	712	3	reflective
rejective	21	4	825	3	rejective
selective	14	4	952	3	selective
undeceive	15	4	477	3	undeceive
unfertile	12	4	641	3	unfertile
vindictive	19	4	354	3	vindictive

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	86	6.576	22603.6
3	Display Results	86	86	0.046	1869.6
	(SQL Overall)	178691	86	7.045	25364.2