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

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

77 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
periwig	13	4	516	(None)
periwigs	14	4	419	1	periwigs
peridia	10	3	1236	2	peridia
periling	11	3	1686	2	periling
periti	8	3	1995	2	periti_
aperitif	13	4	734	3	aperitif
beriming	13	3	1046	3	beriming
bewig	11	3	890	3	be__wig
cering	9	45	2253	3	ceri_ng
deriding	11	25	1293	3	deriding
deriving	13	25	1074	3	deriving
earwig	10	11	470	3	_earwig
merisis	9	32	1317	3	merisis
meriting	11	3	1468	3	meriting
neritic	9	13	1433	3	neritic
parawing	14	3	1058	3	parawing
paring	9	42	3649	3	pari_ng
peeing	9	46	1808	3	peei_ng
peering	10	35	2035	3	peeri_ng
peewit	11	11	1090	3	pe_ewit
peining	10	46	1915	3	pe_ining
peising	10	34	1676	3	pe_ising
pelitic	11	18	1465	3	pelitic
penicil	11	3	883	3	penicil
peracid	12	3	1299	3	peracid
perching	16	37	1163	3	perching
percoid	12	3	1231	3	percoid
perdie	9	47	1851	3	per_die
pereia	8	52	1798	3	per_eia
peri	6	56	3697	3	per__i_
periapt	11	3	1341	3	periapt
peridial	11	4	1192	3	peridial
peridium	13	4	902	3	peridium
peridot	10	5	1424	3	peridot
perigee	10	11	1339	3	perigee
perigon	10	3	985	3	perigon
peril	7	54	2595	3	per__il
periled	10	3	1632	3	periled
perilla	9	3	1123	3	perilla
perilling	12	4	1000	3	perilling
perils	8	41	2185	3	peri_ls
perinea	9	3	1303	3	perinea
period	9	3	1498	3	peri_od
periodic	13	4	843	3	periodic
periodid	12	4	816	3	periodid
periods	10	3	1224	3	periods
periotic	12	3	1344	3	periotic
perique	18	3	752	3	perique
peris	7	55	3707	3	per__is
perish	11	46	1906	3	peri_sh
perishing	15	3	953	3	perishing
peritus	9	3	1180	3	peritus
periwigged	18	5	112	3	periwigged
perking	14	37	1646	3	perking
perlitic	12	3	1058	3	perlitic
perming	12	34	1609	3	perming
permit	10	3	2168	3	per_mit
pernio	8	5	1314	3	per_nio
peroxid	17	3	1027	3	peroxid
pertain	9	27	1496	3	pertain
perusing	11	8	1106	3	perusing
pewit	10	46	2279	3	pe__wit
poring	9	42	2727	3	pori_ng
pricing	12	34	1734	3	p_ricing
priding	11	33	1754	3	p_riding
prig	7	59	2487	3	p_r__ig
primi	9	50	1740	3	p_rimi_
priming	12	34	1737	3	p_riming
prising	10	33	2145	3	p_rising
prizing	19	35	1468	3	p_rizing
pyridic	15	26	783	3	pyridic
pyritic	14	33	1131	3	pyritic
rerig	6	40	1848	3	rer__ig
rerising	9	30	1778	3	rerising
sericin	9	3	1284	3	sericin
sering	7	47	3181	3	seri_ng
veridic	13	3	814	3	veridic

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	134027	0.406	440125.6
2	DLD Change Limit	134027	77	7.016	19103.1
3	Display Results	77	77	0.030	2566.7
	(SQL Overall)	178691	77	7.452	23978.9