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

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

70 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
perfumer	15	7	455	(None)
perfume	14	4	650	1	perfume_
perfumed	16	5	454	1	perfumed
perfumers	16	8	371	1	perfumers
perfumery	19	7	238	1	perfumery
perfumes	15	5	589	1	perfumes
performer	16	14	513	2	performer
perfumy	17	6	393	2	perfum_y
perfuse	12	4	766	2	perfuse_
perfused	14	4	583	2	perfused
perfuses	13	5	866	2	perfuses
perjurer	17	28	590	2	perjurer
peruser	9	35	1137	2	per_user
presumer	12	4	758	2	presumer
cerumen	11	4	776	3	cer_umen
defamer	13	27	1032	3	de_famer
defuser	11	51	1050	3	de_fuser
exhumer	19	4	346	3	_exhumer
fumer	10	59	1823	3	___fumer
peplumed	15	4	304	3	peplumed
percher	14	33	1342	3	per_cher
perdue	9	39	1263	3	perdu_e_
perdues	10	35	1133	3	perdu_es
perdure	10	37	962	3	perdure_
perdured	12	28	740	3	perdured
perdures	11	28	968	3	perdures
perfecter	16	4	604	3	perfecter
performed	17	15	530	3	performed
performers	17	16	410	3	performers
perfumeries	18	5	279	3	perfumer~~ies~~
perfuming	17	8	405	3	perfuming
peripter	12	7	875	3	peripter
perjure	16	32	796	3	perjure_
perjured	18	28	627	3	perjured
perjurers	18	22	446	3	perjurers
perjures	17	26	808	3	perjures
perkier	13	38	1312	3	per_kier
permed	11	52	1735	3	per__med
permute	11	3	879	3	permute_
permuted	13	3	671	3	permuted
permutes	12	3	871	3	permutes
persuader	12	4	426	3	persuader
perter	8	44	2228	3	per__ter
perturber	13	4	315	3	perturber
peruke	12	32	1039	3	per_uke_
peruked	14	36	789	3	per_uked
perukes	13	32	1011	3	per_ukes
peruse	8	40	1684	3	per_use_
perused	10	31	1219	3	per_used
perusers	10	32	880	3	per_users
peruses	9	40	1816	3	per_uses
pervader	14	4	486	3	pervader
prefacer	15	3	798	3	prefacer
prefer	11	38	1320	3	pref__er
preluder	11	3	573	3	preluder
prenumber	15	4	316	3	prenumber
presume	11	3	1030	3	presume_
presumed	13	3	797	3	presumed
presumers	13	3	637	3	presumers
presumes	12	3	984	3	presumes
primer	10	51	1868	3	p_r_imer
primmer	13	43	1016	3	p_rimmer
prouder	10	3	1038	3	p_rouder
pruner	8	34	1345	3	p_r_uner
purfler	12	24	873	3	purf_ler
pursuer	9	33	889	3	pursu_er
refuser	10	49	1278	3	re_fuser
refuter	10	43	1219	3	re_futer
resumer	9	4	1011	3	re_sumer
termer	8	57	1725	3	ter__mer

Search took 9 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	70	7.643	19123.6
3	Display Results	70	70	0.016	4375.0
	(SQL Overall)	178691	70	8.079	22118.0