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

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

65 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
laxative	18	4	509	(None)
laxatives	19	4	335	1	laxatives
amative	12	3	1173	2	_amative
fixative	21	4	508	2	fixative
laudative	13	4	475	2	laudative
laxation	15	3	842	2	laxation
ligative	12	5	880	2	ligative
locative	13	3	868	2	locative
placative	16	4	622	2	placative
sanative	11	3	1047	2	sanative
saxatile	15	4	495	2	saxatile
ablative	13	4	824	3	ablative
active	11	3	1374	3	_a_ctive
adaptive	14	4	513	3	_adaptive
agatize	17	3	983	3	_agatize
apatite	9	3	1296	3	_apatite
calmative	16	4	703	3	calmative
captive	14	3	897	3	ca_ptive
causative	14	4	583	3	causative
cavatine	13	3	1032	3	cavatine
conative	13	12	1462	3	conative
creative	13	28	1280	3	creative
curative	13	3	1040	3	curative
dative	10	3	1181	3	__dative
dilative	12	3	952	3	dilative
donative	12	13	987	3	donative
durative	12	3	907	3	durative
elative	10	3	1245	3	_elative
emanative	14	4	731	3	emanative
ergative	12	3	897	3	ergative
exaptive	20	4	525	3	exaptive
fixatives	22	4	335	3	fixatives
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
lacerative	15	5	628	3	lacerative
lanate	6	4	2126	3	lanat__e
lattice	9	3	843	3	la_ttice
lavalike	15	3	628	3	lavalike
lavation	11	3	997	3	lavation
laxations	16	3	762	3	laxations
laxities	15	3	909	3	laxities
legatine	9	13	1140	3	legatine
lenitive	11	4	849	3	lenitive
locatives	14	4	656	3	locatives
lucrative	14	4	586	3	lucrative
luxate	13	3	808	3	luxat__e
luxating	16	4	561	3	luxating
luxation	15	3	823	3	luxation
mutative	13	4	828	3	mutative
narrative	12	4	737	3	narrative
native	9	6	1301	3	__native
negative	12	3	908	3	negative
optative	13	4	765	3	optative
palatine	10	3	1607	3	palatine
plaintive	14	4	462	3	plaintive
putative	13	4	837	3	putative
radiative	13	4	817	3	radiative
relative	11	3	1314	3	relative
rotative	11	3	1034	3	rotative
sedative	12	3	885	3	sedative
stative	10	26	1293	3	_stative
talkative	16	4	430	3	talkative
taxation	15	3	799	3	taxation
vocative	16	3	791	3	vocative
zaratite	17	4	779	3	zaratite

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.656	272394.8
2	DLD Change Limit	146162	65	7.783	18779.6
3	Display Results	65	65	0.030	2166.7
	(SQL Overall)	178691	65	8.469	21099.4