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

Here are the results of your fuzzy-string dictionary search for “grenadier” with Change Limit: [1] [2] [3] [4]

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.

52 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
grenadier	11	4	409	(None)
grenadiers	12	4	258	1	grenadiers
greasier	9	29	808	2	gre_asier
greedier	10	3	608	2	gre_edier
grenade	9	3	841	2	grenad_e_
grenades	10	3	843	2	grenad_es
grenadine	11	4	564	2	grenadine
grenadines	12	4	516	2	grenadines
readier	8	31	1742	2	_re_adier
trendier	9	3	791	2	tren_dier
beadier	10	35	1391	3	_be_adier
bendier	10	31	1141	3	_ben_dier
brigadier	13	4	332	3	brigadier
creakier	14	32	833	3	cre_akier
creamier	12	31	906	3	cre_amier
creasier	10	32	1019	3	cre_asier
dreamier	11	28	729	3	dre_amier
drearier	9	29	792	3	dre_arier
freakier	15	24	648	3	fre_akier
gender	8	35	1793	3	g_en_d_er
gladier	9	38	1099	3	g__ladier
gleamier	11	4	491	3	gle_amier
grader	8	49	1969	3	gr__ad_er
granaries	10	15	988	3	granaries
grander	9	33	1587	3	gran_d_er
grapier	10	37	1260	3	gr__apier
grazier	17	36	1113	3	gr__azier
greaser	8	39	1308	3	gre_a_ser
greater	8	44	1649	3	gre_a_ter
greenbrier	13	5	285	3	greenbrier
greenier	9	3	871	3	gre_enier
grinder	9	33	1239	3	grin_d_er
grodier	9	3	967	3	gr__odier
grungier	10	3	498	3	grun_gier
headier	11	32	1295	3	_he_adier
leadier	8	32	1272	3	_le_adier
randier	8	36	1847	3	_ran_dier
reader	7	36	2829	3	_re_ad_er
readied	9	33	1662	3	_re_adied
readies	8	33	2470	3	_re_adies
recamier	12	3	760	3	_recamier
reedier	8	38	1530	3	_re_edier
render	7	40	2414	3	_ren_d_er
rentier	7	36	1822	3	_ren_tier
serenader	10	21	600	3	serenad_er
spendier	11	4	714	3	spen_dier
steadier	9	3	731	3	ste_adier
threadier	13	5	447	3	thre_adier
treader	8	41	1382	3	tre_ad_er
treadler	9	3	685	3	tre_adler
trendies	9	3	1221	3	tren_dies
unreadier	10	4	501	3	unre_adier

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	148641	0.173	1032896.0
2	DLD Change Limit	148641	52	8.656	17172.0
3	Display Results	52	52	0.030	1733.3
	(SQL Overall)	178691	52	8.859	20170.6