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

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

43 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
songstresses	12	5	201	(None)
songstress	11	5	241	2	songstre_s_s
congresses	13	4	802	3	cong__resses
seamstresses	13	5	225	3	seamstresses
sempstresses	15	5	220	3	sempstresses
unstresses	10	4	603	3	_un_stresses
ancestresses	14	9	327	4	ancestresses
cloistresses	14	5	234	4	cloistresses
cohostesses	16	5	254	4	cohost_esses
conductresses	18	6	192	4	conductresses
congressed	14	4	546	4	cong__ressed
distresses	11	4	885	4	__distresses
fortresses	13	4	566	4	fo__rtresses
hostesses	12	4	717	4	ho__st_esses
huntresses	13	4	528	4	hun__tresses
ingresses	10	3	853	4	_ing__resses
jointresses	18	4	347	4	jo_intresses
longnesses	11	3	850	4	long__nesses
lostnesses	10	4	930	4	lo__stnesses
mistresses	12	4	799	4	__mistresses
moistnesses	13	4	715	4	mo_istnesses
ogresses	9	3	847	4	_o_g__resses
oratresses	10	4	549	4	_o_ratresses
overstresses	15	5	484	4	overstresses
portresses	12	4	731	4	po__rtresses
prestresses	13	4	672	4	_prestresses
restresses	10	4	931	4	__restresses
robustnesses	14	4	378	4	robustnesses
sculptresses	16	6	140	4	sculptresses
seductresses	15	5	204	4	seductresses
singlenesses	13	4	610	4	singlenesses
sinisternesses	13	5	211	4	sinisternesses
slightnesses	16	5	462	4	slightnesses
softnesses	13	3	760	4	so__ftnesses
sogginesses	13	4	677	4	so_gginesses
songfulnesses	17	5	467	4	songfulnesses
songsters	10	4	611	4	songst_e__rs
sorceresses	13	4	337	4	so_rceresses
sponginesses	15	4	477	4	spong_inesses
stresses	8	11	1249	4	____stresses
sundresses	11	4	654	4	sun__dresses
unstressed	11	4	508	4	_un_stressed
votresses	12	3	650	4	vo___tresses

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.390	458182.1
2	DLD Change Limit	124790	43	7.563	16500.1
3	Display Results	43	43	0.013	3307.7
	(SQL Overall)	178691	43	7.966	22431.7