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

Here are the results of your fuzzy-string dictionary search for “primate” with Change Limit: [1] [2] [3]

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.

40 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
primate	11	15	1628	(None)
primage	12	16	914	1	primage
primates	12	15	1593	1	primates
private	12	15	1326	1	private
animate	9	16	1721	2	animate
bromate	11	3	1355	2	bromate
climate	11	3	1283	2	climate
cremate	11	38	1618	2	cremate
frigate	11	3	1106	2	frigate
grimace	12	5	508	2	grimace
palmate	11	32	1523	2	palmate
pirate	8	23	2288	2	p_irate
plicate	11	3	1451	2	plicate
plumate	11	4	980	2	plumate
prate	7	51	3598	2	pr__ate
predate	10	6	1689	2	predate
prelate	9	5	1969	2	prelate
premade	12	3	1144	2	premade
prima	9	50	1934	2	prima__
primacy	16	3	560	2	primacy
primages	13	15	927	2	primages
primal	10	40	1462	2	prima_l
primary	14	3	770	2	primary
primas	10	44	1810	2	prima_s
primatal	12	4	713	2	primatal
prime	9	65	2560	2	prim__e
primine	11	32	1482	2	primine
primsie	11	3	754	2	primsie
priorate	10	4	1173	2	priorate
privater	13	15	853	2	privater
privates	13	18	1237	2	privates
probate	11	4	1448	2	probate
prolate	9	4	1979	2	prolate
promote	11	3	1314	2	promote
pronate	9	4	1887	2	pronate
prorate	9	4	1873	2	prorate
proximate	20	4	577	2	proximate
ramate	8	39	2169	2	_ramate
remate	8	44	2868	2	_remate
urinate	7	3	1536	2	urinate

Search took 4 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	107671	0.390	458182.1
2	DLD Change Limit	107671	40	3.483	30913.3
3	Display Results	40	40	0.016	2500.0
	(SQL Overall)	178691	40	3.889	45947.8