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

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

33 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
mandarinates	15	5	265	(None)
mandarinate	14	5	313	1	mandarinate_
mandarinisms	17	7	264	3	mandarinisms
mandarins	12	4	1040	3	mandarin___s
manganates	13	4	595	3	manga__nates
marinates	11	25	1639	3	m___arinates
andantes	9	3	1085	4	_anda__n_tes
candidates	14	4	630	4	cand__idates
contaminates	16	5	631	4	contaminates
fanfaronades	19	8	66	4	fanfaronades
handprints	16	4	397	4	handprin_t_s
handwrites	17	4	475	4	handwri__tes
incarnates	12	4	671	4	_incar_nates
invaginates	15	4	484	4	_invaginates
lancinates	12	4	715	4	lan__cinates
machinates	17	4	732	4	ma__chinates
mandarin	11	4	1102	4	mandarin____
mandarinic	15	5	326	4	mandarin__ic
mandarinism	16	5	330	4	mandarin_ism
mandates	11	3	1409	4	mand____ates
mandolines	13	4	710	4	mandolin__es
mandrakes	16	4	635	4	mand_r__akes
manducates	15	4	559	4	mand__ucates
manganate	12	4	640	4	manga__nate_
manganites	13	4	703	4	manga__nites
margarines	13	4	720	4	margarin__es
margarites	13	4	653	4	margari__tes
marginates	13	16	875	4	ma__rginates
marinades	12	26	898	4	m___arinades
marinate	10	30	1778	4	m___arinate_
marinated	12	25	1317	4	m___arinated
palatinates	13	4	501	4	pa_latinates
vanadiates	14	4	374	4	van_adi_ates

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	124790	0.423	422437.4
2	DLD Change Limit	124790	33	7.610	16398.2
3	Display Results	33	33	0.030	1100.0
	(SQL Overall)	178691	33	8.063	22161.9