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

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

62 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
formatives	18	4	621	(None)
formative	17	4	796	1	formative_
formalises	15	25	899	2	formalises
formalizes	24	27	1007	2	formalizes
formamides	18	4	387	2	formamides
formates	13	28	1429	2	format__es
formations	15	3	820	2	formations
formatively	22	5	452	2	formatively
normative	14	4	889	2	normative_
affirmatives	23	5	215	3	affirmatives
aromatizes	21	5	919	3	aromatizes
calmatives	17	4	473	3	calmatives
creatives	14	27	969	3	_creatives
curatives	14	3	782	3	cur_atives
deformative	20	4	497	3	deformative_
dogmatizes	23	6	549	3	dogmatizes
donatives	13	14	690	3	do_natives
duratives	13	4	622	3	dur_atives
ergatives	13	4	644	3	_ergatives
farmwives	20	4	178	3	farm_wives
fixatives	22	4	335	3	f_ixatives
foretimes	14	4	746	3	for_etimes
forgetive	16	12	446	3	forgetive_
forgives	15	3	575	3	for__gives
formalins	14	4	721	3	formali_ns
formalise	14	23	978	3	formalise_
formalised	16	26	666	3	formalised
formalisms	17	22	724	3	formalisms
formalists	15	21	762	3	formalists
formalities	16	13	782	3	formalities
formalize	23	27	1003	3	formalize_
formalized	25	26	893	3	formalized
formalizer	24	25	787	3	formalizer
formalizers	25	25	538	3	formalizers
formamide	17	4	440	3	formamide_
formate	12	31	1509	3	format__e_
formation	14	3	942	3	formati_on
formats	12	31	1357	3	format___s
formatted	15	4	488	3	format_ted
formatter	14	4	546	3	format_ter
formatters	15	4	457	3	formatters
formulizes	24	25	542	3	formulizes
fortalices	15	4	551	3	fortalices
forties	10	43	2386	3	for__ti_es
fricatives	18	4	469	3	fricatives
furmeties	14	4	658	3	furmeti_es
furmities	14	4	754	3	furmiti_es
hortative	15	4	643	3	hortative_
informative	19	6	515	3	informative_
locatives	14	4	656	3	lo_catives
narratives	13	4	479	3	narratives
nonnatives	13	4	564	3	nonnatives
normalises	12	22	850	3	normalises
normalizes	21	25	964	3	normalizes
normatively	19	5	463	3	normatively
optatives	14	4	520	3	_optatives
performatives	23	9	268	3	~~per~~formatives
portative	14	4	937	3	portative_
purgatives	16	4	374	3	purgatives
reformative	19	4	567	3	reformative_
vocatives	17	4	588	3	vo_catives
vomitives	17	4	461	3	vo_mitives

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	140603	0.453	394461.4
2	DLD Change Limit	140603	62	6.906	20359.5
3	Display Results	62	62	0.030	2066.7
	(SQL Overall)	178691	62	7.389	24183.4