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

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

54 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
perfumeries	18	5	279	(None)
perfumers	16	8	371	2	perfumer__s
pentameries	15	5	475	3	pentameries
perfumer	15	7	455	3	perfumer___
perfumery	19	7	238	3	perfumer__y
perfumes	15	5	589	3	perfum___es
perimetries	15	4	778	3	per_imetries
peripheries	18	5	500	3	peripheries
perjuries	18	4	649	3	perju__ries
pruderies	12	4	787	3	p_r_uderies
aerometries	13	4	839	4	aer_ometries
costumeries	15	5	410	4	costumeries
creameries	14	4	667	4	_creameries
emeries	9	16	2002	4	_e___meries
ergometries	14	5	568	4	_ergometries
ferneries	12	3	904	4	fer__neries
hegumenies	16	5	318	4	he_gumenies
merceries	13	4	1004	4	mer__ceries
mercuries	13	4	727	4	mercu__ries
parquetries	22	5	412	4	parquetries
peddleries	14	10	407	4	pe_ddleries
pedleries	12	9	878	4	pe__dleries
peeries	9	36	2302	4	pe____eries
penuries	10	3	1166	4	pe_nu__ries
perdures	11	28	968	4	perdu__r_es
perfidies	15	4	660	4	perf__idies
performers	17	16	410	4	performer__s
perfume	14	4	650	4	perfum___e_
perfumed	16	5	454	4	perfum___ed
perfuming	17	8	405	4	perfum__ing
perfusates	15	4	399	4	perfu_sates
perfuses	13	5	866	4	perfu___ses
peripeties	14	4	839	4	per_ipeties
perjurers	18	22	446	4	perjurer__s
perjures	17	26	808	4	perju__r_es
permeases	13	4	710	4	per__meases
permeates	13	3	1177	4	per__meates
perries	9	32	2660	4	per____ries
perseveres	15	4	340	4	persever_es
perusers	10	32	880	4	per_user__s
plumberies	16	4	512	4	p__lumberies
plumerias	13	4	498	4	p__lumerias
poromerics	16	4	553	4	por_omerics
prepuberties	18	9	204	4	prepuberties
presumers	13	3	637	4	presumer__s
priggeries	14	4	499	4	p_riggeries
primaries	13	4	1083	4	p_r_imaries
printeries	12	4	1063	4	p_rinteries
pufferies	17	4	520	4	p_uf_feries
pyrometries	18	9	812	4	pyr_ometries
refineries	13	4	706	4	re_fineries
ruderies	9	3	1133	4	__r_uderies
spermaries	14	6	806	4	sper__maries
trumperies	14	4	445	4	_tr_umperies

Search took 10 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	148819	0.423	422437.4
2	DLD Change Limit	148819	54	9.016	16506.1
3	Display Results	54	54	0.030	1800.0
	(SQL Overall)	178691	54	9.469	18871.2