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

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

88 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
prinking	15	32	1245	(None)
drinking	14	30	891	1	drinking
pinking	14	39	1894	1	p_inking
plinking	15	36	1124	1	plinking
pranking	15	38	1338	1	pranking
pricking	17	32	1260	1	pricking
printing	11	32	1608	1	printing
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
dinking	13	36	1828	2	_dinking
drinkings	15	24	477	2	drinkings
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
paiking	14	38	1481	2	pai_king
paining	10	39	2024	2	pain_ing
painting	11	36	1442	2	painting
peining	10	46	1915	2	pein_ing
picking	16	34	1833	2	p_icking
piking	13	37	1964	2	p_i_king
pinging	11	34	1955	2	p_inging
pining	9	37	2653	2	p_in_ing
pinkings	15	33	814	2	p_inkings
pinning	10	34	1785	2	p_inning
planking	15	35	1301	2	planking
plonking	15	35	856	2	plonking
plunking	15	32	848	2	plunking
poinding	12	25	1000	2	poinding
pointing	11	28	1368	2	pointing
prancing	13	26	1216	2	prancing
pranging	12	30	1272	2	pranging
pricing	12	34	1734	2	pri_cing
prickings	18	31	565	2	prickings
prickling	18	3	653	2	prickling
priding	11	33	1754	2	pri_ding
prigging	13	29	909	2	prigging
prilling	11	34	1341	2	prilling
priming	12	34	1737	2	pri_ming
primming	15	26	817	2	primming
primping	15	33	889	2	primping
printings	12	26	810	2	printings
prising	10	33	2145	2	pri_sing
prissing	11	30	1145	2	prissing
prizing	19	35	1468	2	pri_zing
pronging	12	35	1184	2	pronging
pruning	10	3	1173	2	prun_ing
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
springing	13	3	874	2	springing
sprinkling	17	4	382	2	sprinkling
sprinting	12	3	1003	2	sprinting
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
uplinking	16	3	462	2	uplinking
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 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.390	458182.1
2	DLD Change Limit	121059	88	3.436	35232.5
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	3.859	46305.0