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

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

65 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
prinkers	14	30	1038	(None)
drinkers	13	27	782	1	drinkers
pinkers	13	41	1860	1	p_inkers
plinkers	14	30	939	1	plinkers
prickers	16	37	1067	1	prickers
prinker	13	34	1274	1	prinker_
printers	10	32	1490	1	printers
blinkers	14	38	850	2	blinkers
briners	9	43	1563	2	brin_ers
bringers	11	28	1107	2	bringers
clinkers	14	33	983	2	clinkers
cringers	11	25	1187	2	cringers
drinker	12	34	948	2	drinker_
frankers	15	34	835	2	frankers
friskers	15	33	737	2	friskers
grinders	10	34	1042	2	grinders
grinners	9	28	804	2	grinners
inkers	10	40	1883	2	__inkers
jinkers	18	35	1181	2	_jinkers
linkers	11	43	1771	2	_linkers
painters	10	30	1302	2	painters
pickers	15	37	1809	2	p_ickers
pikers	12	47	1739	2	p_i_kers
pincers	11	39	1650	2	p_incers
pinders	10	37	2047	2	p_inders
pingers	10	40	2074	2	p_ingers
pinkens	13	41	964	2	p_inkens
pinker	12	53	2244	2	p_inker_
pinkeys	16	37	821	2	p_inkeys
pinners	9	35	1860	2	p_inners
plinker	13	40	1096	2	plinker_
plunkers	14	32	833	2	plunkers
pointers	10	30	1372	2	pointers
prancers	12	32	1033	2	prancers
pricers	11	39	1506	2	pri_cers
pricker	15	40	1341	2	pricker_
prickets	16	32	908	2	prickets
priers	8	45	2119	2	pri__ers
primers	11	42	1567	2	pri_mers
princes	11	30	1514	2	prince_s
princess	12	26	680	2	princess
prinked	14	34	1216	2	prinke_d
prinks	12	43	1538	2	prink__s
printer	9	39	1730	2	printer_
printery	13	31	843	2	printery
prizers	18	39	1184	2	pri_zers
pruners	9	37	1072	2	prun_ers
punkers	13	37	1485	2	p_unkers
rankers	11	32	1746	2	_rankers
ringers	8	39	2295	2	_ringers
rinsers	7	38	1574	2	_rinsers
riskers	11	40	1199	2	_riskers
shrinkers	16	20	538	2	shrinkers
sinkers	11	36	1854	2	_sinkers
skinkers	11	29	818	2	skinkers
springers	12	30	998	2	springers
sprinklers	16	4	297	2	sprinklers
sprinters	11	32	936	2	sprinters
stinkers	12	31	1113	2	stinkers
thinkers	15	30	870	2	thinkers
tinkers	11	35	1714	2	_tinkers
trickers	14	38	1281	2	trickers
trinkets	12	3	714	2	trinkets
winkers	14	35	1711	2	_winkers
wringers	12	31	1007	2	wringers

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	65	3.296	36729.1
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	3.735	47842.3