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

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

72 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
granting	10	35	1452	(None)
grafting	13	31	962	1	grafting
grating	9	39	2318	1	gra_ting
grunting	10	26	958	1	grunting
ranting	8	40	2541	1	_ranting
anting	7	58	2702	2	__anting
branding	12	25	1368	2	branding
branning	11	29	1109	2	branning
canting	10	47	2590	2	_canting
chanting	14	34	1353	2	chanting
crafting	14	37	1017	2	crafting
craning	10	36	2030	2	cran_ing
cranking	15	46	1307	2	cranking
crating	10	37	2520	2	cra_ting
drafting	13	33	941	2	drafting
dratting	10	38	966	2	dratting
franking	16	43	1086	2	franking
fronting	12	3	1044	2	fronting
gaiting	9	37	1658	2	g_aiting
ganging	10	32	1619	2	g_anging
garoting	10	5	1070	2	garoting
gasting	9	50	2276	2	g_asting
gating	8	48	2695	2	g_a_ting
glancing	12	4	706	2	glancing
glinting	10	32	1005	2	glinting
grabbing	14	26	731	2	grabbing
gracing	11	32	1644	2	gra_cing
gradating	12	3	732	2	gradating
grading	10	39	1871	2	gra_ding
graining	10	28	1318	2	graining
graphing	15	3	853	2	graphing
grasping	12	34	883	2	grasping
grassing	10	33	1197	2	grassing
gratin	7	45	2058	2	gra_tin_
gratine	8	47	1919	2	gra_tine
gratings	10	39	1076	2	gra_tings
gratins	8	41	1918	2	gra_tins
graving	12	31	1456	2	gra_ving
graying	12	41	1588	2	gra_ying
grayling	13	3	800	2	grayling
grazing	18	35	1455	2	gra_zing
greeting	10	31	1235	2	greeting
grifting	13	29	926	2	grifting
grinding	11	3	986	2	grinding
grinning	10	3	786	2	grinning
gritting	10	30	998	2	gritting
groaning	10	24	1028	2	groan_ing
grouting	10	34	1079	2	grouting
gruntling	11	3	426	2	gruntling
gyrating	13	3	745	2	gyra_ting
hanting	11	41	2448	2	_hanting
orating	8	35	2032	2	ora_ting
panting	10	40	2542	2	_panting
planting	11	35	1538	2	planting
prancing	13	26	1216	2	prancing
pranging	12	30	1272	2	pranging
pranking	15	38	1338	2	pranking
prating	10	34	2445	2	pra_ting
printing	11	32	1608	2	printing
quanting	18	4	923	2	quanting
rafting	11	38	1575	2	_rafting
ranging	9	41	2026	2	_ranging
ranking	12	43	2088	2	_ranking
rating	7	49	3870	2	_ra_ting
ratting	8	38	2236	2	_ratting
regranting	12	3	832	2	regranting
renting	8	40	2685	2	_renting
scanting	11	39	1476	2	scanting
slanting	9	41	1509	2	slanting
trancing	11	28	1202	2	trancing
truanting	10	3	560	2	truanting
wanting	11	42	2017	2	_wanting

Search took 4 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	121059	0.406	440125.6
2	DLD Change Limit	121059	72	3.500	34588.3
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	3.936	45399.1