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

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

48 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
agitative	13	4	687	(None)
agitate	8	3	1206	2	agitat__e
agitating	11	3	886	2	agitating
agitation	10	3	1122	2	agitation
cogitative	16	4	593	2	cogitative
imitative	14	4	633	2	imitative
ablative	13	4	824	3	a_blative
agatize	17	3	983	3	ag__atize
agentive	12	4	804	3	ag_entive
agitable	11	3	858	3	agita_ble
agitated	10	3	841	3	agitat_ed
agitates	9	3	1088	3	agitat_es
agitations	11	3	1006	3	agitations
agitato	8	5	657	3	agitat__o
agitator	9	4	671	3	agitat_or
agitators	10	4	662	3	agitators
amative	12	3	1173	3	a__mative
annotative	13	4	503	3	annotative
arbitrative	16	5	426	3	arbitrative
astatine	8	3	1353	3	a_statine
dilative	12	3	952	3	_dilative
excitative	22	4	502	3	excitative
fixative	21	4	508	3	_fixative
fricative	17	4	674	3	fricative
gestative	13	4	730	3	gestative
gravitative	18	5	297	3	gravitative
gustative	13	4	568	3	gustative
hortative	15	4	643	3	hortative
imaginative	17	5	384	3	imaginative
initiative	13	4	690	3	initiative
irritative	13	4	520	3	irritative
ligative	12	5	880	3	_ligative
limitative	15	4	469	3	limitative
meditative	16	4	628	3	meditative
mutative	13	4	828	3	_mutative
optative	13	4	765	3	_optative
oxidative	20	4	431	3	oxidative
portative	14	4	937	3	portative
privative	17	18	829	3	privative
putative	13	4	837	3	_putative
qualitative	23	5	319	3	qualitative
radiative	13	4	817	3	radi_ative
recitative	15	4	818	3	recitative
rotative	11	3	1034	3	_rotative
stative	10	26	1293	3	__stative
tentative	12	4	781	3	tentative
urinative	12	4	765	3	urinative
vegetative	17	4	457	3	vegetative

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	48	7.453	19943.8
3	Display Results	48	48	0.030	1600.0
	(SQL Overall)	178691	48	7.906	22601.9