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

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

58 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
housedresses	16	5	270	(None)
housedress	14	4	332	2	housedre_s_s
hoodednesses	17	4	449	3	hoodednesses
hornednesses	16	4	551	3	hornednesses
outdresses	11	23	682	3	_ou_tdresses
boundednesses	17	5	393	4	boundednesses
boundnesses	14	4	662	4	bou_ndnesses
coatdresses	14	4	394	4	co_atdresses
coheiresses	16	4	341	4	co_heiresses
confusednesses	20	5	255	4	confusednesses
cursednesses	15	5	497	4	cursednesses
cussednesses	14	4	353	4	cussednesses
doggednesses	16	4	370	4	doggednesses
goosegrasses	14	6	110	4	goosegrasses
handednesses	17	6	564	4	handednesses
headdresses	16	8	369	4	h_eaddresses
heiresses	12	3	696	4	h___eiresses
hoarsenesses	15	4	560	4	hoarse_nesses
hokeynesses	21	9	371	4	ho_keynesses
homeynesses	19	8	481	4	ho_meynesses
horridnesses	16	4	446	4	horridnesses
horsefleshes	21	5	133	4	horsefleshes
horsinesses	14	3	955	4	hors_inesses
hostesses	12	4	717	4	ho_s__tesses
hotpresses	15	4	452	4	ho__tpresses
housebreaker	21	6	243	4	housebreaker
housebreakers	22	6	213	4	housebreakers
housebreaks	20	5	258	4	housebre_aks
houseguests	15	8	171	4	housegue_sts
houseless	12	3	747	4	house_le_s_s
houselessness	15	10	492	4	house_lessness
housepersons	17	6	207	4	housepersons
hugenesses	14	3	714	4	h_uge_nesses
humidnesses	17	4	458	4	h_umidnesses
huntresses	13	4	528	4	h_u_ntresses
huskinesses	18	13	653	4	h_uskinesses
laundresses	12	4	311	4	lau_ndresses
loosenesses	11	4	724	4	loose_nesses
loudnesses	11	3	843	4	lou__dnesses
lousinesses	11	12	1032	4	lous_inesses
mousinesses	13	12	983	4	mous_inesses
murderesses	14	4	310	4	_murderesses
notednesses	12	4	779	4	no_tednesses
outdressed	12	23	532	4	_ou_tdressed
outpresses	12	15	725	4	_ou_tpresses
overdresses	15	4	619	4	_overdresses
porteresses	13	4	552	4	porte_resses
redresses	10	4	1029	4	___redresses
rootednesses	13	4	533	4	rootednesses
roundednesses	15	5	429	4	roundednesses
roundnesses	12	4	704	4	rou_ndnesses
seeresses	9	3	905	4	___seeresses
sidedresses	13	4	352	4	_sidedresses
sorceresses	13	4	337	4	sorce_resses
soundnesses	12	4	752	4	sou_ndnesses
sundresses	11	4	654	4	_su_ndresses
undresses	10	3	931	4	__u_ndresses
wontednesses	16	4	599	4	wontednesses

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.390	458182.1
2	DLD Change Limit	124790	58	7.750	16101.9
3	Display Results	58	58	0.030	1933.3
	(SQL Overall)	178691	58	8.170	21871.6