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

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

61 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
resharpening	18	5	234	(None)
rehardening	16	4	414	2	re_hardening
sharpening	16	4	488	2	__sharpening
prehardening	19	5	258	3	pre_hardening
recarpeting	16	7	436	3	re_carpeting
rechartering	18	5	354	3	rechartering
rescreening	14	4	408	3	res_creening
reshaping	15	5	774	3	resha_p__ing
resharpen	14	4	342	3	resharpe__n_
resharpened	17	5	201	3	resharpen_ed
resharpens	15	4	256	3	resharpe__ns
becarpeting	18	8	279	4	be_carpeting
bedarkening	19	4	219	4	be_darkening
bescreening	16	4	277	4	bes_creening
beshrewing	19	4	288	4	besh_r_ewing
disheartening	18	5	238	4	disheartening
escarping	14	3	520	4	_escarp__ing
foreshortening	21	8	71	4	foreshortening
freshening	17	4	477	4	fresh___ening
happening	17	3	559	4	___happening
hardening	14	3	802	4	___hardening
harkening	17	4	692	4	___harkening
hearkening	18	4	453	4	he__arkening
heartening	14	4	673	4	he__artening
nonhappening	20	6	112	4	nonhappening
prescreening	17	5	287	4	pres_creening
preshaping	18	4	542	4	presha_p__ing
reawakening	19	5	219	4	reawa_kening
rechallenging	20	7	127	4	rechallenging
rechanneling	18	5	245	4	rechanneling
recharging	17	4	529	4	rechar__ging
recharting	16	3	721	4	rechar__ting
reearning	10	3	905	4	re_ear__ning
refastening	15	4	430	4	re_fastening
regreening	12	4	603	4	re__greening
rehammering	19	5	336	4	re_hammering
relearning	11	3	528	4	relear__ning
remarketing	18	4	371	4	re_marketing
reopening	12	4	882	4	re___opening
repapering	15	4	704	4	re_pa_pering
resampling	15	4	433	4	res_amp_ling
researching	17	4	342	4	resear_ching
reseasoning	12	4	300	4	resea_soning
reshaving	16	5	727	4	resha___ving
reshining	13	3	1074	4	resh___ining
reshipping	18	4	379	4	resh_ip_ping
reshoeing	13	3	659	4	resh__oe_ing
reshowering	18	4	316	4	resh_owering
resoftening	15	4	323	4	res_oftening
restamping	15	6	521	4	restamp__ing
restarting	11	3	1066	4	restar__ting
restationing	13	5	426	4	restationing
restraining	12	4	753	4	res_training
resurveying	18	4	259	4	res_urveying
resuspending	16	5	171	4	res_uspending
retargeting	13	4	393	4	re_targeting
rewakening	18	4	379	4	re_wa_kening
scarpering	15	4	541	4	__scarpering
sharping	14	30	1137	4	__sharp__ing
shortening	14	4	530	4	__shortening
smartening	13	4	499	4	__smartening

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.156	1145455.1
2	DLD Change Limit	124790	61	8.326	14988.0
3	Display Results	61	61	0.033	1848.5
	(SQL Overall)	178691	61	8.515	20985.4