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

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

67 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
glasshouses	15	5	246	(None)
glasshouse	14	5	241	1	glasshouse_
gashouses	13	4	576	2	g_a_shouses
almshouses	15	5	267	3	al_mshouses
dosshouses	14	4	358	3	_dosshouses
gashouse	12	4	569	3	g_a_shouse_
gatehouses	14	4	526	3	g_atehouses
guardhouses	16	6	211	3	guardhouses
oasthouses	13	4	497	3	_oasthouses
playhouses	18	4	387	3	pla_yhouses
washhouses	19	4	350	3	_washhouses
alehouses	12	4	658	4	__alehouses
almshouse	14	4	247	4	al_mshouse_
assholes	11	4	674	4	__assho_les
backhouses	21	4	574	4	_backhouses
baghouses	15	4	546	4	_ba_ghouses
bakehouses	19	13	445	4	_bakehouses
bathhouses	18	4	419	4	_bathhouses
beadhouses	16	4	429	4	bea_dhouses
blockhouses	22	5	250	4	blockhouses
boathouses	15	4	592	4	boa_thouses
cathouses	14	3	943	4	_ca_thouses
clubhouses	17	4	284	4	cl_ubhouses
dosshouse	13	4	371	4	_dosshouse_
farmhouses	18	4	401	4	_farmhouses
flashcubes	20	5	117	4	fla_shcubes
flashtubes	18	5	143	4	fla_shtubes
flophouses	18	5	396	4	fl_ophouses
gatehouse	13	4	516	4	g_atehouse_
gladioluses	13	5	162	4	gladioluses
gladstones	12	4	465	4	gladsto_nes
glasnosts	10	4	253	4	gla_sno_sts
glasses	8	44	1427	4	gla_s___ses
glassfuls	13	12	281	4	glass_fu_ls
glassies	9	40	1227	4	glass___ies
glassines	10	27	804	4	glass__ines
glassiness	11	24	599	4	glassines_s
glassinesses	12	5	524	4	glassinesses
glassless	10	4	387	4	glass_les_s
glasswares	14	4	321	4	glass_wares
glassworker	19	5	142	4	glassworker
glassworkers	20	5	122	4	glassworkers
glassworks	18	4	280	4	glasswo_rks
glassworms	16	5	250	4	glasswo_rms
glassworts	14	5	281	4	glasswo_rts
glossitises	12	5	307	4	glossitises
grasshopper	19	5	176	4	grasshopper
grasshoppers	20	6	167	4	grasshoppers
greenhouses	15	5	324	4	greenhouses
guardhouse	15	5	221	4	guardhouse_
jailhouses	20	4	300	4	_jailhouses
lassitudes	11	4	297	4	_lassitudes
lassoes	7	46	1385	4	_lass_o__es
lobscouses	14	5	212	4	_lobscouses
longhouses	14	4	498	4	_longhouses
madhouses	15	4	574	4	_ma_dhouses
masseuses	11	4	479	4	_mass_euses
oasthouse	12	4	477	4	_oasthouse_
passuses	10	3	677	4	_pass__uses
pesthouses	15	4	624	4	_pesthouses
playhouse	17	4	393	4	pla_yhouse_
roadhouses	14	4	450	4	roa_dhouses
statehouses	14	5	376	4	statehouses
taphouses	14	4	655	4	_ta_phouses
teahouses	12	4	651	4	tea__houses
warehouses	16	4	581	4	_warehouses
washhouse	18	4	380	4	_washhouse_

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.156	1145455.1
2	DLD Change Limit	148819	67	9.550	15583.1
3	Display Results	67	67	0.046	1456.5
	(SQL Overall)	178691	67	9.752	18323.5