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

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

67 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
masticates	14	4	984	(None)
masticate	13	4	1128	1	masticate_
masticated	15	4	823	1	masticated
busticates	14	5	661	2	busticates
castigates	13	4	755	2	castigates
masticator	14	4	686	2	masticator
masticators	15	4	632	2	masticators
mastiches	16	4	733	2	mastic_hes
mysticetes	17	5	305	2	mysticetes
rusticates	12	4	805	2	rusticates
abdicates	14	4	816	3	_abdicates
activates	14	4	969	3	_activates
aestivates	13	10	737	3	aestivates
aspirates	11	3	961	3	_aspirates
auspicates	14	4	491	3	auspicates
bastinades	13	4	460	3	bastinades
busticate	13	5	775	3	busticate_
busticated	15	4	573	3	busticated
captivates	17	4	549	3	captivates
caseinates	12	4	744	3	caseinates
castigate	12	4	796	3	castigate_
castigated	14	4	632	3	castigated
castrates	11	3	1268	3	cast_rates
domesticates	17	5	354	3	domesticates
estimates	11	9	1136	3	_estimates
estivates	12	10	975	3	_estivates
fabricates	17	4	648	3	fabricates
fascinates	15	4	715	3	fascinates
festinates	13	4	894	3	festinates
fustigates	14	4	514	3	fustigates
instigates	11	4	842	3	instigates
machinates	17	4	732	3	machinates
manducates	15	4	559	3	manducates
manticores	14	4	575	3	manticores
marginates	13	16	875	3	marginates
marinates	11	25	1639	3	ma_rinates
massicots	13	4	384	3	massicot_s
masticating	16	4	783	3	masticating
mastication	15	6	1029	3	mastication
mastications	16	4	941	3	mastications
masticatories	17	6	221	3	masticat~~ori~~es
masticatory	18	5	458	3	masticatory
mastiche	15	4	717	3	mastic_he_
mastics	11	26	1478	3	mastic___s
mastitides	13	4	583	3	mastitides
mastitis	10	3	911	3	masti__tis
mastixes	17	3	825	3	masti__xes
masturbates	15	5	342	3	masturbates
maturates	11	3	1176	3	ma_turates
medicates	14	3	1211	3	m_edicates
metricates	14	4	912	3	metricates
mislocates	14	10	722	3	mislocates
mitigates	12	4	825	3	m_itigates
motivates	14	4	707	3	m_otivates
musicales	13	4	670	3	mus_icales
mutilates	11	3	1095	3	m_utilates
mysticete	16	5	356	3	mysticete_
passivates	15	4	496	3	passivates
pastiches	16	3	745	3	pastic_hes
pastorates	12	4	1016	3	pastorates
patinates	11	38	1470	3	pa_tinates
radicates	12	4	1207	3	ra_dicates
rusticate	11	4	903	3	rusticate_
rusticated	13	4	699	3	rusticated
satiates	8	3	1463	3	sa_ti_ates
urticates	11	4	890	3	_urticates
vesicates	14	11	903	3	ves_icates

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.406	440125.6
2	DLD Change Limit	140603	67	7.220	19474.1
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	7.656	23340.0