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

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

78 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
blockhouses	22	5	250	(None)
blockhouse	21	5	273	1	blockhouse_
backhouses	21	4	574	2	b_ackhouses
backhouse	20	4	614	3	b_ackhouse_
blockbusts	20	5	222	3	block_busts
boathouses	15	4	592	3	b_oathouses
bunkhouses	19	12	339	3	b_unkhouses
cockhorses	21	4	394	3	_cockhorses
cookhouses	19	4	460	3	_cookhouses
deckhouses	20	8	349	3	_deckhouses
flophouses	18	5	396	3	flo_phouses
longhouses	14	4	498	3	_longhouses
workhouses	20	4	489	3	_workhouses
alehouses	12	4	658	4	al__ehouses
almshouses	15	5	267	4	al_mshouses
backhoes	19	3	854	4	b_ackho__es
baghouses	15	4	546	4	b__aghouses
bakehouses	19	13	445	4	b_akehouses
bathhouses	18	4	419	4	b_athhouses
beadhouses	16	4	429	4	b_eadhouses
bedehouses	16	4	409	4	b_edehouses
biocenoses	14	4	397	4	bioceno_ses
birdhouses	16	4	332	4	b_irdhouses
blackbodies	22	5	249	4	blackbodies
blacknesses	19	4	499	4	blacknesses
blackouts	17	4	515	4	black_ou_ts
blockades	18	4	411	4	block__ades
blockages	18	4	406	4	block__ages
blockbust	19	4	305	4	block_bus_t
blockbusted	22	5	136	4	block_busted
blockbuster	21	5	169	4	block_buster
blockbusters	22	5	161	4	block_busters
blockheads	22	8	270	4	blockh_eads
bloodhounds	18	5	135	4	bloodhounds
blouses	9	40	1446	4	bl____ouses
blowholes	17	4	447	4	blo_who_les
boathouse	14	4	594	4	b_oathouse_
booklouse	15	4	321	4	b_ooklouse_
brochures	16	4	441	4	broc_h_ures
buckhounds	22	5	251	4	b_uckhounds
bughouses	15	4	474	4	b__ughouses
bunkhouse	18	12	365	4	b_unkhouse_
chophouses	20	4	514	4	cho_phouses
chouses	12	51	1781	4	___c_houses
clubhouses	17	4	284	4	cl_ubhouses
cockhorse	20	4	404	4	_cockhorse_
cookhouse	18	4	493	4	_cookhouse_
deckhouse	19	7	347	4	_deckhouse_
doghouses	14	4	535	4	_do_ghouses
dollhouses	14	4	405	4	_dollhouses
dosshouses	14	4	358	4	_dosshouses
flophouse	17	4	410	4	flo_phouse_
glasshouses	15	5	246	4	glasshouses
hothouses	15	4	776	4	_ho_thouses
icehouses	14	4	501	4	__icehouses
kolkhoses	15	4	349	4	_kolkho_ses
lobscouses	14	5	212	4	_lobscouses
lockboxes	24	5	345	4	_lockbo_xes
lockouts	14	4	549	4	_lock_ou_ts
longhouse	13	4	540	4	_longhouse_
outhouses	12	3	1066	4	__outhouses
packhorses	21	4	336	4	_packhorses
pilothouses	16	9	321	4	pilo_thouses
playhouses	18	4	387	4	pl_ayhouses
poorhouses	15	4	529	4	_poorhouses
pothouses	14	4	904	4	_po_thouses
roadhouses	14	4	450	4	_roadhouses
rockhounds	20	5	219	4	_rockhounds
rockroses	15	4	556	4	_rockro_ses
smokehouses	20	6	220	4	smokehouses
soukouses	13	4	410	4	_souk_ouses
storehouses	14	5	383	4	storehouses
tollhouses	13	4	455	4	_tollhouses
toolhouses	13	4	457	4	_toolhouses
townhouses	16	5	385	4	_townhouses
whorehouses	20	5	333	4	whorehouses
workhorses	20	4	365	4	_workhorses
workhouse	19	4	525	4	_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	148819	0.436	409841.7
2	DLD Change Limit	148819	78	8.923	16678.1
3	Display Results	78	78	0.046	1695.7
	(SQL Overall)	178691	78	9.405	18999.6