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

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

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.

67 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
madhouses	15	4	574	(None)
madhouse	14	4	550	1	madhouse_
baghouses	15	4	546	2	baghouses
beadhouses	16	4	429	2	beadhouses
cathouses	14	3	943	2	cathouses
gashouses	13	4	576	2	gashouses
roadhouses	14	4	450	2	roadhouses
taphouses	14	4	655	2	taphouses
alehouses	12	4	658	3	alehouses
arouses	7	49	2129	3	_a_rouses
backhouses	21	4	574	3	backhouses
baghouse	14	4	521	3	baghouse_
bakehouses	19	13	445	3	bakehouses
bathhouses	18	4	419	3	bathhouses
bathoses	13	3	1046	3	batho_ses
beadhouse	15	4	442	3	beadhouse_
bedehouses	16	4	409	3	bedehouses
birdhouses	16	4	332	3	birdhouses
boathouses	15	4	592	3	boathouses
bughouses	15	4	474	3	bughouses
callouses	11	4	768	3	callouses
carouses	10	6	1450	3	ca_rouses
cathouse	13	3	886	3	cathouse_
chouses	12	51	1781	3	__chouses
doghouses	14	4	535	3	doghouses
douses	7	49	2893	3	__d_ouses
farmhouses	18	4	401	3	farmhouses
funhouses	15	4	459	3	funhouses
gashouse	12	4	569	3	gashouse_
gatehouses	14	4	526	3	gatehouses
guardhouses	16	6	211	3	guardhouses
henhouses	15	4	617	3	henhouses
hothouses	15	4	776	3	hothouses
houses	9	60	3227	3	___houses
icehouses	14	4	501	3	icehouses
jailhouses	20	4	300	3	jailhouses
machoisms	18	4	519	3	machoisms
madnesses	12	3	983	3	madnesses
madrases	11	26	1000	3	mad_rases
madrones	11	29	1228	3	madro_nes
mahoes	11	3	1310	3	ma_ho__es
mahouts	12	3	714	3	ma_hou_ts
maltoses	10	3	985	3	malto_ses
mandamuses	15	4	339	3	mandamuses
manholes	13	3	1118	3	manho_les
mannoses	10	3	908	3	manno_ses
masseuses	11	4	479	3	masseuses
millhouses	15	4	407	3	millhouses
mouses	8	55	3142	3	m___ouses
mudholes	14	4	487	3	mudho_les
nuthouses	12	4	634	3	nuthouses
oasthouses	13	4	497	3	oasthouses
outhouses	12	3	1066	3	outhouses
pathoses	13	4	1277	3	patho_ses
playhouses	18	4	387	3	playhouses
pothouses	14	4	904	3	pothouses
radiuses	9	3	704	3	rad_iuses
redhorses	13	4	565	3	redhorses
rehouses	11	3	1211	3	_rehouses
roadhouse	13	4	467	3	roadhouse_
sawhorses	15	4	375	3	sawhorses
taphouse	13	4	633	3	taphouse_
teahouses	12	4	651	3	teahouses
unhouses	11	3	870	3	_unhouses
warehouses	16	4	581	3	warehouses
warhorses	15	4	557	3	warhorses
washhouses	19	4	350	3	washhouses

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	67	6.203	23962.8
3	Display Results	67	67	0.030	2233.3
	(SQL Overall)	178691	67	6.406	27894.3