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

Here are the results of your fuzzy-string dictionary search for “presumptive” with Change Limit: [1] [2] [3] [4] [5]

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.

58 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
presumptive	20	6	306	(None)
preemptive	19	4	414	2	pre_emptive
presumption	17	15	417	2	presumption
presumptively	25	9	222	2	presumptively
assumptive	17	5	220	3	_assumptive
consumptive	20	5	422	3	consumptive
preadaptive	19	5	291	3	preadaptive
preceptive	19	4	776	3	pre_ceptive
prescriptive	21	5	323	3	prescriptive
presumptions	18	15	388	3	presumptions
redemptive	18	5	330	3	_redemptive
resorptive	15	4	476	3	_resorptive
resumption	14	12	473	3	_resumption
consumptives	21	5	311	4	consumptives
eruptive	13	4	579	4	__eru_ptive
exemptive	23	4	383	4	__exemptive
irruptive	14	4	343	4	ir_ru_ptive
perceptive	19	4	680	4	p_erceptive
persecutive	18	5	393	4	persecutive
personative	16	4	707	4	personative
perspective	20	5	486	4	perspective
persuasive	15	5	368	4	persu_asive
precative	16	3	1257	4	pre__cative
predicative	19	4	737	4	predicative
predictive	18	4	742	4	pre_dictive
preempting	17	4	539	4	pre_empting
preemption	16	10	525	4	pre_emption
preemptively	24	5	295	4	pre_emptively
prelusive	14	5	558	4	prelu__sive
prenuptial	14	5	339	4	prenu_ptial
preparative	18	4	635	4	preparative
prepositive	18	5	520	4	prepositive
prerogative	17	5	535	4	prerogative
presentative	17	5	534	4	presentative
preservative	20	5	395	4	preservative
prestige	11	3	1073	4	pres___tige
presumable	16	4	520	4	presum_able
presume	11	3	1030	4	presum____e
presuming	14	3	766	4	presum__ing
presummit	15	5	313	4	presum_mi_t
presummits	16	5	234	4	presum_mits
presumptuous	18	7	95	4	presumptuous
presuppose	13	8	243	4	presu_ppose
preventive	18	4	754	4	pre_ventive
primitive	16	4	639	4	pr__imitive
productive	18	4	551	4	produ_ctive
promotive	16	4	803	4	pr__omotive
proscriptive	21	5	287	4	proscriptive
prospective	20	5	540	4	prospective
receptive	16	4	832	4	_re_ceptive
reductive	15	4	779	4	_redu_ctive
regulative	14	4	698	4	_regulative
resentive	12	4	1072	4	_res_entive
resistive	12	4	758	4	_res_istive
respective	17	4	762	4	_respective
restive	10	3	1593	4	_res___tive
resumptions	15	15	459	4	_resumptions
resupine	10	3	754	4	_resu_p_ine

Search took 10 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	148819	0.406	440125.6
2	DLD Change Limit	148819	58	9.016	16506.1
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	9.452	18905.1