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

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

50 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
greenbriers	14	5	226	(None)
greenbrier	13	5	285	1	greenbrier_
greeneries	11	6	707	2	greenerie_s
greenbackers	21	5	202	3	greenbackers
greenflies	14	4	358	3	greenflie_s
greengrocers	16	6	135	3	greengrocers
greenier	9	3	871	3	green__ier_
greenies	9	3	1267	3	green__ie_s
greenmailers	15	6	150	3	greenmailers
grenadiers	12	4	259	3	gr_enadiers
reentries	9	3	1176	3	_reentrie_s
sweetbriers	16	5	150	3	sweetbriers
freebasers	15	4	300	4	free_basers
freebies	13	3	787	4	free_b_ie_s
gentries	9	13	1526	4	g__entrie_s
granaries	10	15	988	4	gr_anarie_s
greedier	10	3	608	4	gree__dier_
greegrees	11	4	285	4	gree_gr_ees
greenbacker	20	5	230	4	greenbacker_
greenbacks	19	5	348	4	greenb_acks
greenbelt	12	4	397	4	greenb__elt
greenbelts	13	5	245	4	greenb_elts
greenbugs	13	4	250	4	greenb__ugs
greener	8	31	1171	4	green___er_
greenery	12	26	592	4	green___ery
greenfield	15	5	215	4	green_field
greenfields	16	5	155	4	green_fields
greengages	13	4	340	4	greengage_s
greengrocer	15	6	178	4	greengrocer_
greengrocery	19	6	89	4	greengrocery
greenie	8	3	1012	4	green__ie__
greeniest	10	3	903	4	green__iest
greenings	11	26	666	4	green__ings
greenkeepers	19	6	171	4	greenkeepers
greenlets	10	4	470	4	green__lets
greenlings	12	4	359	4	green_lings
greenmailer	14	5	181	4	greenmailer_
greenmails	13	8	278	4	greenmai_ls
greenness	10	4	679	4	green__ness
greenrooms	13	5	251	4	green_rooms
greenwings	15	4	270	4	green_wings
greeters	9	26	1011	4	gree___ters
grenadier	11	4	409	4	gr_enadier_
preeners	10	27	1281	4	preen___ers
reembroiders	17	5	149	4	_reembroiders
reenters	8	29	1530	4	_reen__ters
rentiers	8	33	1176	4	_r_en_tiers
screenwriters	18	6	120	4	screenwriters
sweetbriars	16	5	123	4	sweetbriars
sweetbrier	15	5	180	4	sweetbrier_

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	50	9.266	16060.8
3	Display Results	50	50	0.030	1666.7
	(SQL Overall)	178691	50	9.749	18329.2