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

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

57 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
optatives	14	4	520	(None)
optative	13	4	765	1	optative_
operatives	15	11	788	2	operatives
optatively	18	6	464	2	optatively
statives	11	27	1079	2	_statives
ablatives	14	4	550	3	ablatives
apatites	10	3	1129	3	ap_atites
astatines	9	3	1034	3	astatines
constatives	16	4	693	3	constatives
copulatives	18	4	487	3	copulatives
creatives	14	27	969	3	creatives
curatives	14	3	782	3	curatives
datives	11	3	1007	3	__datives
donatives	13	14	690	3	donatives
duratives	13	4	622	3	duratives
elatives	11	3	978	3	_elatives
ergatives	13	4	644	3	ergatives
fixatives	22	4	335	3	fixatives
formatives	18	4	621	3	formatives
hortative	15	4	643	3	hortative_
illatives	12	4	552	3	illatives
laxatives	19	4	335	3	laxatives
locatives	14	4	656	3	locatives
mutative	13	4	828	3	mutative_
natives	10	3	1082	3	__natives
negatives	13	4	658	3	negatives
nonnatives	13	4	564	3	nonnatives
octaves	12	31	696	3	octa__ves
ofttimes	13	4	312	3	oft_times
opalines	10	3	1142	3	op_alines
operative	14	11	1055	3	operative_
opiates	9	3	1214	3	opiat__es
optimes	11	4	847	3	op__times
optimises	13	4	608	3	optimises
optimizes	22	4	542	3	optimizes
otitides	9	3	729	3	o_titides
otitises	8	3	916	3	o_titises
outdrives	13	4	670	3	outdrives
outgives	12	21	862	3	out_gives
outlives	11	25	1176	3	out_lives
outstrives	13	7	425	3	outstrives
patines	9	52	2576	3	_p_atines
patties	9	34	2514	3	_patti_es
platies	9	37	2254	3	_plati_es
portative	14	4	937	3	portative_
positives	14	5	917	3	positives
potations	11	16	1507	3	potations
potatoes	10	3	994	3	potat_oes
potties	9	37	2354	3	pot_ti_es
putative	13	4	837	3	putative_
relatives	12	3	996	3	relatives
rotative	11	3	1034	3	rotative_
sedatives	13	4	615	3	sedatives
statices	10	27	1234	3	_statices
stative	10	26	1293	3	_stative_
tentatives	13	4	548	3	tentatives
vocatives	17	4	588	3	vocatives

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	57	7.046	21095.8
3	Display Results	57	57	0.033	1727.3
	(SQL Overall)	178691	57	7.502	23819.1