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

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

56 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
protonate	11	4	1257	(None)
protonated	13	4	859	1	protonated
protonates	12	4	1169	1	protonates
pronate	9	4	1887	2	pr__onate
propionate	14	4	643	2	propionate
prorogate	12	4	769	2	prorogate
brominate	13	4	885	3	brominate
coronate	10	30	1821	3	_coronate
detonate	9	3	1119	3	_detonate
fortunate	12	4	545	3	fortunate
intonate	8	3	1092	3	_intonate
odonate	8	4	840	3	__odonate
ozonate	16	4	686	3	__ozonate
pastorate	11	4	1117	3	pastorate
patinate	10	30	1631	3	p_atinate
pectinate	13	4	955	3	pectinate
personate	11	21	1142	3	personate
phonate	12	4	1181	3	p__honate
potentate	11	9	725	3	p_otentate
prelocate	13	10	951	3	prelocate
priorate	10	4	1173	3	pr_iorate
probate	11	4	1448	3	pr__obate
procreate	13	4	813	3	procreate
prolate	9	4	1979	3	pr__olate
prolonge	11	38	840	3	prolon_ge
promenade	14	8	569	3	promenade
promote	11	3	1314	3	promo__te
pronated	11	4	1405	3	pr__onated
pronates	10	4	1837	3	pr__onates
propagate	14	4	612	3	propagate
propionates	15	4	553	3	propionates
propone	11	27	1630	3	propon__e
prorate	9	4	1873	3	pr__orate
prorogated	14	4	572	3	prorogated
prorogates	13	4	731	3	prorogates
prosomata	13	4	674	3	prosomata
prostate	10	3	1453	3	pro_state
prostrate	11	4	1248	3	prostrate
protease	10	20	989	3	prot_ease
proteinase	12	4	453	3	proteinase
proton	8	43	1889	3	proton___
protonating	14	4	859	3	protonating
protonation	13	5	1043	3	protonation
protonema	13	4	541	3	protonema
protonemata	15	5	306	3	protonemata
protonic	12	3	1459	3	proton_ic
protons	9	31	1800	3	proton__s
protostar	11	4	669	3	protostar
prototype	16	4	566	3	prototype
protoxide	19	4	682	3	protoxide
protrade	11	4	821	3	prot_rade
proximate	20	4	577	3	proximate
pulmonate	13	4	476	3	pulmonate
resonate	8	5	1351	3	_resonate
rotate	6	33	2034	3	_rot__ate
stolonate	9	4	482	3	stolonate

Search took 7 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.436	409841.7
2	DLD Change Limit	148641	56	6.486	22917.2
3	Display Results	56	56	0.030	1866.7
	(SQL Overall)	178691	56	6.952	25703.5