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

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

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.

51 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
headmistresses	20	6	118	(None)
headmistress	18	6	144	2	headmistre_s_s
seamstresses	13	5	225	3	sea_m_stresses
distresses	11	4	885	4	___d_istresses
editresses	11	6	507	4	_e_d_i_tresses
headdresses	16	8	369	4	head___dresses
headinesses	15	3	984	4	head_i__nesses
headlessnesses	17	13	706	4	headlessnesses
mistresses	12	4	799	4	____mistresses
postmistresses	17	6	121	4	postmistresses
sempstresses	15	5	220	4	se__mpstresses
taskmistresses	19	6	71	4	taskmistresses
toastmistresses	16	7	75	4	toastmistresses
adultresses	12	4	293	5	__ad_ultresses
ancestresses	14	9	327	5	__ancestresses
arbitresses	13	4	334	5	__arbi_tresses
aviatresses	14	8	300	5	__a_viatresses
beadinesses	14	4	956	5	bead_i__nesses
bearishnesses	18	4	484	5	bea_rishnesses
caddishnesses	20	4	337	5	_caddishnesses
cloistresses	14	5	234	5	__cloistresses
deadlinesses	14	4	622	5	deadli__nesses
distressed	12	4	644	5	___d_istressed
earnestnesses	13	5	366	5	_earnestnesses
earwitnesses	15	4	378	5	_earwi_tnesses
faddishnesses	21	4	324	5	_faddishnesses
hamminesses	18	3	577	5	h_ammi__nesses
hawkishnesses	26	4	325	5	h_awkishnesses
headmasters	17	17	430	5	headmast_e__rs
headmastership	25	10	128	5	headmastership
headmasterships	26	11	118	5	headmasterships
headstreams	17	5	209	5	head__stre_ams
heartinesses	15	4	800	5	hearti__nesses
heavinesses	17	4	745	5	hea_vi__nesses
heedlessnesses	17	13	622	5	heedlessnesses
heiresses	12	3	696	5	he___i__resses
hellishnesses	19	7	435	5	he_llishnesses
qualmishnesses	28	5	208	5	qualmishnesses
readdresses	13	9	451	5	read___dresses
readinesses	12	6	1127	5	read_i__nesses
reddishnesses	18	7	358	5	re_ddishnesses
redigresses	13	4	394	5	re_d_i_gresses
remissnesses	13	4	495	5	re__missnesses
restresses	10	4	931	5	re____stresses
seaminesses	13	3	1075	5	sea_mi__nesses
seamstress	12	4	228	5	sea_m_stre_s_s
seductresses	15	5	204	5	se_d_uctresses
steadfastnesses	18	8	87	5	steadfastnesses
temptresses	15	4	359	5	te__m_ptresses
traitresses	11	4	460	5	tra__i_tresses
waitresses	13	4	506	5	_wa__i_tresses

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	95024	0.360	496363.9
2	DLD Change Limit	95024	51	5.810	16355.2
3	Display Results	51	51	0.033	1545.5
	(SQL Overall)	178691	51	6.203	28807.2