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

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

70 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
greenhouses	15	5	324	(None)
greenhouse	14	5	330	1	greenhouse_
treehouses	13	4	519	2	tree_houses
gatehouses	14	4	526	3	gate_houses
greenhorns	14	5	287	3	greenho_rns
greennesses	12	4	703	3	greennesses
henhouses	15	4	617	3	__henhouses
rehouses	11	3	1211	3	_r_e_houses
treehouse	12	4	503	3	tree_house_
wheelhouses	20	10	248	3	wheelhouses
alehouses	12	4	658	4	_ale_houses
bakehouses	19	13	445	4	bake_houses
barrelhouses	17	5	157	4	barrelhouses
beadhouses	16	4	429	4	_beadhouses
bedehouses	16	4	409	4	_bedehouses
deckhouses	20	8	349	4	_deckhouses
firehouses	16	13	515	4	fire_houses
freenesses	13	3	987	4	freen_esses
funhouses	15	4	459	4	__funhouses
gashouses	13	4	576	4	g__ashouses
gatehouse	13	4	516	4	gate_house_
geniuses	9	3	593	4	g__en_iuses
genoises	9	3	925	4	g__en_oises
genuses	8	35	1088	4	g__en__uses
glasshouses	15	5	246	4	glasshouses
greenbugs	13	4	250	4	green_bu_gs
greeneries	11	6	707	4	green_eries
greenflies	14	4	358	4	green_flies
greengages	13	4	340	4	green_gages
greenheads	15	4	299	4	greenh_eads
greenhearts	15	5	208	4	greenhearts
greenhorn	13	4	314	4	greenho__rn
greenies	9	3	1267	4	green___ies
greenness	10	4	679	4	green_nes_s
greenrooms	13	5	251	4	greenro_oms
greenstones	12	5	372	4	greenstones
greenstuffs	18	9	112	4	greenstuffs
greenwashes	18	5	243	4	greenwashes
greenwoods	15	5	302	4	greenwo_ods
greyhounds	18	5	158	4	gr_eyhounds
greynesses	14	4	632	4	greyn_esses
grouses	8	46	1654	4	gr____ouses
guardhouses	16	6	211	4	guardhouses
henhouse	14	4	557	4	__henhouse_
icehouses	14	4	501	4	_ice_houses
penthouses	15	4	661	4	_penthouses
pesthouses	15	4	624	4	_pesthouses
porterhouses	17	5	264	4	porterhouses
powerhouses	19	5	247	4	powerhouses
prechooses	17	11	640	4	pr_echooses
preciouses	14	4	688	4	pr_eciouses
preexposes	21	4	361	4	preexpo_ses
rearouses	9	3	1020	4	_r_earouses
rechooses	14	10	761	4	_r_echooses
redhorses	13	4	565	4	_r_edhorses
reechoes	13	3	841	4	_reecho__es
reenforces	15	4	349	4	_reenforces
reexposes	18	4	475	4	_reexpo_ses
rehouse	10	3	1177	4	_r_e_house_
rehoused	12	3	961	4	_r_e_housed
reinfuses	12	4	563	4	_rein_fuses
roadhouses	14	4	450	4	_roadhouses
roundhouses	15	10	299	4	_roundhouses
teahouses	12	4	651	4	__teahouses
townhouses	16	5	385	4	_townhouses
unhouses	11	3	870	4	___unhouses
warehouses	16	4	581	4	ware_houses
wellhouses	16	4	378	4	_wellhouses
wheelhorses	20	11	197	4	wheelhorses
wheelhouse	19	10	257	4	wheelhouse_

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	70	8.190	18170.8
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	8.640	20681.8