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

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

367 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
paris	7	51	4594	(None)
laris	5	47	3746	1	laris
naris	5	57	3529	1	naris
padis	8	62	2714	1	padis
pairs	7	53	2583	1	pairs
paras	7	61	4304	1	paras
pards	8	56	3433	1	pards
pares	7	71	6448	1	pares
paries	8	47	4251	1	paries
parish	11	50	2235	1	parish
parks	11	61	3446	1	parks
parrs	7	59	2867	1	parrs
pars	6	75	6079	1	par_s
parts	7	77	4337	1	parts
parvis	11	61	1480	1	parvis
pavis	10	64	2273	1	pavis
peris	7	55	3707	1	peris
puris	7	53	3202	1	puris
saris	5	45	4495	1	saris
abris	7	57	2260	2	abris
ahis	7	61	3538	2	_ahis
airs	4	64	4742	2	_airs
ais	3	90	8357	2	_a_is
amis	6	64	4532	2	_amis
anis	4	57	4646	2	_anis
aphis	10	59	1713	2	aphis
apres	7	54	2640	2	apres
apsis	7	57	1829	2	apsis
arbs	6	68	3473	2	_arbs
arcs	6	78	3478	2	_arcs
ares	4	58	7102	2	_ares
arfs	7	60	2996	2	_arfs
aria	4	62	4542	2	_aria
arias	5	54	3802	2	_arias
arid	5	76	4271	2	_arid
aril	4	58	4302	2	_aril
arils	5	87	3220	2	_arils
arise	5	64	3643	2	_arise
arks	8	59	3687	2	_arks
arms	6	61	3749	2	_arms
arris	5	68	2468	2	arris
ars	3	76	7093	2	_ar_s
arsis	5	57	2242	2	_arsis
arts	4	96	5026	2	_arts
auris	5	53	3153	2	auris
axis	11	61	2791	2	_axis
barbs	9	59	2819	2	barbs
bards	8	71	3964	2	bards
bares	7	54	5713	2	bares
barfs	10	48	2600	2	barfs
baric	9	61	2569	2	baric
barks	11	57	3581	2	barks
barms	9	61	2846	2	barms
barns	7	63	3514	2	barns
bars	6	65	6409	2	bar_s
basis	7	54	2986	2	basis
bris	6	55	3961	2	_bris
cadis	8	44	2850	2	cadis
capris	10	4	1508	2	capris
carbs	9	60	3146	2	carbs
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
caries	8	51	4762	2	caries
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carns	7	59	3756	2	carns
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	car_s
carts	7	89	4629	2	carts
cris	6	62	3343	2	_cris
dais	5	70	4070	2	da_is
darbs	8	53	2326	2	darbs
dares	6	61	4670	2	dares
daric	8	56	2312	2	daric
darics	9	43	1411	2	darics
darks	10	67	2787	2	darks
darns	6	69	2789	2	darns
darts	6	76	3573	2	darts
earls	5	61	2751	2	earls
earns	5	59	2756	2	earns
ears	4	63	5659	2	ear_s
fairs	8	58	2544	2	fairs
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
gadis	7	48	2529	2	gadis
garbs	8	63	2141	2	garbs
garish	10	45	1692	2	garish
gars	5	57	5074	2	gar_s
hairs	8	62	2517	2	hairs
hajis	15	67	1628	2	hajis
hards	9	64	3565	2	hards
hares	8	62	5554	2	hares
harks	12	63	3343	2	harks
harls	8	56	3450	2	harls
harms	10	68	2901	2	harms
harps	10	59	2687	2	harps
harts	8	84	4159	2	harts
iris	4	57	3255	2	_iris
jarls	12	61	2096	2	jarls
jars	11	73	3835	2	jar_s
kadis	10	59	2106	2	kadis
kakis	8	61	1684	2	kakis
karns	9	66	2414	2	karns
karts	9	76	3011	2	karts
kauris	10	36	1153	2	kauris
kris	8	64	2360	2	_kris
lairs	5	54	2587	2	lairs
lapis	7	62	2315	2	lapis
lards	6	53	3186	2	lards
lares	5	48	5263	2	lares
lari	4	58	3915	2	lari_
larks	9	52	2781	2	larks
lars	4	69	5657	2	lar_s
loris	5	53	2915	2	loris
mairs	7	62	2830	2	mairs
maras	7	54	4329	2	maras
marcs	9	57	2662	2	marcs
mares	7	64	5763	2	mares
maria	7	50	3288	2	maria
marish	11	43	1905	2	marish
marks	11	59	3348	2	marks
marls	7	55	3516	2	marls
mars	6	62	6187	2	mar_s
marts	7	74	4223	2	marts
mavis	10	56	2272	2	mavis
maxis	14	57	2156	2	maxis
nabis	7	60	2058	2	nabis
narcs	7	61	2202	2	narcs
nards	6	59	2846	2	nards
nares	5	55	4415	2	nares
naric	7	68	2417	2	naric
narks	9	60	2603	2	narks
nazis	14	52	1608	2	nazis
noris	5	49	2827	2	noris
oars	4	68	4603	2	oar_s
oasis	5	64	2255	2	oasis
orris	5	45	1655	2	orris
pacas	9	60	2940	2	pacas
paces	9	67	4111	2	paces
packs	13	55	2893	2	packs
pacs	8	58	4218	2	pa_cs
pacts	9	51	2580	2	pacts
padi	7	63	3178	2	padi_
padres	9	50	1698	2	padres
padri	8	58	1517	2	padri_
pads	7	67	4295	2	pa_ds
pages	8	52	3507	2	pages
paid	7	57	3748	2	pa_id
paik	10	57	2680	2	pa_ik
paiks	11	47	1985	2	paiks
pail	6	61	4183	2	pa_il
pails	7	58	3306	2	pails
pain	6	56	4724	2	pa_in
pains	7	51	3828	2	pains
pair	6	60	3151	2	pa_ir
paisa	7	60	2107	2	pa_isa
paise	7	50	2833	2	pa_ise
palais	8	4	2042	2	palais
pales	7	57	5380	2	pales
palish	11	47	1827	2	palish
palls	7	43	3256	2	palls
palms	9	49	2175	2	palms
palps	9	47	1956	2	palps
pals	6	69	5135	2	pa_ls
pams	8	56	4176	2	pa_ms
panes	7	61	4869	2	panes
pangs	8	46	2866	2	pangs
panic	9	39	2390	2	panic
panics	10	38	1536	2	panics
pans	6	58	5573	2	pa_ns
pants	7	65	3692	2	pants
papas	9	49	2749	2	papas
papism	12	22	1151	2	papism
papist	10	26	1875	2	papist
paps	8	64	4345	2	pa_ps
par	5	74	6702	2	par__
para	6	52	4217	2	par_a
parae	7	63	3570	2	parae
parch	12	51	2300	2	parch
pard	7	64	4132	2	par_d
pardi	8	57	2395	2	pardi
pardie	9	60	2144	2	pardie
pardy	11	55	2395	2	pardy
pare	6	67	6084	2	par_e
pared	8	69	4676	2	pared
pareo	7	46	3260	2	pareo
pareos	8	70	2377	2	pareos
parer	7	58	3990	2	parer
parers	8	55	3074	2	parers
paresis	9	33	1509	2	paresis
pareu	7	49	2874	2	pareu
pareus	8	54	2074	2	pareus
parge	8	58	3185	2	parge
parges	9	45	2954	2	parges
pargo	8	67	2372	2	pargo
pargos	9	57	1904	2	pargos
pariah	11	43	2058	2	pariah
pariahs	12	38	1234	2	pariahs
parian	8	32	2396	2	parian
parians	9	35	1973	2	parians
paring	9	42	3649	2	paring
parings	10	42	1921	2	parings
parises	9	48	2718	2	parises
parity	11	47	1987	2	parity
park	10	52	3749	2	par_k
parka	11	51	2088	2	parka
parkas	12	50	1802	2	parkas
parle	7	58	3616	2	parle
parles	8	63	3440	2	parles
parol	7	48	2627	2	parol
parols	8	47	2261	2	parols
parous	8	40	2416	2	parous
parr	6	57	3115	2	par_r
parries	9	39	2584	2	parries
parry	10	53	2375	2	parry
parse	7	52	3699	2	parse
parses	8	55	3470	2	parses
part	6	59	6746	2	par_t
parties	9	32	3086	2	parties
party	10	66	3061	2	party
parve	10	98	2485	2	parve
parvise	12	42	1169	2	parvise
parvo	10	77	1918	2	parvo
parvos	11	66	1475	2	parvos
pas	5	87	7574	2	pa__s
pases	7	53	4650	2	pases
pass	6	52	3995	2	pa_ss
pastis	8	49	2432	2	pastis
pasts	7	59	3650	2	pasts
pates	7	60	4789	2	pates
paths	10	55	2138	2	paths
patin	7	68	3285	2	patin
patins	8	75	2878	2	patins
patio	7	44	2635	2	patio
patios	8	52	2178	2	patios
patois	8	43	1936	2	patois
pats	6	64	6085	2	pa_ts
paves	10	48	3392	2	paves
pavid	11	57	1700	2	pavid
pavin	10	56	2320	2	pavin
pavins	11	49	1966	2	pavins
pavise	11	47	1480	2	pavise
pawls	10	56	1766	2	pawls
pawns	10	88	1813	2	pawns
paws	9	60	3818	2	pa_ws
paxes	14	49	2842	2	paxes
pays	9	59	4022	2	pa_ys
pearls	8	47	1539	2	pearls
pears	7	51	3861	2	pear_s
penis	7	51	2932	2	penis
peres	7	62	4664	2	peres
peri	6	56	3697	2	peri_
peril	7	54	2595	2	peril
perils	8	41	2185	2	perils
perish	11	46	1906	2	perish
perks	11	53	2580	2	perks
perms	9	55	2451	2	perms
perps	9	55	2148	2	perps
pervs	10	51	1737	2	pervs
pharos	11	3	1206	2	pharos
phasis	11	46	1492	2	phasis
phis	9	57	2490	2	p_his
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
praise	8	44	1941	2	praise
prams	9	61	2551	2	prams
praos	7	49	2356	2	praos
prats	7	63	3339	2	prats
praus	7	46	2175	2	praus
praxis	15	40	1225	2	praxis
prays	10	50	2243	2	prays
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
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
qadis	15	59	1785	2	qadis
ragis	6	63	2560	2	ragis
rais	4	52	5262	2	ra_is
rakis	9	53	2344	2	rakis
ranis	5	52	3583	2	ranis
rares	5	52	4744	2	rares
sadis	6	49	3085	2	sadis
sakis	9	53	2367	2	sakis
sards	6	47	3618	2	sards
sari	4	54	4404	2	sari_
sarin	5	52	3925	2	sarin
sarins	6	39	3262	2	sarins
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
satis	5	56	3368	2	satis
shris	8	42	2145	2	shris
spahis	11	3	1038	2	spahis
spares	8	48	3455	2	spares
sparid	9	40	1693	2	sparid
sparids	10	35	1212	2	sparids
sparks	12	46	1636	2	sparks
spars	7	54	3154	2	spar_s
sris	4	54	3415	2	_sris
tamis	7	67	2873	2	tamis
tapis	7	50	2886	2	tapis
tares	5	74	5656	2	tares
tarns	5	64	3395	2	tarns
taros	5	56	4082	2	taros
tarps	7	65	2711	2	tarps
tars	4	67	6395	2	tar_s
tarsi	5	52	2217	2	tarsi
tarts	5	72	4202	2	tarts
taxis	12	68	2197	2	taxis
uraris	6	38	1727	2	uraris
vairs	8	50	1913	2	vairs
varas	8	60	2819	2	varas
varia	8	58	2420	2	varia
varias	9	50	1990	2	varias
varies	9	43	3087	2	varies
varix	15	43	1351	2	varix
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
wadis	9	52	2396	2	wadis
wairs	8	64	2406	2	wairs
wards	9	77	3440	2	wards
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2685	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
wars	7	86	5980	2	war_s
warts	8	148	4040	2	warts
yagis	9	54	1657	2	yagis
yards	9	53	2461	2	yards
yarns	8	56	2179	2	yarns
zarfs	17	47	1362	2	zarfs
zoris	14	53	2001	2	zoris

Search took 2 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.310	576422.6
2	DLD Change Limit	53800	367	1.440	37361.1
3	Display Results	367	367	0.093	3946.2
	(SQL Overall)	178691	367	1.843	96956.6