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

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

39 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
roadhouse	13	4	466	(None)
roadhouses	14	4	449	1	roadhouses
beadhouse	15	4	442	2	beadhouse
boathouse	14	4	594	2	boathouse
madhouse	14	4	550	2	_madhouse
roundhouse	14	7	291	2	roundhouse
baghouse	14	4	521	3	_baghouse
beadhouses	16	4	429	3	beadhouses
birdhouse	15	4	370	3	birdhouse
boathouses	15	4	592	3	boathouses
cathouse	13	3	884	3	_cathouse
cookhouse	18	4	493	3	cookhouse
doghouse	13	4	541	3	do_ghouse
dollhouse	13	4	405	3	dollhouse
dosshouse	13	4	371	3	dosshouse
gashouse	12	4	569	3	_gashouse
guardhouse	15	5	221	3	guardhouse
hothouse	14	4	735	3	ho_thouse
longhouse	13	4	540	3	longhouse
madhouses	15	4	574	3	_madhouses
oasthouse	12	4	477	3	_oasthouse
outhouse	11	3	1087	3	_outhouse
playhouse	17	4	393	3	playhouse
poorhouse	14	4	531	3	poorhouse
pothouse	13	4	870	3	po_thouse
rearmouse	11	4	410	3	rearmouse
rearouse	8	3	936	3	rea_rouse
redhorse	12	4	546	3	r_edhorse
rehouse	10	3	1177	3	r__ehouse
roadeos	8	3	740	3	roadeo_s_
roadshows	16	6	255	3	roadshows_
roughhouse	17	5	231	3	roughhouse
roundhouses	15	10	298	3	roundhouses
taphouse	13	4	633	3	_taphouse
teahouse	11	4	607	3	tea_house
tollhouse	12	4	454	3	tollhouse
toolhouse	12	4	469	3	toolhouse
townhouse	15	4	428	3	townhouse
workhouse	19	4	525	3	workhouse

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	148641	0.190	940478.9
2	DLD Change Limit	148641	39	9.466	15702.6
3	Display Results	39	39	0.016	2437.5
	(SQL Overall)	178691	39	9.672	18475.1