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

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

90 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
inactive	13	4	820	(None)
enactive	13	3	851	1	enactive
active	11	3	1374	2	__active
bioactive	16	4	413	2	bioactive
coactive	15	9	862	2	coactive
impactive	18	4	528	2	impactive
inaction	10	3	962	2	inaction
inactivate	15	4	569	2	inactivate
inactively	18	4	531	2	inactively
inductive	15	4	726	2	inductive
infective	17	10	897	2	infective
injective	21	7	802	2	injective
invective	17	9	804	2	invective
native	9	6	1301	2	_na_tive
nonactive	14	4	897	2	nonactive
reactive	13	3	1047	2	reactive
tractive	13	3	1004	2	tractive
actives	12	3	1152	3	__actives
adaptive	14	4	513	3	adaptive
amative	12	3	1173	3	ama_tive
bijective	23	4	391	3	bijective
captive	14	3	897	3	_captive
conative	13	12	1462	3	cona_tive
dative	10	3	1181	3	_da_tive
dilative	12	3	952	3	dila_tive
directive	15	5	777	3	directive
donative	12	13	987	3	dona_tive
eductive	14	7	686	3	eductive
ejective	20	3	715	3	ejective
elative	10	3	1245	3	ela_tive
elective	13	3	1100	3	elective
enacting	11	3	1136	3	enacting
erective	13	3	1183	3	erective
exaptive	20	4	525	3	exaptive
fictive	15	3	702	3	_fictive
fixative	21	4	508	3	fixa_tive
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
inactions	11	3	932	3	inactions
inactivated	17	4	455	3	inactivated
inactivates	16	4	504	3	inactivates
inactivity	18	5	470	3	inactivity
incentive	14	8	960	3	incentive
inceptive	16	7	784	3	inceptive
incise	8	35	1533	3	in_c_ise
incisive	13	4	628	3	incisive
incite	8	36	1873	3	in_c_ite
incline	9	3	1464	3	in_cline
incurve	12	3	663	3	in_curve
indicative	16	4	771	3	indicative
inductile	12	4	612	3	inductile
inertiae	8	4	1147	3	inertiae
infantile	12	4	541	3	infantile
infantine	12	4	714	3	infantine
inflective	18	12	657	3	inflective
inflictive	18	10	463	3	inflictive
infusive	14	4	518	3	infusive
ingestive	13	4	739	3	ingestive
injunctive	22	5	403	3	injunctive
inscribe	12	4	569	3	inscribe
insectile	11	4	711	3	insectile
inspective	17	4	641	3	inspective
interactive	16	5	963	3	in~~ter~~active
intime	8	10	1427	3	in__time
intine	6	10	2198	3	in__tine
intuitive	12	4	616	3	intuitive
inutile	7	3	988	3	in_utile
invasive	14	4	483	3	invasive
invectives	18	8	591	3	invectives
inventive	15	8	804	3	inventive
isatine	7	3	1176	3	isa_tine
ligative	12	5	880	3	liga_tive
locative	13	3	868	3	locative
naive	8	51	1621	3	_na__ive
natives	10	3	1082	3	_na_tives
olfactive	17	4	346	3	olfactive
orective	13	3	935	3	orective
placative	16	4	622	3	placative
practice	14	3	873	3	practice
practise	12	3	1014	3	practise
proactive	16	4	836	3	proactive
sanative	11	3	1047	3	sanative
siccative	16	4	510	3	siccative
stative	10	26	1293	3	sta_tive
tactile	9	3	1061	3	_tactile
tractile	10	3	1107	3	tractile
unitive	10	3	1056	3	un_itive
urinative	12	4	765	3	urina_tive
vindictive	19	4	354	3	vindictive
vocative	16	3	791	3	vocative

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	146162	0.406	440125.6
2	DLD Change Limit	146162	90	7.250	20160.3
3	Display Results	90	90	0.033	2727.3
	(SQL Overall)	178691	90	7.689	23239.8