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

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

47 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
greenhearts	15	5	208	(None)
greenheart	14	5	318	1	greenheart_
greenheads	15	4	299	2	greenhea_ds
greenbelts	13	5	245	3	greenbe_lts
greenhead	14	4	316	3	greenhea__d
greenhorns	14	5	287	3	greenh_orns
greenlets	10	4	470	3	greenle__ts
greenswards	16	5	157	3	greenswards
sweethearts	17	5	138	3	sweethearts
freehearted	18	5	311	4	free_hearted
greathearted	17	6	204	4	greathearted
greenbacks	19	5	348	4	green_backs
greenbelt	12	4	397	4	greenbe_lt_
greener	8	31	1171	4	green_e_r__
greeneries	11	6	707	4	green_eries
greenery	12	26	592	4	green_e_r_y
greenest	9	3	1262	4	green_e_st_
greengages	13	4	340	4	green_gages
greenhorn	13	4	314	4	greenh_or_n
greenhouses	15	5	324	4	greenhouses
greenier	9	3	871	4	greenie_r__
greenies	9	3	1267	4	greenie___s
greeniest	10	3	903	4	greenie_st_
greenlet	9	4	851	4	greenle__t_
greenlights	16	5	202	4	greenlights
greenmails	13	8	278	4	green_mails
greenness	10	4	679	4	greenne__ss
greennesses	12	4	703	4	greennesses
greensands	12	5	257	4	green_sands
greenshanks	19	5	151	4	greenshanks
greensward	15	5	173	4	greenswar_d
greenways	16	4	343	4	green_wa_ys
greeters	9	26	1011	4	gree_te_r_s
preenacts	13	4	584	4	preen__acts
preeners	10	27	1281	4	preen_e_r_s
preheats	13	3	941	4	pr_e_hea_ts
preinserts	12	4	397	4	preinse_rts
recharts	13	3	766	4	_r_ech_arts
recheats	13	3	919	4	_r_echea_ts
reenacts	10	3	699	4	_reen__acts
reenters	8	29	1530	4	_reente_r_s
reentrants	10	4	466	4	_reentrants
rehears	10	33	1277	4	_r_e_hear_s
reheats	10	45	1352	4	_r_e_hea_ts
reinserts	9	4	642	4	_reinse_rts
sweetheart	16	6	291	4	sweetheart_
treenwares	13	4	395	4	treen_wares

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.453	394461.4
2	DLD Change Limit	148819	47	9.436	15771.4
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	9.905	18040.5