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

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

60 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
glinting	10	32	1005	(None)
flinting	12	34	1234	1	flinting
linting	8	38	2098	1	_linting
alining	8	19	1704	2	alin_ing
blinding	12	32	1016	2	blinding
blinking	15	35	1062	2	blinking
blunting	11	31	984	2	blunting
clinging	12	29	1091	2	clinging
clinking	15	36	1166	2	clinking
dinting	9	35	2055	2	_dinting
fainting	12	33	1216	2	fainting
feinting	12	34	1083	2	feinting
flinging	13	33	1005	2	flinging
flirting	12	31	901	2	flirting
fliting	11	35	1461	2	fli_ting
flitting	12	30	1088	2	flitting
gaining	9	40	1566	2	gain_ing
gaiting	9	37	1658	2	gai_ting
gifting	12	38	1089	2	g_ifting
ginning	9	33	1398	2	g_inning
girting	9	31	1333	2	g_irting
gitting	9	32	1570	2	g_itting
glancing	12	4	706	2	glancing
gleeting	10	27	917	2	gleeting
gliding	10	39	1184	2	gli_ding
gliming	11	33	1013	2	gli_ming
glintier	9	4	570	2	glintier
glitzing	19	3	497	2	glitzing
gloating	10	26	1146	2	gloating
glouting	10	37	969	2	glouting
glutting	10	24	764	2	glutting
granting	10	35	1452	2	granting
grifting	13	29	926	2	grifting
grinding	11	3	986	2	grinding
grinning	10	3	786	2	grinning
gritting	10	30	998	2	gritting
grunting	10	26	958	2	grunting
hinting	11	39	1922	2	_hinting
jointing	16	24	861	2	jointing
lifting	11	33	1327	2	_lifting
lilting	8	35	1538	2	_lilting
lining	7	45	2680	2	_lin_ing
linking	12	38	1825	2	_linking
listing	8	40	2059	2	_listing
lunting	8	38	1774	2	_lunting
minting	10	30	2081	2	_minting
painting	11	36	1442	2	painting
planting	11	35	1538	2	planting
plinking	15	36	1124	2	plinking
pointing	11	28	1368	2	pointing
printing	11	32	1608	2	printing
sainting	9	32	1573	2	sainting
slanting	9	41	1509	2	slanting
slinging	10	33	1286	2	slinging
slinking	13	34	1298	2	slinking
slitting	9	30	1258	2	slitting
splinting	12	3	819	2	splinting
stinting	9	34	1574	2	stinting
tainting	9	36	1358	2	tainting
tinting	8	46	2060	2	_tinting

Search took 5 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.390	458182.1
2	DLD Change Limit	121059	60	3.656	33112.4
3	Display Results	60	60	0.013	4615.4
	(SQL Overall)	178691	60	4.059	44023.4