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

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

63 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
proactive	16	4	836	(None)
bioactive	16	4	413	2	bioactive
coactive	15	9	862	2	_coactive
practice	14	3	873	2	pr_actice
practise	12	3	1014	2	pr_actise
precative	16	3	1257	2	precative
proaction	13	4	1010	2	proaction
probative	16	4	917	2	probative
productive	18	4	551	2	productive
projective	24	4	681	2	projective
promotive	16	4	803	2	promotive
protective	17	4	842	2	protective
protractive	18	5	563	2	protractive
reactive	13	3	1047	2	_reactive
tractive	13	3	1004	2	tr_active
active	11	3	1374	3	___active
creative	13	28	1280	3	crea_tive
enactive	13	3	851	3	_enactive
erective	13	3	1183	3	er_ective
ergative	12	3	897	3	erga_tive
evocative	17	4	629	3	evocative
fricative	17	4	674	3	fricative
impactive	18	4	528	3	impactive
inactive	13	4	820	3	_inactive
locative	13	3	868	3	_locative
neuroactive	16	5	388	3	neuroactive
nonactive	14	4	897	3	nonactive
olfactive	17	4	346	3	olfactive
orective	13	3	935	3	or_ective
perfective	20	4	719	3	perfective
placative	16	4	622	3	p_lacative
portative	14	4	937	3	portative
positive	13	4	999	3	p_ositive
practic	13	3	1225	3	pr_acti_c
practiced	16	5	511	3	pr_acticed
practicer	15	4	459	3	pr_acticer
practices	15	5	799	3	pr_actices
practised	14	4	610	3	pr_actised
practises	13	4	962	3	pr_actises
preacting	14	24	1253	3	preacting
predictive	18	4	742	3	predictive
primitive	16	4	639	3	primitive
privative	17	18	829	3	privative
proactions	14	4	934	3	proactions
procaine	12	3	1227	3	pro_caine
profusive	17	4	375	3	profusive
projectile	21	4	455	3	projectile
prolactin	13	4	777	3	prolacti_n
prolactins	14	4	715	3	prolactins
propagative	19	5	450	3	propagative
proscribe	15	8	562	3	proscribe
prospective	20	5	540	3	prospective
prostie	9	16	1774	3	pro_sti_e
protractile	15	5	410	3	protractile
proustite	11	4	711	3	proustite
provocative	21	5	464	3	provocative
purgative	15	4	528	3	purga_tive
putative	13	4	837	3	puta_tive
retroactive	16	4	582	3	retroactive
rotative	11	3	1034	3	_rotative
tractile	10	3	1107	3	tr_actile
vasoactive	18	5	247	3	vasoactive
vocative	16	3	791	3	_vocative

Search took 9 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.420	425454.8
2	DLD Change Limit	148641	63	7.766	19140.0
3	Display Results	63	63	0.016	3937.5
	(SQL Overall)	178691	63	8.202	21786.3