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

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

71 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
optative	13	4	765	(None)
optatives	14	4	520	1	optatives
hortative	15	4	643	2	hortative
mutative	13	4	828	2	mutative
operative	14	11	1055	2	operative
optatively	18	6	464	2	optatively
portative	14	4	937	2	portative
putative	13	4	837	2	putative
rotative	11	3	1034	2	rotative
stative	10	26	1293	2	_stative
ablative	13	4	824	3	ablative
agitative	13	4	687	3	agitative
amative	12	3	1173	3	_amative
apatite	9	3	1296	3	ap_atite
astatine	8	3	1353	3	astatine
cogitative	16	4	593	3	cogitative
combative	18	4	721	3	combative
conative	13	12	1462	3	conative
constative	15	4	1010	3	constative
copulative	17	4	729	3	copulative
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
ergative	12	3	897	3	ergative
fixative	21	4	508	3	fixative
formative	17	4	796	3	formative
gestative	13	4	730	3	gestative
gustative	13	4	568	3	gustative
ideative	12	3	857	3	ideative
illative	11	4	718	3	illative
imitative	14	4	633	3	imitative
imputative	17	4	448	3	imputative
laxative	18	4	509	3	laxative
ligative	12	5	880	3	ligative
locative	13	3	868	3	locative
native	9	6	1301	3	__native
negative	12	3	908	3	negative
nonnative	12	4	834	3	nonnative
normative	14	4	889	3	normative
octave	11	15	734	3	octa__ve
olfactive	17	4	346	3	olfactive
opaline	9	4	1248	3	op_aline
operatives	15	11	788	3	operatives
opiate	8	5	1346	3	opiat__e
opiating	11	4	1009	3	opiating
optime	10	7	935	3	op__time
optimise	12	5	558	3	optimise
optimize	21	4	550	3	optimize
orective	13	3	935	3	orective
outate	6	29	2340	3	outat__e
outdrive	12	3	689	3	outdrive
outgive	11	19	925	3	out_give
outlive	10	25	1303	3	out_live
outstrive	12	6	508	3	outstrive
oxidative	20	4	431	3	oxidative
patine	8	53	2812	3	_p_atine
pattie	8	40	2096	3	_patti_e
positive	13	4	999	3	positive
potation	10	17	1678	3	potation
relative	11	3	1314	3	relative
sanative	11	3	1047	3	sanative
sedative	12	3	885	3	sedative
sportive	13	4	833	3	sportive
statice	9	26	1403	3	_statice
statives	11	27	1079	3	_statives
tentative	12	4	781	3	tentative
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.436	409841.7
2	DLD Change Limit	146162	71	7.313	19986.6
3	Display Results	71	71	0.030	2366.7
	(SQL Overall)	178691	71	7.779	22970.9