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

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

58 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
agraffes	15	5	304	(None)
agrafes	11	3	752	1	agra_fes
agraffe	14	4	333	1	agraffe_
agrafe	10	3	809	2	agra_fe_
gaffes	13	48	1110	2	_g_affes
giraffes	15	4	260	2	giraffes
griffes	14	36	792	2	_griffes
abrades	10	3	1207	3	abra_des
aerates	7	46	2749	3	aera_tes
aerifies	11	13	1339	3	aerifies
agapes	9	52	1241	3	ag_a_pes
agaroses	9	3	882	3	agaroses
agates	7	61	2134	3	ag_a_tes
agaves	10	46	1151	3	ag_a_ves
aggrades	11	3	586	3	aggra_des
agnates	8	28	1319	3	agna_tes
agrees	7	49	1532	3	agr__ees
airfares	11	4	669	3	airfares
arables	9	18	1497	3	a_rables
arames	8	46	2257	3	a_ra_mes
argufies	12	4	374	3	argufies
arranges	9	3	941	3	arranges
arrases	7	12	1454	3	arra_ses
carafes	12	50	1570	3	cara_fes
draffs	13	61	790	3	_draff_s
gaffe	12	41	1165	3	_g_affe_
gaffed	14	42	1020	3	_g_affed
gaffer	13	43	1013	3	_g_affer
gaffers	14	42	871	3	_g_affers
gaffs	12	49	1465	3	_g_aff_s
garages	9	3	1411	3	gara_ges
giraffe	14	4	299	3	giraffe_
graces	9	45	2349	3	_gra_ces
grades	8	49	2631	3	_gra_des
grafted	12	41	1022	3	_grafted
grafter	11	42	1115	3	_grafter
grafters	12	40	919	3	_grafters
grafts	10	50	1325	3	_gra_fts
grammes	12	36	1132	3	_grammes
granges	9	35	1652	3	_granges
grapes	9	51	2312	3	_gra_pes
grasses	8	41	1734	3	_grasses
grates	7	54	2989	3	_gra_tes
graves	10	46	2400	3	_gra_ves
gravies	11	3	1409	3	_gravies
grazes	16	45	1964	3	_gra_zes
griffe	13	43	809	3	_griffe_
griffs	13	39	899	3	_griff_s
gruffed	15	4	494	3	_gruffed
gruffer	14	7	579	3	_gruffer
gruffest	15	4	459	3	_gruffest
gruffs	13	33	745	3	_gruff_s
piaffes	15	11	505	3	_piaffes
raffles	13	36	1184	3	__raffles
raffs	11	50	1752	3	__raff_s
ruffes	12	41	1242	3	__ruffes
strafes	10	45	1600	3	stra_fes
truffes	13	5	677	3	_truffes

Search took 8 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	146162	0.423	422437.4
2	DLD Change Limit	146162	58	7.186	20339.8
3	Display Results	58	58	0.033	1757.6
	(SQL Overall)	178691	58	7.642	23382.8