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

Here are the results of your fuzzy-string dictionary search for “picaninny” with Change Limit: [1] [2] [3] [4] [5]

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.

64 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
picaninny	16	5	118	(None)
pickaninny	21	5	82	1	pickaninny
picaninnies	15	7	161	3	picaninnies
picnicky	21	4	217	3	pic_nicky
cairny	11	55	782	4	__ca_irny
canine	8	38	2670	4	__cani_ne
canines	9	37	2403	4	__canines
caning	9	41	2862	4	__cani_ng
caninity	13	3	806	4	__caninity
cannily	12	3	926	4	__cannily
canning	10	36	2013	4	__canning
canny	10	58	1769	4	__ca__nny
canonry	12	3	592	4	__canonry
chicaning	17	4	516	4	chicani_ng
dicliny	13	3	767	4	dic_li_ny
inanity	10	3	950	4	_inani_ty
ninny	8	45	1493	4	____ninny
painty	11	47	1475	4	p__a_inty
panicky	18	3	385	4	p__anicky
panini	8	3	1427	4	p__ani_ni
panino	8	3	1568	4	p__ani_no
panning	10	40	1939	4	p__anning
pecuniary	16	5	261	4	pecuniary
pianic	10	37	1412	4	pi_ani__c
pianism	11	6	1103	4	pi_ani_sm
pianisms	12	4	901	4	pi_anisms
pianist	9	6	1510	4	pi_ani_st
pianists	10	4	901	4	pi_anists
picadillo	14	6	213	4	picadillo
picante	11	3	1052	4	pica__nte
picaroon	12	4	565	4	picaroon_
picaroons	13	4	467	4	picaroons
picayune	15	4	201	4	pica_yune
picayunes	16	4	205	4	picayunes
pickaninnies	20	13	78	4	pickaninnies
pickaxing	25	4	310	4	pickaxi_ng
picking	16	34	1833	4	pic_ki_ng
pickings	17	35	938	4	pic_kings
pickling	17	23	920	4	pickli_ng
picnic	12	34	1026	4	pic_ni__c
picnics	13	29	734	4	pic_ni_cs
picolin	11	3	1088	4	picoli_n_
picoline	12	3	1085	4	picoli_ne
picolines	13	3	962	4	picolines
picolins	12	3	985	4	picoli_ns
picoting	13	3	888	4	picoti_ng
pinchpenny	22	5	93	4	pinchpenny
pining	9	37	2653	4	pi__ni_ng
pinion	8	38	1589	4	pi__nion_
pinions	9	34	1360	4	pi__nions
pinning	10	34	1785	4	pi_nni_ng
pinny	10	52	2206	4	p____inny
pirating	11	3	1451	4	pirati_ng
plainly	12	3	647	4	p_la_inly
planing	10	34	1825	4	p_lani_ng
planning	11	36	1022	4	p_lanning
plication	13	3	1168	4	plication_
plications	14	3	1049	4	plications
recaning	11	14	1669	4	recani_ng
scanning	11	33	1077	4	_scanning
uncannily	14	4	345	4	uncannily
uncanny	12	4	511	4	unca__nny
vicariant	14	4	646	4	vicariant
vicinity	16	4	581	4	vicini_ty

Search took 14 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	165329	0.466	383457.1
2	DLD Change Limit	165329	64	13.220	12506.0
3	Display Results	64	64	0.013	4923.1
	(SQL Overall)	178691	64	13.699	13044.1