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

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

55 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
refreshments	20	5	360	(None)
refreshment	19	5	406	1	refreshment_
refreshens	16	11	399	2	refresh_en_s
enmeshments	18	5	436	3	_enmeshments
fleshments	18	4	385	3	__fleshments
recrements	14	4	935	3	recre__ments
refrainments	17	5	400	3	refrainments
refreshen	15	8	516	3	refresh_en__
refreshened	18	5	246	3	refresh_ened
refreshers	16	10	367	3	refresh_e_rs
refreshes	15	9	595	3	refresh_e__s
refurbishments	24	6	195	3	refurbishments
represents	12	4	675	3	repres__ents
retrenchments	20	6	257	3	retrenchments
arrestments	13	5	469	4	_arrestments
cerements	13	4	1145	4	ce_re__ments
decrements	15	4	938	4	decre__ments
deferments	16	12	858	4	def_e_rments
encashments	18	7	506	4	_encashments
enmeshment	17	5	539	4	_enmeshment_
enrichments	18	5	533	4	_enrichments
fleshment	17	4	550	4	__fleshment_
freshens	14	29	831	4	__fresh_en_s
freshets	14	29	867	4	__fresh_e_ts
freshmen	16	5	602	4	__freshmen__
impressments	18	5	396	4	impressments
nourishments	17	5	369	4	nourishments
preferments	18	4	474	4	pref_e_rments
prefreshman	21	6	76	4	prefreshman__
pretreatments	17	5	249	4	pretreatments
ravishments	19	5	410	4	r_avishments
rearguments	14	8	384	4	rear_guments
rearmaments	15	5	426	4	rear_maments
reassessments	14	6	212	4	reassessments
recements	13	3	1228	4	re_ce__ments
recrement	13	4	1136	4	recre__ment_
recruitments	16	11	339	4	recruitments
referents	12	25	964	4	ref_e__rents
refinements	16	4	679	4	ref_inements
refrainment	16	5	448	4	refrainment_
refreshed	16	8	561	4	refresh_e__d
refreshening	19	5	242	4	refresh_ening
refresher	15	10	465	4	refresh_e__r
refreshing	17	4	606	4	refresh_in_g
refurbishment	23	6	215	4	refurbishment_
reinvestments	18	5	310	4	reinvestments
replenishments	21	9	199	4	replenishments
reprehends	16	4	328	4	repre_h_ends
represent	11	4	1007	4	repres__ent_
resentments	13	4	654	4	re_sentments
retirements	13	5	761	4	retire__ments
retrenchment	19	5	323	4	retrenchment_
revealments	16	4	449	4	re_vealments
revelments	15	4	686	4	re_ve_lments
revetments	15	4	643	4	re_ve_tments

Search took 8 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.296	603685.8
2	DLD Change Limit	124790	55	7.436	16781.9
3	Display Results	55	55	0.033	1666.7
	(SQL Overall)	178691	55	7.765	23012.4