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

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

72 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
taphouses	14	4	655	(None)
taphouse	13	4	633	1	taphouse_
baghouses	15	4	546	2	baghouses
cathouses	14	3	941	2	cathouses
gashouses	13	4	576	2	gashouses
madhouses	15	4	574	2	madhouses
tapholes	13	3	962	2	tapho_les
teahouses	12	4	651	2	teahouses
typhuses	16	4	376	2	typh_uses
alehouses	12	4	658	3	alehouses
apheses	12	6	1070	3	_aph_eses
aphorises	14	3	1000	3	_aphorises
apposes	11	5	1147	3	_appo_ses
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	1045	3	batho_ses
beadhouses	16	4	429	3	beadhouses
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	884	3	cathouse_
chophouses	20	4	514	3	chophouses
chouses	12	51	1781	3	__chouses
doghouses	14	4	535	3	doghouses
espouses	10	3	730	3	esp_ouses
farmhouses	18	4	401	3	farmhouses
flophouses	18	5	396	3	flophouses
funhouses	15	4	459	3	funhouses
gashouse	12	4	569	3	gashouse_
gatehouses	14	4	526	3	gatehouses
haploses	13	3	885	3	haplo_ses
henhouses	15	4	617	3	henhouses
hothouses	15	4	776	3	hothouses
houses	9	60	3227	3	___houses
icehouses	14	4	500	3	icehouses
jailhouses	20	4	300	3	jailhouses
kyphoses	20	4	528	3	kypho_ses
madhouse	14	4	550	3	madhouse_
nuthouses	12	4	634	3	nuthouses
oasthouses	13	4	497	3	oasthouses
outhouses	12	3	1065	3	outhouses
papooses	12	4	805	3	pap_ooses
pappooses	12	4	398	3	pappooses
papyruses	16	4	322	3	papyruses
pathoses	13	4	1276	3	patho_ses
playhouses	18	4	387	3	playhouses
pothouses	14	4	904	3	pothouses
rehouses	11	3	1211	3	_rehouses
roadhouses	14	4	449	3	roadhouses
sawhorses	15	4	375	3	sawhorses
spouses	9	29	1281	3	_sp_ouses
statehouses	14	5	376	3	statehouses
taluses	7	3	1121	3	ta__luses
taphole	12	3	977	3	tapho_le_
tapises	9	29	1401	3	tap__ises
teahouse	11	4	607	3	teahouse_
tollhouses	13	4	455	3	tollhouses
toolhouses	13	4	457	3	toolhouses
touses	6	42	2967	3	t___ouses
townhouses	16	5	385	3	townhouses
treehouses	13	4	519	3	treehouses
typhose	15	4	669	3	typho_se_
typhous	15	6	632	3	typhou__s
unhouses	11	3	870	3	_unhouses
uprouses	10	3	755	3	_uprouses
warehouses	16	4	581	3	warehouses
warhorses	15	4	557	3	warhorses
washhouses	19	4	350	3	washhouses

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	148641	0.233	766914.2
2	DLD Change Limit	148641	72	7.720	19254.0
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.983	22383.9