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

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

37 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
poorhouse	14	4	531	(None)
poorhouses	15	4	529	1	poorhouses
cookhouse	18	4	493	2	cookhouse
pothouse	13	4	870	2	p_othouse
powerhouse	18	5	247	2	powerhouse
toolhouse	12	4	469	2	toolhouse
boathouse	14	4	594	3	boathouse
booklouse	15	4	321	3	booklouse
chophouse	19	4	529	3	chophouse
cookhouses	19	4	460	3	cookhouses
courthouse	15	4	388	3	courthouse
doghouse	13	4	541	3	_doghouse
dollhouse	13	4	405	3	dollhouse
dormouse	11	4	424	3	_dormouse
dosshouse	13	4	371	3	dosshouse
flophouse	17	4	410	3	flophouse
hothouse	14	4	735	3	_hothouse
longhouse	13	4	540	3	longhouse
outhouse	11	3	1087	3	_outhouse
penthouse	14	4	626	3	penthouse
pesthouse	14	4	596	3	pesthouse
pilothouse	15	8	308	3	pilothouse
playhouse	17	4	393	3	playhouse
poormouth	16	5	242	3	poormouth
porose	8	48	1874	3	p_or_o_se
porous	8	44	1948	3	p_or_ous_
porpoise	12	4	807	3	p_orpoise
porterhouse	16	5	276	3	porterhouse
pothouses	14	4	904	3	p_othouses
powerhouses	19	5	247	3	powerhouses
roadhouse	13	4	466	3	roadhouse
storehouse	13	4	383	3	storehouse
tollhouse	12	4	454	3	tollhouse
toolhouses	13	4	457	3	toolhouses
townhouse	15	4	428	3	townhouse
whorehouse	19	5	346	3	whorehouse
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.313	570897.8
2	DLD Change Limit	148641	37	9.140	16262.7
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	9.469	18871.2