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

Here are the results of your fuzzy-string dictionary search for “negative” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

110 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
negative	12	3	908	(None)
negatived	14	4	433	1	negatived
negatives	13	4	658	1	negatives
elative	10	3	1245	2	_elative
ergative	12	3	897	2	ergative
legatine	9	13	1140	2	legatine
ligative	12	5	880	2	ligative
native	9	6	1301	2	n__ative
negate	7	29	1557	2	negat__e
negating	10	20	1283	2	negating
negation	9	29	1302	2	negation
negatively	17	4	557	2	negatively
relative	11	3	1314	2	relative
sedative	12	3	885	2	sedative
vegetive	15	4	554	2	vegetive
ablative	13	4	824	3	ablative
agatize	17	3	983	3	_agatize
agentive	12	4	804	3	agentive
amative	12	3	1173	3	_amative
conative	13	12	1462	3	conative
creative	13	28	1280	3	creative
curative	13	3	1040	3	curative
dative	10	3	1181	3	__dative
denotive	12	3	867	3	denotive
derogative	15	4	698	3	derogative
deviative	16	4	772	3	deviative
dilative	12	3	952	3	dilative
donative	12	13	987	3	donative
durative	12	3	907	3	durative
egalite	8	3	1156	3	_egalite
egestive	12	4	683	3	_egestive
elatives	11	3	978	3	_elatives
emotive	12	3	919	3	_emotive
enactive	13	3	851	3	enactive
ergatives	13	4	644	3	ergatives
evasive	13	4	466	3	_evasive
exaptive	20	4	525	3	_exaptive
festive	13	3	977	3	fe_stive
fixative	21	4	508	3	fixative
fugitive	15	4	417	3	fugitive
gelatine	9	32	1331	3	gelatine
generative	14	5	856	3	generative
genitive	12	4	764	3	genitive
gestative	13	4	730	3	gestative
hematine	13	16	1467	3	hematine
hematite	13	16	1215	3	hematite
hepatize	22	4	823	3	hepatize
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
ingestive	13	4	739	3	ingestive
integrative	15	4	712	3	integrative
iterative	12	4	1071	3	iterative
laxative	18	4	509	3	laxative
legalise	9	4	949	3	legalise
legalize	18	3	910	3	legalize
legate	7	29	1745	3	legat__e
legatee	8	28	1463	3	legat_ee
legating	10	23	1311	3	legating
legation	9	24	1293	3	legation
lenitive	11	4	849	3	lenitive
locative	13	3	868	3	locative
mediative	15	4	812	3	mediative
mutative	13	4	828	3	mutative
naive	8	51	1621	3	n__a_ive
narrative	12	4	737	3	narrative
natives	10	3	1082	3	n__atives
necktie	13	4	436	3	neckti_e
negated	9	34	1323	3	negat_ed
negater	8	37	1196	3	negat_er
negaters	9	34	978	3	negaters
negates	8	32	1584	3	negat_es
negations	10	28	1196	3	negations
negativing	15	4	361	3	negativing
negativism	16	5	361	3	negativism
negativist	14	5	453	3	negativist
negativity	17	5	423	3	negativity
negaton	8	29	914	3	negat_on
negatons	9	29	927	3	negatons
negator	8	30	1067	3	negat_or
negators	9	24	1117	3	negators
negatron	9	33	599	3	negatron
neglige	9	3	487	3	neg_lige
negotiate	10	4	553	3	negotiate
nematic	11	17	1400	3	nemati_c
nematode	11	5	516	3	nematode
nightie	11	7	965	3	nighti_e
nonactive	14	4	897	3	nonactive
nonnative	12	4	834	3	nonnative
nonnegative	15	5	517	3	~~non~~negative
normative	14	4	889	3	normative
operative	14	11	1055	3	operative
optative	13	4	765	3	optative
pegmatite	14	4	572	3	pegmatite
precative	16	3	1257	3	precative
purgative	15	4	528	3	purgative
putative	13	4	837	3	putative
reactive	13	3	1047	3	reactive
regave	10	47	1338	3	rega__ve
regive	10	48	1432	3	reg__ive
regulative	14	4	698	3	regulative
relatives	12	3	996	3	relatives
restive	10	3	1593	3	re_stive
rotative	11	3	1034	3	rotative
sanative	11	3	1047	3	sanative
sedatives	13	4	615	3	sedatives
stative	10	26	1293	3	_stative
teatime	9	3	1008	3	te_atime
tentative	12	4	781	3	tentative
vegetative	17	4	457	3	vegetative
vocative	16	3	791	3	vocative

Search took 9 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	110	7.610	19206.6
3	Display Results	110	110	0.046	2391.3
	(SQL Overall)	178691	110	8.062	22164.6