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

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

53 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
fascinates	15	4	715	(None)
fascinate	14	4	776	1	fascinate_
fascinated	16	4	587	1	fascinated
caseinates	12	4	744	2	caseinates
fasciate	13	4	756	2	fasci_ate_
fasciated	15	4	613	2	fasci_ated
fascinator	15	4	521	2	fascinator
fascinators	16	4	470	2	fascinators
fascines	13	3	1014	2	fascin__es
festinates	13	4	894	2	festinates
lancinates	12	4	715	2	lancinates
vaccinates	17	4	656	2	vaccinates
alginates	10	3	1012	3	_alginates
ascites	9	3	1260	3	_asci__tes
aspirates	11	3	961	3	_aspirates
bastinades	13	4	460	3	bastinades
caseinate	11	4	824	3	caseinate_
castigates	13	4	755	3	castigates
fabricates	17	4	647	3	fabricates
fasciae	12	4	752	3	fasci_a_e_
fascias	12	5	841	3	fasci_a__s
fascicles	16	6	426	3	fasci_cles
fascicules	17	4	298	3	fascicules
fasciitis	14	4	354	3	fasci_itis
fascinating	17	4	525	3	fascinating
fascination	16	4	679	3	fascination
fascinations	17	4	637	3	fascinations
fascine	12	5	1058	3	fascin__e_
fascists	13	3	661	3	fasci_st_s
fascitis	13	4	601	3	fasci__tis
fascitises	15	4	474	3	fascitises
festinate	12	4	947	3	festinate_
festinated	14	4	753	3	festinated
fulminates	15	4	588	3	fulminates
fustigates	14	4	514	3	fustigates
gasconades	14	4	333	3	gasconades
laminates	11	27	1290	3	la_minates
lancinate	11	4	780	3	lancinate_
lancinated	13	4	557	3	lancinated
machinates	17	4	732	3	machinates
marginates	13	16	875	3	marginates
marinates	11	25	1639	3	ma_rinates
masticates	14	4	984	3	masticates
paginates	12	31	1137	3	pa_ginates
passivates	15	4	496	3	passivates
patinates	11	38	1470	3	pa_tinates
rabbinates	14	4	451	3	rabbinates
raffinates	16	4	436	3	raffinates
resinates	9	3	1476	3	res_inates
succinates	14	4	563	3	succinates
vaccinate	16	4	683	3	vaccinate_
vaccinated	18	5	544	3	vaccinated
vaticinates	16	4	392	3	vaticinates

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	140603	0.406	440125.6
2	DLD Change Limit	140603	53	5.670	24797.7
3	Display Results	53	53	0.033	1606.1
	(SQL Overall)	178691	53	6.109	29250.5