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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

268 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
peris	7	55	3707	(None)
paris	7	51	4594	1	paris
penis	7	51	2932	1	penis
peres	7	62	4664	1	peres
peri	6	56	3697	1	peri_
peril	7	54	2595	1	peril
perils	8	41	2185	1	perils
perish	11	46	1906	1	perish
perks	11	53	2580	1	perks
perms	9	55	2451	1	perms
perps	9	55	2148	1	perps
pervs	10	51	1737	1	pervs
puris	7	53	3202	1	puris
abris	7	57	2260	2	abris
aegis	6	3	1678	2	aegis
aerie	5	46	3460	2	aerie
aeries	6	47	3778	2	aeries
aperies	9	4	2320	2	aperies
apers	7	66	2913	2	aper_s
arris	5	68	2468	2	arris
auris	5	53	3152	2	auris
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
bris	6	55	3961	2	_bris
cedis	8	43	1708	2	cedis
cercis	10	46	1449	2	cercis
ceres	7	55	4001	2	ceres
ceria	7	51	2535	2	ceria
cerias	8	33	2197	2	cerias
ceric	9	40	2309	2	ceric
cerise	8	48	2204	2	cerise
ceros	7	47	2607	2	ceros
cris	6	62	3343	2	_cris
debris	9	33	1149	2	debris
defis	9	67	1750	2	defis
delis	6	49	2854	2	delis
dermis	9	47	1716	2	dermis
derms	8	50	2289	2	derms
derris	7	36	1527	2	derris
eerie	5	52	2853	2	eerie
egis	5	65	2065	2	_egis
eras	4	54	4150	2	_eras
ergs	5	55	2381	2	_ergs
erns	4	54	2822	2	_erns
eros	4	52	3845	2	_eros
errs	4	56	2253	2	_errs
ers	3	60	4628	2	_er_s
feres	8	60	3818	2	feres
feria	8	59	2271	2	feria
ferias	9	50	2039	2	ferias
fermis	11	43	1350	2	fermis
ferns	8	52	2008	2	ferns
germs	8	51	1887	2	germs
heirs	8	56	1856	2	heirs
herbs	10	55	2050	2	herbs
herds	9	64	2468	2	herds
heres	8	62	4590	2	heres
herls	8	52	2643	2	herls
herms	10	56	2643	2	herms
herns	8	48	2558	2	herns
heros	8	49	3086	2	heros
hers	7	58	4487	2	her_s
iris	4	57	3255	2	_iris
jerid	13	23	1642	2	jerid
jerids	14	28	1094	2	jerids
jerks	16	65	1489	2	jerks
keirs	9	53	1367	2	keirs
kepis	11	53	1336	2	kepis
kerbs	11	50	1367	2	kerbs
kerfs	12	54	1357	2	kerfs
kermis	12	40	1239	2	kermis
kerns	9	47	1956	2	kerns
kris	8	64	2360	2	_kris
laris	5	47	3746	2	laris
leis	4	57	3960	2	le_is
lenis	5	63	2686	2	lenis
levis	8	58	1855	2	levis
lewis	8	53	1584	2	lewis
lexis	12	59	1603	2	lexis
loris	5	53	2915	2	loris
mercs	9	60	2045	2	mercs
meres	7	51	4357	2	meres
merit	7	3	3918	2	merit
merits	8	3	2087	2	merits
merks	11	47	2240	2	merks
merls	7	74	2390	2	merls
metis	7	50	2590	2	metis
naris	5	57	3529	2	naris
nerds	6	57	1925	2	nerds
nereis	6	3	1534	2	nereis
nerts	5	59	2498	2	nerts
noris	5	49	2827	2	noris
operas	8	3	1245	2	operas
orris	5	45	1655	2	orris
padis	8	62	2714	2	padis
pairs	7	53	2583	2	pairs
paras	7	61	4304	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
paries	8	47	4251	2	paries
parish	11	50	2235	2	parish
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
parvis	11	61	1480	2	parvis
pavis	10	64	2273	2	pavis
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pearls	8	47	1538	2	pearls
pears	7	51	3861	2	pears
peas	6	57	5506	2	pe_as
peats	7	61	4019	2	peats
pechs	12	55	1620	2	pechs
pecks	13	57	2443	2	pecks
pecs	8	46	3410	2	pe_cs
pedes	8	53	2728	2	pedes
pedros	9	3	1218	2	pedros
peds	7	58	3524	2	pe_ds
peeks	11	50	2111	2	peeks
peels	7	52	2642	2	peels
peens	7	64	2819	2	peens
peeps	9	58	2236	2	peeps
peerie	8	36	1789	2	peerie
peeries	9	36	2302	2	peeries
peers	7	51	3027	2	peers
pees	6	52	5737	2	pe_es
pegs	7	55	3176	2	pe_gs
pehs	9	56	2576	2	pe_hs
pein	6	58	3494	2	pe_in
peins	7	61	2806	2	peins
peise	7	58	2577	2	pe_ise
pekes	11	46	2356	2	pekes
pekin	11	15	1442	2	pekin
pekins	12	18	1223	2	pekins
peles	7	57	3808	2	peles
pelfs	10	50	1629	2	pelfs
pelts	7	61	2881	2	pelts
pelvis	11	36	1032	2	pelvis
pends	8	55	2719	2	pends
penes	7	58	3922	2	penes
pennis	8	43	1574	2	pennis
pens	6	56	4964	2	pe_ns
peons	7	53	2718	2	peons
pepos	9	66	2008	2	pepos
peps	8	51	3451	2	pe_ps
per	5	63	5309	2	per__
perch	12	45	1883	2	perch
perdie	9	47	1851	2	perdie
perdu	8	42	1627	2	perdu
perdus	9	37	1127	2	perdus
perdy	11	54	1732	2	perdy
pere	6	64	5026	2	per_e
perea	7	50	2644	2	perea
pereia	8	52	1798	2	pereia
period	9	3	1498	2	period
periods	10	3	1224	2	periods
periti	8	3	1995	2	periti
peritus	9	3	1180	2	peritus
perk	10	62	3284	2	per_k
perkish	16	25	882	2	perkish
perky	14	53	1948	2	perky
perm	8	58	3463	2	per_m
permit	10	3	2168	2	permit
permits	11	3	1400	2	permits
pernio	8	5	1314	2	pernio
perp	8	90	2989	2	per_p
perries	9	32	2660	2	perries
perry	10	52	2271	2	perry
perse	7	54	2952	2	perse
perses	8	54	2806	2	perses
persist	9	3	1585	2	persist
pert	6	67	5932	2	per_t
peruse	8	40	1684	2	peruse
perv	9	72	2481	2	per_v
pes	5	72	5978	2	pe__s
pesos	7	72	2162	2	pesos
pests	7	59	3327	2	pests
petit	7	43	3265	2	petit
pets	6	62	4833	2	pe_ts
pewit	10	46	2279	2	pewit
pewits	11	28	1068	2	pewits
pews	9	57	3153	2	pe_ws
phis	9	57	2490	2	p_his
piers	7	59	2633	2	pier_s
pikis	11	51	1639	2	pikis
pilis	7	58	2520	2	pilis
pirns	7	60	2009	2	pirns
pis	5	63	6203	2	p__is
pois	6	65	3904	2	p_ois
polis	7	47	3116	2	polis
pooris	8	39	1684	2	pooris
pores	7	58	4903	2	pores
porism	10	45	1806	2	porism
porks	11	51	2414	2	porks
porns	7	55	2734	2	porns
ports	7	59	3459	2	ports
precis	10	34	1670	2	precis
prees	7	59	3717	2	prees
preps	9	62	2069	2	preps
press	7	54	2595	2	press
preys	10	57	1778	2	preys
pries	7	43	3953	2	p_ries
prig	7	59	2487	2	p_rig
prigs	8	52	1970	2	p_rigs
prim	8	51	3220	2	p_rim
prims	9	54	2593	2	p_rims
prise	7	46	3261	2	p_rise
prism	9	48	2026	2	p_rism
priss	7	46	2389	2	p_riss
pros	6	57	4278	2	p_ros
psis	6	81	2034	2	p_sis
pterin	8	10	1415	2	pterin
pterins	9	8	1299	2	pterins
pubis	9	46	1647	2	pubis
pulis	7	42	2560	2	pulis
puri	6	59	3144	2	puri_
purin	7	55	2759	2	purin
purins	8	37	2265	2	purins
purism	10	47	1506	2	purism
purist	8	55	2505	2	purist
purls	7	47	2335	2	purls
purrs	7	53	2043	2	purrs
purs	6	56	4104	2	pur_s
pyres	10	55	2388	2	pyres
pyric	12	38	1507	2	pyric
pyros	10	57	1829	2	pyros
pyxis	17	45	863	2	pyxis
reis	4	53	4323	2	re_is
rerig	6	40	1848	2	rerig
rerigs	7	40	1479	2	rerigs
rerise	6	43	2563	2	rerise
saris	5	45	4495	2	saris
seis	4	55	4239	2	se_is
semis	7	46	2353	2	semis
serais	6	43	2613	2	serais
seres	5	54	4889	2	seres
serfs	8	49	2201	2	serfs
series	6	45	4097	2	series
serif	8	41	3213	2	serif
serifs	9	40	1705	2	serifs
serin	5	54	3444	2	serin
serins	6	40	2967	2	serins
sers	4	57	4665	2	ser_s
shris	8	42	2144	2	shris
speirs	8	50	1323	2	speirs
sperms	10	25	1260	2	sperms
sris	4	54	3415	2	_sris
terais	6	40	2350	2	terais
terms	7	55	2347	2	terms
terns	5	52	2687	2	terns
tetris	6	28	1629	2	tetris
verbs	10	46	1439	2	verbs
verism	11	32	1426	2	verism
verist	9	38	2389	2	verist
vermis	11	42	1496	2	vermis
verts	8	57	2473	2	verts
weirs	8	43	1649	2	weirs
xeric	14	43	1566	2	xeric
xerus	12	3	1333	2	xerus
yerks	12	54	1656	2	yerks
yetis	8	54	1839	2	yetis
zerks	18	51	1382	2	zerks
zeros	14	49	1810	2	zeros
zoris	14	53	2001	2	zoris

Search took 3 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	53800	0.093	1921408.6
2	DLD Change Limit	53800	268	1.876	28678.0
3	Display Results	268	268	0.076	3526.3
	(SQL Overall)	178691	268	2.045	87379.5