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

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

71 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
roundhouses	15	10	299	(None)
roundhouse	14	7	292	1	roundhouse_
roadhouses	14	4	450	2	ro_adhouses
roughhouses	18	5	231	2	roughhouses
bunkhouses	19	12	339	3	_bunkhouses
courthouses	16	5	395	3	courthouses
funhouses	15	4	459	3	_fun_houses
longhouses	14	4	498	3	lo_nghouses
outhouses	12	3	1066	3	_ou_thouses
roadhouse	13	4	467	3	ro_adhouse_
roughhouse	17	5	232	3	roughhouse_
roughhoused	19	5	131	3	roughhoused
roundnesses	12	4	704	3	roundnesses
townhouses	16	5	385	3	town_houses
unhouses	11	3	870	3	__un_houses
beadhouses	16	4	429	4	_beadhouses
birdhouses	16	4	332	4	_birdhouses
boathouses	15	4	592	4	bo_athouses
boundnesses	14	4	662	4	boundnesses
bughouses	15	4	474	4	_bu_ghouses
bunkhouse	18	12	365	4	_bunkhouse_
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
doghouses	14	4	535	4	do__ghouses
dollhouses	14	4	405	4	do_llhouses
dosshouses	14	4	358	4	do_sshouses
funhouse	14	4	452	4	_fun_house_
greenhouses	15	5	324	4	green_houses
groundhogs	16	5	183	4	groundho__gs
groundmasses	16	5	138	4	groundmasses
groundouts	12	12	319	4	ground_ou_ts
guardhouses	16	6	211	4	guardhouses
henhouses	15	4	617	4	_hen_houses
hothouses	15	4	776	4	ho__thouses
longhouse	13	4	540	4	lo_nghouse_
madhouses	15	4	574	4	__madhouses
nuthouses	12	4	634	4	_nu_thouses
oasthouses	13	4	497	4	_oasthouses
outhouse	11	3	1088	4	_ou_thouse_
penthouses	15	4	661	4	_penthouses
poorhouses	15	4	529	4	po_orhouses
pothouses	14	4	904	4	po__thouses
powerhouses	19	5	247	4	powerhouses
redhorses	13	4	565	4	r__edhorses
rehouses	11	3	1211	4	r___ehouses
rondures	9	3	771	4	ro_nd__ures
rotundnesses	13	4	382	4	rotundnesses
roundabouts	14	5	158	4	roundabou_ts
roundedness	13	5	429	4	roundedness
roundheaded	17	5	216	4	roundheaded
roundheel	13	4	274	4	roundh__eel
roundheels	14	5	202	4	roundh_eels
roundness	10	4	701	4	round_nes_s
roundtables	14	9	225	4	roundtables
roundups	11	4	359	4	round__u_ps
roundwoods	15	5	289	4	roundwo_ods
roundworms	16	5	260	4	roundwo_rms
soukouses	13	4	410	4	sou__kouses
soundboxes	20	5	222	4	soundbo_xes
soundnesses	12	4	752	4	soundnesses
studhorses	14	5	219	4	stu_dhorses
tollhouses	13	4	455	4	to_llhouses
toolhouses	13	4	457	4	to_olhouses
townhouse	15	4	428	4	town_house_
underuses	10	3	991	4	__underuses
unhorses	11	3	845	4	__un_horses
unhouse	10	3	892	4	__un_house_
unhoused	12	3	815	4	__un_housed
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	71	8.486	17537.0
3	Display Results	71	71	0.046	1543.5
	(SQL Overall)	178691	71	8.952	19961.0