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

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

72 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
parsnips	12	4	553	(None)
parsnip	11	4	632	1	parsnip_
palships	15	4	621	2	palships
warships	16	4	755	2	warships
airships	13	4	771	3	airships
arsenics	10	5	676	3	_arsenics
arshins	10	3	1257	3	_arshins
arsines	7	35	1881	3	_arsines
arsis	5	57	2242	3	_ars_i_s
baronies	10	3	1502	3	baronies
carnies	9	41	2396	3	car_nies
catnips	11	9	589	3	ca_tnips
earlships	14	4	476	3	earlships
hardships	18	4	564	3	hardships
harelips	13	4	521	3	harelips
palship	14	4	683	3	palship_
palsies	9	44	2027	3	pals_ies
panics	10	38	1536	3	pa__nics
pansies	9	45	2198	3	pans_ies
parangs	10	43	1437	3	paran_gs
paranoias	11	4	1044	3	paranoias
paranoics	13	4	765	3	paranoics
paranoids	12	4	891	3	paranoids
parasails	11	4	758	3	parasails
parboils	12	3	743	3	parboils
pardners	11	26	919	3	pardners
parents	9	34	1812	3	paren_ts
paresis	9	33	1509	3	paresi_s
paretics	12	23	1244	3	paretics
parfaits	13	4	691	3	parfaits
pargings	12	34	1016	3	pargings
paries	8	47	4251	3	par__ies
parings	10	42	1921	3	parin_gs
paris	7	51	4594	3	par__i_s
parities	10	5	2297	3	parities
parkings	15	36	1068	3	parkings
parodies	11	3	1369	3	parodies
paronyms	15	4	655	3	paronyms
parosmias	13	4	578	3	parosmias
parotids	11	26	1041	3	parotids
parries	9	39	2584	3	par_ries
parsecs	11	42	992	3	pars_ecs
parsers	9	41	1815	3	pars_ers
parses	8	55	3470	3	pars__es
parsing	10	38	1955	3	pars_ing
parsleys	13	3	508	3	parsleys
parslied	11	3	782	3	parslied
parsonic	12	3	970	3	parsoni_c
parsonish	14	4	632	3	parsonish
parsons	9	35	1687	3	pars_ons
parties	9	32	3086	3	par_ties
partings	11	35	1373	3	partings
partners	10	27	1113	3	partners
parvis	11	61	1480	3	par_vi_s
passings	11	40	987	3	passings
pasties	9	45	2981	3	pa_sties
pastils	9	44	1617	3	pa_stils
pastis	8	49	2432	3	pa_sti_s
patsies	9	39	1948	3	pats_ies
paynims	14	3	497	3	pa_ynims
pogonips	13	4	438	3	pogonips
preships	15	3	931	3	preships
pursuits	10	4	504	3	pursuits
sarsnets	8	3	678	3	sarsnets
snips	7	58	1801	3	___snips
starships	14	4	766	3	starships
tarsias	7	40	1337	3	tars_ias
tinsnips	10	4	373	3	tinsnips
turnips	9	3	501	3	tur_nips
wardships	18	4	458	3	wardships
warship	15	4	783	3	warship_
worships	16	4	710	3	worships

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.423	422437.4
2	DLD Change Limit	146162	72	6.580	22213.1
3	Display Results	72	72	0.030	2400.0
	(SQL Overall)	178691	72	7.033	25407.5