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

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

70 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
drinking	14	30	891	(None)
dinking	13	36	1828	1	d_inking
drinkings	15	24	477	1	drinkings
prinking	15	32	1245	1	prinking
blinking	15	35	1062	2	blinking
boinking	15	37	842	2	boinking
bricking	17	39	1140	2	bricking
bringing	12	30	1127	2	bringing
brining	10	32	1647	2	brin_ing
brisking	15	32	947	2	brisking
chinking	18	32	1089	2	chinking
clinking	15	36	1166	2	clinking
cranking	15	46	1307	2	cranking
cricking	17	34	1265	2	cricking
cringing	12	33	1138	2	cringing
crinkling	16	14	586	2	crinkling
dicking	15	36	1761	2	d_icking
diking	12	43	2024	2	d_i_king
dinging	10	36	1861	2	d_inging
dining	8	45	2513	2	d_in_ing
dinning	9	34	1655	2	d_inning
dinting	9	35	2055	2	d_inting
dirking	13	38	1260	2	d_irking
disking	13	46	1549	2	d_isking
draining	10	33	1267	2	drain_ing
dribbing	14	32	588	2	dribbing
drifting	13	33	873	2	drifting
drilling	10	33	1198	2	drilling
dripping	14	27	803	2	dripping
driving	12	39	1071	2	dri_ving
droning	9	30	1372	2	dron_ing
drouking	14	3	644	2	drouking
dunking	13	38	1326	2	d_unking
dwining	12	26	929	2	dwin_ing
finking	15	40	1660	2	_finking
franking	16	43	1086	2	franking
fringing	13	30	1090	2	fringing
frisking	16	26	836	2	frisking
grinding	11	3	986	2	grinding
grinning	10	3	786	2	grinning
inking	11	51	1905	2	__inking
jinking	19	36	1354	2	_jinking
kinking	11	36	1515	2	_kinking
linking	12	38	1825	2	_linking
oinking	12	37	1471	2	_oinking
pinking	14	39	1894	2	_pinking
plinking	15	36	1124	2	plinking
pranking	15	38	1338	2	pranking
pricking	17	32	1260	2	pricking
printing	11	32	1608	2	printing
ranking	12	43	2088	2	_ranking
reinking	13	3	1102	2	reinking
ricking	14	39	2023	2	_ricking
ringing	9	35	2128	2	_ringing
rinning	8	32	1674	2	_rinning
rinsing	8	25	1611	2	_rinsing
risking	12	39	1424	2	_risking
shrinking	17	3	565	2	shrinking
sinking	12	33	2054	2	_sinking
skinking	12	29	977	2	skinking
slinking	13	34	1298	2	slinking
stinking	13	31	1354	2	stinking
swinking	16	34	1032	2	swinking
thinking	16	28	986	2	thinking
tricking	15	27	1451	2	tricking
trining	8	29	1921	2	trin_ing
winking	15	33	1796	2	_winking
wricking	18	34	949	2	wricking
wringing	13	27	962	2	wringing
wrinkling	17	14	495	2	wrinkling

Search took 6 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	70	4.736	25561.4
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	5.142	34751.3