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

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

64 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
baghouses	15	4	546	(None)
baghouse	14	4	521	1	baghouse_
bughouses	15	4	474	1	bughouses
backhouses	21	4	574	2	backhouses
bakehouses	19	13	445	2	bakehouses
bathhouses	18	4	419	2	bathhouses
bathoses	13	3	1046	2	batho_ses
beadhouses	16	4	429	2	beadhouses
boathouses	15	4	592	2	boathouses
bughouse	14	4	507	2	bughouse_
cathouses	14	3	943	2	cathouses
doghouses	14	4	535	2	doghouses
gashouses	13	4	576	2	gashouses
madhouses	15	4	574	2	madhouses
taphouses	14	4	655	2	taphouses
alehouses	12	4	658	3	alehouses
arouses	7	49	2129	3	_a_rouses
backhouse	20	4	614	3	backhouse_
bagasses	11	3	631	3	bag_asses
bakehouse	18	12	458	3	bakehouse_
bathhouse	17	4	419	3	bathhouse_
beadhouse	15	4	442	3	beadhouse_
bedehouses	16	4	409	3	bedehouses
bespouses	13	4	515	3	bespouses
bigoses	10	3	907	3	big_o_ses
birdhouses	16	4	332	3	birdhouses
blouses	9	40	1446	3	b__louses
boathouse	14	4	594	3	boathouse_
bouses	8	49	3178	3	b___ouses
buglosses	12	4	354	3	buglosses
bunkhouses	19	12	339	3	bunkhouses
burnouses	11	4	485	3	burnouses
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
doghouse	13	4	541	3	doghouse_
farmhouses	18	4	401	3	farmhouses
funhouses	15	4	459	3	funhouses
gashouse	12	4	569	3	gashouse_
gatehouses	14	4	526	3	gatehouses
grouses	8	46	1654	3	__grouses
henhouses	15	4	617	3	henhouses
hothouses	15	4	776	3	hothouses
houses	9	60	3228	3	___houses
icehouses	14	4	501	3	icehouses
jailhouses	20	4	300	3	jailhouses
longhouses	14	4	498	3	longhouses
madhouse	14	4	550	3	madhouse_
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
rehouses	11	3	1211	3	_rehouses
roadhouses	14	4	450	3	roadhouses
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 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.423	422437.4
2	DLD Change Limit	148641	64	7.063	21045.0
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	7.516	23774.7