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

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

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
sugarhouses	15	5	239	(None)
sugarhouse	14	5	244	1	sugarhouse_
bughouses	15	4	474	3	bug__houses
gashouses	13	4	576	3	__gashouses
guardhouses	16	6	211	3	gu_ardhouses
sugarbushes	17	5	164	3	sugar_bushes
sugarloaves	15	5	86	3	sugarloaves
summerhouses	19	5	153	3	summerhouses
agaroses	9	3	882	4	_agar_o_ses
arouses	7	49	2129	4	___ar_ouses
baghouses	15	4	546	4	__baghouses
beadhouses	16	4	429	4	_beadhouses
boathouses	15	4	592	4	_boathouses
bughouse	14	4	507	4	bug__house_
bunkhouses	19	12	339	4	bu_nkhouses
burnouses	11	4	485	4	bu__rnouses
carouses	10	6	1450	4	__car_ouses
cathouses	14	3	943	4	__cathouses
doghouses	14	4	535	4	dog__houses
farmhouses	18	4	401	4	__farmhouses
funhouses	15	4	459	4	fu__nhouses
gashouse	12	4	569	4	__gashouse_
gatehouses	14	4	526	4	__gatehouses
grouses	8	46	1654	4	__g_r_ouses
guardhouse	15	5	221	4	gu_ardhouse_
lighthouses	18	5	297	4	lighthouses
madhouses	15	4	574	4	__madhouses
nuthouses	12	4	634	4	nu__thouses
outhouses	12	3	1066	4	ou__thouses
playhouses	18	4	387	4	_playhouses
poorhouses	15	4	529	4	_poorhouses
powerhouses	19	5	247	4	powerhouses
rearouses	9	3	1020	4	_rear_ouses
roadhouses	14	4	450	4	_roadhouses
roughhouses	18	5	231	4	roug_hhouses
sardiuses	10	4	475	4	s__ardiuses
saroses	7	36	1933	4	s__ar_o_ses
sawhorses	15	4	375	4	s__awhorses
scabiouses	14	4	300	4	s_cabiouses
scirrhuses	15	5	146	4	scirrh_uses
seahorses	12	4	616	4	s_ea_horses
smokehouses	20	6	220	4	smokehouses
starnoses	9	15	715	4	s_tarno_ses
statehouses	14	5	376	4	statehouses
storehouses	14	5	383	4	storehouses
sucraloses	12	7	359	4	sucralo_ses
sucroses	10	3	993	4	su_cr_o_ses
sugarbush	15	5	158	4	sugar_bus_h
sugarcanes	13	4	305	4	sugar_canes
sugarcoated	15	5	164	4	sugarcoated
sugarcoats	13	5	238	4	sugarco_ats
sugarless	10	4	367	4	sugar_les_s
sugarplums	15	6	123	4	sugarplu_ms
summerhouse	18	5	166	4	summerhouse_
superposes	14	4	893	4	superpo_ses
surpluses	11	5	543	4	su__rpluses
susurruses	10	6	169	4	susur_ruses
taphouses	14	4	655	4	__taphouses
teahouses	12	4	651	4	_tea_houses
unaroused	10	4	652	4	_unar_oused
unhouses	11	3	870	4	_u__nhouses
uprouses	10	3	755	4	_u_pr_ouses
warehouses	16	4	581	4	__warehouses
warhorses	15	4	557	4	__warhorses

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.173	1032896.0
2	DLD Change Limit	148819	64	8.516	17475.2
3	Display Results	64	64	0.030	2133.3
	(SQL Overall)	178691	64	8.719	20494.4