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

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

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.

83 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
grapey	12	60	1230	(None)
drapey	12	50	1058	1	drapey
grape	8	48	2466	1	grape_
grapery	13	45	795	1	grapery
grapes	9	51	2312	1	grapes
grapy	11	54	1643	1	grap_y
gripey	12	41	1120	1	gripey
crape	9	61	2844	2	crape_
craped	11	61	2052	2	craped
crapes	10	47	2769	2	crapes
crappy	15	44	680	2	crappy
crepey	13	51	1093	2	crepey
drape	8	53	1963	2	drape_
draped	10	53	1436	2	draped
draper	9	43	1569	2	draper
drapery	13	38	794	2	drapery
drapes	9	54	1965	2	drapes
gamey	11	53	2055	2	g_amey
gape	7	51	3451	2	g_ape_
gaped	9	61	2353	2	g_aped
gaper	8	61	2512	2	g_aper
gapes	8	60	3082	2	g_apes
gappy	13	62	1203	2	g_appy
gapy	10	63	2091	2	g_ap_y
garvey	13	12	787	2	garvey
grabby	14	33	618	2	grabby
graben	9	41	972	2	graben
grace	8	51	2454	2	grace_
graced	10	52	1790	2	graced
graces	9	45	2349	2	graces
grade	7	51	2609	2	grade_
graded	9	49	1955	2	graded
grader	8	49	1969	2	grader
grades	8	49	2631	2	grades
grainy	10	39	1421	2	grainy
granny	10	43	1116	2	granny
graph	11	53	1561	2	grap_h
graphed	14	9	847	2	graphed
graphs	12	45	1015	2	graphs
grapier	10	37	1260	2	grapier
grapnel	10	3	560	2	grapnel
grappa	11	39	644	2	grappa
grasped	11	40	906	2	grasped
grasper	10	38	979	2	grasper
grassy	10	61	909	2	grassy
grate	6	49	3288	2	grate_
grated	8	45	2392	2	grated
grater	7	46	2544	2	grater
grates	7	54	2989	2	grates
graupel	10	3	413	2	graupel
grave	9	46	2487	2	grave_
graved	11	48	1881	2	graved
gravel	10	53	1382	2	gravel
gravely	14	46	906	2	gravely
graven	10	45	1352	2	graven
graver	10	50	1859	2	graver
graves	10	46	2400	2	graves
gravy	12	55	1211	2	gra_vy
gray	8	53	2989	2	gra__y
grayed	11	54	1564	2	grayed
grayer	10	60	1454	2	grayer
grayly	13	28	796	2	grayly
graze	15	58	2005	2	graze_
grazed	17	41	1591	2	grazed
grazer	16	48	1576	2	grazer
grazes	16	45	1964	2	grazes
grey	8	56	2404	2	gr__ey
gripe	8	46	2296	2	gripe_
griped	10	41	1471	2	griped
griper	9	41	1461	2	griper
gripes	9	46	1987	2	gripes
grippy	14	44	776	2	grippy
gripy	11	51	1525	2	grip_y
grope	8	48	2161	2	grope_
groped	10	75	1505	2	groped
groper	9	45	1725	2	groper
gropes	9	52	2040	2	gropes
rape	6	50	4163	2	_rape_
raped	8	53	3462	2	_raped
raper	7	49	3275	2	_raper
rapes	7	57	4072	2	_rapes
ropey	10	60	2187	2	_ropey
trapes	8	50	2446	2	trapes

Search took 3 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	82551	0.376	475242.0
2	DLD Change Limit	82551	83	2.576	32046.2
3	Display Results	83	83	0.030	2766.7
	(SQL Overall)	178691	83	2.982	59923.2