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

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

85 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
dressmaking	19	5	217	(None)
dressmakings	20	5	143	1	dressmakings
dressing	10	28	1042	3	dress___ing
dressmaker	17	5	192	3	dressmak_er
dressmakers	18	5	176	3	dressmakers
glassmaking	19	5	228	3	glassmaking
presoaking	17	3	625	3	pre_soaking
remaking	15	26	1330	3	_re__making
resoaking	14	3	937	3	_re_soaking
respeaking	17	3	680	3	_respeaking
besmoking	18	11	461	4	_be_smoking
bespeaking	19	4	439	4	_bespeaking
breaking	15	39	1425	4	bre___aking
creaking	15	34	1412	4	cre___aking
cremating	14	3	1220	4	cre__mating
debeaking	17	3	592	4	d_e_beaking
decimating	16	4	876	4	d_ecimating
demarking	17	3	677	4	d_e__marking
desolating	12	3	946	4	d_esolating
despumating	17	4	369	4	d_espumating
desugaring	13	4	326	4	d_esugaring
dismaying	16	5	682	4	d__ismaying
dissaving	14	3	696	4	d_iss_aving
disseating	12	11	1178	4	d_isseating
dissuading	13	4	572	4	d_issuading
dreading	11	37	1280	4	dre___ading
dreaming	12	40	1106	4	dre___aming
dressings	11	26	537	4	dress___ings
essaying	12	3	503	4	__ess_aying
forespeaking	22	5	215	4	forespeaking
freaking	16	36	1145	4	fre___aking
glassmakings	20	5	155	4	glassmakings
grubstaking	19	5	132	4	grubstaking
merrymaking	23	5	192	4	merrymaking
messaging	13	4	534	4	_mess_aging
mismaking	18	11	802	4	__mismaking
noisemaking	18	5	256	4	noisemaking
oversmoking	21	4	504	4	oversmoking
oversoaking	19	5	678	4	oversoaking
phrasemaking	24	5	175	4	phrasemaking
prebaking	18	3	806	4	pre__baking
presaging	13	3	939	4	pre_s_aging
preshaping	18	4	542	4	pre_shaping
pressgang	13	4	277	4	pressga__ng
pressing	11	25	1644	4	press___ing
pressman	12	4	716	4	pressma__n_
pressuring	13	4	651	4	press_uring
prestamping	18	6	365	4	prestamping
presuming	14	3	766	4	presum__ing
printmaking	20	5	285	4	printmaking
rainmaking	17	4	397	4	_rainmaking
reawaking	17	21	607	4	_re_awaking
redamaging	15	4	376	4	_redamaging
reimaging	13	3	650	4	_re_imaging
remarking	16	3	889	4	_re__marking
remating	11	23	2242	4	_re__mating
resampling	15	4	433	4	_resampling
resawing	12	23	1143	4	_re_s_awing
resaying	12	25	1245	4	_re_s_aying
rescaling	12	22	1201	4	_re_scaling
resealing	10	21	1567	4	_re_sealing
reseating	10	24	2153	4	_re_seating
reseeking	14	20	849	4	_re_seeking
resembling	15	4	473	4	_resembling
reshaping	15	5	774	4	_re_shaping
reshaving	16	5	727	4	_re_shaving
resinating	11	3	1373	4	_resinating
reslating	10	25	1699	4	_re_slating
resonating	11	3	1126	4	_resonating
respacing	14	3	889	4	_re_spacing
respading	13	3	880	4	_re_spading
respraying	16	3	609	4	_respraying
restacking	17	3	718	4	_restacking
restaging	11	24	1085	4	_re_staging
restamping	15	6	521	4	_restamping
restating	10	23	1941	4	_re_stating
restocking	17	4	570	4	_restocking
restoking	14	3	819	4	_re_stoking
restriking	15	4	804	4	_restriking
resuming	11	3	1008	4	_resum__ing
retaking	13	31	1428	4	_re__taking
rewaking	16	23	1098	4	_re__waking
rosemaling	13	4	426	4	_rosemaling
steelmaking	18	14	249	4	steelmaking
wreaking	16	30	1021	4	wre___aking

Search took 10 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	148819	0.420	425454.8
2	DLD Change Limit	148819	85	9.390	15848.7
3	Display Results	85	85	0.033	2575.8
	(SQL Overall)	178691	85	9.843	18154.1