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

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

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.

82 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
parkette	14	13	802	(None)
parkettes	15	13	759	1	parkettes
ariette	7	3	1237	2	_ariette
barbette	12	4	911	2	barbette
barrette	10	3	978	2	barrette
palette	9	36	1398	2	pa_lette
pallette	10	3	951	2	pallette
palmette	12	4	773	2	palmette
pargetted	13	4	566	2	pargetted
proette	9	3	1236	2	p_roette
arete	5	60	3135	3	_ar_e_te
arietta	7	8	890	3	_arietta
ariettes	8	4	1135	3	_ariettes
baguette	11	10	593	3	baguette
barbettes	13	4	816	3	barbettes
barquette	20	6	490	3	barquette
barrettes	11	4	906	3	barrettes
burette	9	3	985	3	bur_ette
casette	9	3	1039	3	ca_sette
cassette	10	4	781	3	cassette
corvette	13	3	809	3	corvette
curette	9	3	978	3	cur_ette
darkest	12	25	1262	3	darkest_
diskette	13	4	675	3	diskette
epaulette	11	4	278	3	epaulette
galette	8	42	1270	3	ga_lette
garotte	8	6	870	3	gar_otte
garrotte	9	6	568	3	garrotte
gazette	17	35	736	3	ga_zette
jockette	21	6	503	3	jockette
layette	10	3	713	3	la_yette
maquette	19	4	611	3	maquette
market	12	32	2604	3	marke_t_
marketed	15	3	732	3	marketed
marketeer	15	4	359	3	marketeer
marketer	14	3	738	3	marketer
markets	13	33	1403	3	marke_ts
navette	10	3	698	3	na_vette
packet	14	47	2650	3	packe_t_
packeted	17	14	828	3	packeted
packets	15	51	1477	3	packe_ts
paillette	11	4	524	3	paillette
paleate	9	41	2000	3	pa_leate
palettes	10	31	1283	3	pa_lettes
pallettes	11	4	880	3	pallettes
palmettes	13	4	688	3	palmettes
palmetto	12	4	498	3	palmetto
pancetta	12	4	465	3	pancetta
parakeet	14	4	1052	3	parakeet_
parakeets	15	4	510	3	parakeets
parakite	14	4	1042	3	parakite
parasite	10	3	1484	3	parasite
pardee	9	39	2202	3	parde__e
parent	8	32	3042	3	par_ent_
parented	11	9	1221	3	par_ented
parents	9	34	1812	3	par_ents
paretic	11	30	1667	3	par_etic
pareve	11	46	1301	3	par_e_ve
parget	9	45	2939	3	parge_t_
pargeted	12	3	868	3	pargeted
pargets	10	52	1519	3	parge_ts
parietal	10	4	877	3	parietal
parietes	10	7	1454	3	parietes
parkade	14	3	758	3	park_ade
parked	13	44	2514	3	parke__d
parker	12	41	2137	3	parke__r
parkers	13	38	1687	3	parke_rs
parklike	13	3	749	3	parklike
parlante	10	3	969	3	parlante
parterre	10	3	699	3	parterre
partite	9	3	1713	3	par_tite
parvenue	13	4	492	3	parvenue
paupiette	13	4	260	3	paupiette
permeate	12	3	1161	3	permeate
pipette	11	3	794	3	p_ipette
pirouette	11	4	445	3	pirouette
pretty	11	5	1087	3	p_r_etty
proettes	10	3	1276	3	p_roettes
quartette	18	4	396	3	quartette
raclette	10	4	764	3	raclette
strette	7	3	1076	3	str_ette
syrette	10	3	718	3	syr_ette

Search took 8 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	146162	0.420	425454.8
2	DLD Change Limit	146162	82	7.516	19446.8
3	Display Results	82	82	0.030	2733.3
	(SQL Overall)	178691	82	7.966	22431.7