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

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

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.

55 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
roughhouses	18	5	231	(None)
roughhouse	17	5	232	1	roughhouse_
roughhoused	19	5	131	1	roughhoused
roundhouses	15	10	299	2	roundhouses
bughouses	15	4	474	3	_bug_houses
courthouses	16	5	395	3	courthouses
doghouses	14	4	535	3	do_g_houses
longhouses	14	4	498	3	long_houses
outhouses	12	3	1066	3	_ou_thouses
roadhouses	14	4	450	3	ro_adhouses
roughhousing	20	6	84	3	roughhousing
roughnesses	15	10	513	3	roughnesses
roundhouse	14	7	292	3	roundhouse_
baghouses	15	4	546	4	_bag_houses
bathhouses	18	4	419	4	_bathhouses
boathouses	15	4	592	4	bo_athouses
bughouse	14	4	507	4	_bug_house_
bunkhouses	19	12	339	4	_bunkhouses
clubhouses	17	4	284	4	clu_bhouses
cookhouses	19	4	460	4	co_okhouses
courthouse	15	4	389	4	courthouse_
couscouses	14	4	391	4	cou_scouses
doghouse	13	4	541	4	do_g_house_
dollhouses	14	4	405	4	do_llhouses
dosshouses	14	4	358	4	do_sshouses
funhouses	15	4	459	4	_fu_nhouses
hothouses	15	4	776	4	ho__thouses
lighthouses	18	5	297	4	_lighthouses
longhouse	13	4	540	4	long_house_
nuthouses	12	4	634	4	_nu_thouses
oasthouses	13	4	497	4	_oasthouses
outhouse	11	3	1088	4	_ou_thouse_
poorhouses	15	4	529	4	po_orhouses
pothouses	14	4	904	4	po__thouses
powerhouses	19	5	247	4	powerhouses
rehouses	11	3	1211	4	r___ehouses
roadhouse	13	4	467	4	ro_adhouse_
roughages	14	4	438	4	roug_h_ages
roughcasts	16	5	216	4	roug_hcasts
roughdries	15	5	268	4	roug_hdries
roughhew	18	4	287	4	roughh___ew
roughhewed	21	5	160	4	roughh_ewed
roughhews	19	4	219	4	roughh__ews
roughies	12	9	832	4	roug_h__ies
roughness	13	4	576	4	roug_hnes_s
soukouses	13	4	410	4	sou__kouses
sugarhouses	15	5	239	4	_sugarhouses
tollhouses	13	4	455	4	to_llhouses
toolhouses	13	4	457	4	to_olhouses
touchholes	18	5	302	4	touchho_les
toughnesses	15	10	448	4	toughnesses
townhouses	16	5	385	4	to_wnhouses
unhouses	11	3	870	4	__u_nhouses
washhouses	19	4	350	4	_washhouses
workhouses	20	4	489	4	wo_rkhouses

Search took 9 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	148819	0.420	425454.8
2	DLD Change Limit	148819	55	8.003	18595.4
3	Display Results	55	55	0.030	1833.3
	(SQL Overall)	178691	55	8.453	21139.4