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

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

20 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
plumpens	14	30	495	(None)
lumpens	11	29	826	1	_lumpens
plumpen	13	27	640	1	plumpen_
plumpers	14	35	729	1	plumpers
lumens	8	50	1397	2	_lum_ens
lumpen	10	40	1066	2	_lumpen_
lumpers	11	35	1448	2	_lumpers
playpens	15	3	407	2	playpens
plumbers	14	41	851	2	plumbers
plumes	10	43	1813	2	plum_e_s
plumipeds	16	4	166	2	plumipeds
plummets	14	30	477	2	plummets
plumped	14	31	864	2	plumpe_d
plumpened	16	4	254	2	plumpened
plumper	13	31	877	2	plumpe_r
plumpest	14	23	635	2	plumpest
plumping	15	27	763	2	plumping
plumpness	15	4	347	2	plumpness
plumps	12	46	1261	2	plump__s
pumpers	13	31	1367	2	p_umpers

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	121059	0.406	440125.6
2	DLD Change Limit	121059	20	3.266	37066.4
3	Display Results	20	20	0.013	1538.5
	(SQL Overall)	178691	20	3.685	48491.5