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

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

64 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
sharpener	14	4	458	(None)
sharpened	15	4	448	1	sharpened
sharpeners	15	4	389	1	sharpeners
hardener	12	3	888	2	_hardener
harkener	15	3	757	2	_harkener
sharpen	12	38	972	2	sharpen__
sharpens	13	37	781	2	sharpen_s
sharper	12	43	1270	2	sharp__er
shortener	12	4	577	2	shortener
barrener	10	3	833	3	_barrener
careener	10	3	932	3	_careener
carpenter	13	4	649	3	_carpenter
charterer	14	19	732	3	charterer
chastener	14	4	570	3	chastener
cheapener	16	4	377	3	cheapener
dampener	13	3	553	3	_dampener
darkener	13	3	599	3	_darkener
gardener	10	3	710	3	_gardener
hamperer	15	37	909	3	_hamperer
happened	16	3	565	3	_happened
hardened	13	3	861	3	_hardened
hardeners	13	3	808	3	_hardeners
harkened	16	3	748	3	_harkened
harkeners	16	3	607	3	_harkeners
harper	11	50	1840	3	_harp__er
harpooner	14	4	433	3	_harpooner
hastener	11	25	913	3	_hastener
hearkener	16	4	421	3	hearkener
heartener	12	5	676	3	heartener
larcener	10	3	649	3	_larcener
parcener	12	3	847	3	_parcener
resharpened	17	5	201	3	resharpened
sarcenet	10	4	1331	3	s_arcenet
sarsenet	8	4	1294	3	s_arsenet
scamperer	15	4	462	3	scamperer
scareder	11	3	579	3	scar_eder
scarper	11	48	1482	3	scarp__er
scarpered	14	3	511	3	scarpered
screener	10	3	757	3	s_creener
serener	7	34	1576	3	s_er_ener
shampooer	16	4	306	3	shampooer
shapelier	14	4	446	3	sha_pelier
shapen	11	44	1465	3	sha_pen__
shaper	11	41	1993	3	sha_p__er
shapewear	17	4	175	3	sha_pewear
sharer	9	50	2548	3	shar___er
sharker	14	43	1381	3	shar__ker
sharped	13	41	1205	3	sharp__ed
sharpening	16	4	488	3	sharpening
sharpers	13	38	1094	3	sharpe_rs
sharpest	13	3	914	3	sharpe_st
sharpie	12	3	839	3	sharp_ie_
sharpies	13	4	1122	3	sharp_ies
sharping	14	30	1137	3	sharpin_g
sharpness	14	3	493	3	sharpness
shatterer	12	17	720	3	shatterer
shortened	13	4	566	3	shortened
shorteners	13	4	508	3	shorteners
shrapnel	13	4	213	3	shrap_nel
shrieker	15	26	565	3	sh_rieker
slackener	15	4	393	3	slackener
smartened	12	4	426	3	smartened
stampeder	14	30	434	3	stampeder
warrener	11	3	691	3	_warrener

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	148641	0.423	422437.4
2	DLD Change Limit	148641	64	6.360	23371.2
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	6.813	26227.9