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

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

309 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
paries	8	47	4251	(None)
caries	8	51	4762	1	caries
pares	7	71	6448	1	par_es
parges	9	45	2954	1	parges
paris	7	51	4594	1	pari_s
parises	9	48	2718	1	parises
parles	8	63	3440	1	parles
parries	9	39	2584	1	parries
parses	8	55	3470	1	parses
parties	9	32	3086	1	parties
pries	7	43	3953	1	p_ries
varies	9	43	3087	1	varies
aeries	6	47	3778	2	aeries
amies	7	68	3769	2	_amies
aperies	9	4	2320	2	aperies
apiaries	10	3	1272	2	apiaries
apres	7	54	2640	2	apr_es
ares	4	58	7102	2	_ar_es
arias	5	54	3802	2	_arias
ariel	5	52	2897	2	_ariel
ariels	6	51	1937	2	_ariels
arils	5	87	3220	2	_arils
arise	5	64	3643	2	_arise
arises	6	52	3380	2	_arises
arles	5	67	3574	2	_arles
armies	8	51	2369	2	_armies
arses	5	57	3387	2	_arses
babies	10	61	2365	2	babies
barbes	10	45	2623	2	barbes
barbies	11	45	1959	2	barbies
bardes	9	50	2693	2	bardes
bares	7	54	5713	2	bar_es
barges	9	45	2825	2	barges
barites	9	43	2233	2	barites
barres	8	44	2754	2	barres
baryes	11	62	1850	2	baryes
bries	7	49	4215	2	_bries
buries	8	46	3327	2	buries
cares	7	73	6918	2	car_es
caribes	11	37	1564	2	caribes
carices	11	42	2095	2	carices
caried	9	45	2869	2	caried
carles	8	54	3508	2	carles
carnies	9	41	2396	2	carnies
carries	9	43	2801	2	carries
carses	8	52	3365	2	carses
cartes	8	62	3947	2	cartes
carves	11	51	2845	2	carves
cavies	11	45	2500	2	cavies
claries	9	34	2220	2	claries
cries	7	54	3840	2	_cries
curies	8	49	3402	2	curies
dairies	8	42	1773	2	dairies
darbies	10	42	1698	2	darbies
dares	6	61	4670	2	dar_es
darics	9	43	1411	2	darics
darkies	12	40	1575	2	darkies
davies	10	50	2051	2	davies
dearies	8	35	2627	2	dearies
diaries	8	33	2195	2	diaries
dories	7	52	3236	2	dories
dries	6	47	3367	2	_dries
easies	6	41	2663	2	easies
eyries	9	38	1681	2	eyries
facies	11	39	2159	2	facies
faeries	10	41	1899	2	faeries
fairies	10	35	1604	2	fairies
farces	11	52	2332	2	farces
farcies	12	53	1788	2	farcies
fares	8	58	5287	2	far_es
farles	9	60	2578	2	farles
fries	8	55	3560	2	_fries
furies	9	51	2637	2	furies
gabies	9	38	2073	2	gabies
hardies	11	49	2323	2	hardies
hares	8	62	5554	2	har_es
harpies	12	38	1831	2	harpies
harries	10	35	2549	2	harries
juries	13	41	2063	2	juries
kauries	11	36	1319	2	kauries
kyries	13	34	1137	2	kyries
ladies	7	51	2488	2	ladies
larees	6	53	2311	2	larees
lares	5	48	5263	2	lar_es
larges	7	48	2423	2	larges
laris	5	47	3746	2	lari_s
lazies	15	44	1878	2	lazies
lories	6	49	3304	2	lories
mamies	10	46	2624	2	mamies
mares	7	64	5763	2	mar_es
marges	9	45	2571	2	marges
marines	9	39	2801	2	marines
marries	9	38	2528	2	marries
marses	8	48	2711	2	marses
mavies	11	49	2319	2	mavies
nares	5	55	4415	2	nar_es
naris	5	57	3529	2	nari_s
navies	9	52	1862	2	navies
ovaries	10	3	1265	2	ovaries
paces	9	67	4111	2	pa_ces
pacier	10	50	1868	2	pacier
paciest	11	29	1780	2	paciest
paddies	11	37	1572	2	paddies
padis	8	62	2714	2	padi_s
padles	9	52	2112	2	padles
padres	9	50	1698	2	padres
pages	8	52	3507	2	pa_ges
paiks	11	47	1985	2	pa_iks
pails	7	58	3306	2	pa_ils
pains	7	51	3828	2	pa_ins
paired	9	50	1752	2	paired
pairs	7	53	2583	2	pa_irs
paise	7	50	2833	2	pa_ise
pales	7	57	5380	2	pa_les
palier	8	50	2356	2	palier
paliest	9	30	2160	2	paliest
palsies	9	44	2027	2	palsies
pandies	10	42	2450	2	pandies
panes	7	61	4869	2	pa_nes
panfries	13	14	920	2	panfries
panics	10	38	1536	2	panics
panier	8	44	2550	2	panier
paniers	9	47	1733	2	paniers
pannes	8	55	2285	2	pannes
pansies	9	45	2198	2	pansies
panties	9	42	3093	2	panties
pantries	10	18	1739	2	pantries
pappies	10	32	1482	2	pappies
parades	10	41	2146	2	parades
parae	7	63	3570	2	parae_
paras	7	61	4304	2	par_as
parcel	10	39	1547	2	parcel
parcels	11	37	1266	2	parcels
parches	14	37	2000	2	parches
pardee	9	39	2202	2	pardee
pardie	9	60	2144	2	pardie_
pards	8	56	3433	2	par_ds
pare	6	67	6084	2	par_e_
pared	8	69	4676	2	par_ed
pareo	7	46	3260	2	par_eo
pareos	8	70	2377	2	pareos
parer	7	58	3990	2	par_er
parers	8	55	3074	2	parers
pareses	9	47	1888	2	pareses
pareu	7	49	2874	2	par_eu
pareus	8	54	2074	2	pareus
parge	8	58	3185	2	parge_
parged	10	49	2204	2	parged
parget	9	45	2939	2	parget
pargets	10	52	1519	2	pargets
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
parietes	10	7	1454	2	parietes
paring	9	42	3649	2	paring
parings	10	42	1921	2	parings
parish	11	50	2235	2	parish
parishes	13	3	1475	2	parishes
parities	10	5	2297	2	parities
parity	11	47	1987	2	parity
parkas	12	50	1802	2	parkas
parked	13	44	2514	2	parked
parker	12	41	2137	2	parker
parkers	13	38	1687	2	parkers
parks	11	61	3446	2	par_ks
parle	7	58	3616	2	parle_
parled	9	46	2629	2	parled
parley	11	67	1836	2	parley
parleys	12	52	1237	2	parleys
parodies	11	3	1369	2	parodies
paroles	9	50	2588	2	paroles
parols	8	47	2261	2	parols
parous	8	40	2416	2	parous
parred	9	50	2407	2	parred
parrel	8	45	1598	2	parrel
parrels	9	47	1349	2	parrels
parried	10	36	1572	2	parried
parrier	9	37	1765	2	parrier
parriers	10	36	1290	2	parriers
parrs	7	59	2867	2	par_rs
pars	6	75	6079	2	par__s
parse	7	52	3699	2	parse_
parsec	10	59	1448	2	parsec
parsecs	11	42	992	2	parsecs
parsed	9	63	2389	2	parsed
parser	8	48	2237	2	parser
parsers	9	41	1815	2	parsers
parted	9	42	2868	2	parted
partied	10	35	1655	2	partied
partier	9	35	2071	2	partier
partiers	10	35	1424	2	partiers
parts	7	77	4337	2	par_ts
parures	9	5	1269	2	parures
parve	10	98	2485	2	parve_
parvis	11	61	1480	2	parvis
parvise	12	42	1169	2	parvise
parvises	13	39	1191	2	parvises
parvos	11	66	1475	2	parvos
pases	7	53	4650	2	pa_ses
pashes	11	58	2839	2	pashes
passes	8	60	3047	2	passes
pastes	8	52	3391	2	pastes
pasties	9	45	2981	2	pasties
pastries	10	15	1742	2	pastries
pates	7	60	4789	2	pa_tes
patines	9	52	2576	2	patines
patins	8	75	2878	2	patins
patios	8	52	2178	2	patios
patsies	9	39	1948	2	patsies
patties	9	34	2514	2	patties
pauses	8	46	2147	2	pauses
paves	10	48	3392	2	pa_ves
pavins	11	49	1966	2	pavins
pavis	10	64	2273	2	pavi_s
pavise	11	47	1480	2	pavise
pavises	12	53	1549	2	pavises
paxes	14	49	2842	2	pa_xes
payees	11	48	1290	2	payees
peavies	12	22	1340	2	peavies
peeries	9	36	2302	2	peeries
peres	7	62	4664	2	per_es
perils	8	41	2185	2	perils
peris	7	55	3707	2	peri_s
perries	9	32	2660	2	perries
perses	8	54	2806	2	perses
pies	6	69	4960	2	p__ies
pities	8	38	2808	2	pities
pixies	15	49	1551	2	pixies
platies	9	37	2254	2	platies
plies	7	45	2651	2	p_lies
pogies	9	41	2354	2	pogies
pokies	12	59	2133	2	pokies
polies	8	40	3458	2	polies
ponies	8	48	3346	2	ponies
pores	7	58	4903	2	por_es
porgies	10	30	1700	2	porgies
porkies	13	34	1649	2	porkies
posies	8	44	3143	2	posies
prairies	10	4	1145	2	prairies
praise	8	44	1941	2	praise
praises	9	41	2110	2	praises
prases	8	44	2902	2	prases
prates	8	46	3316	2	prates
praxes	15	62	1518	2	praxes
prees	7	59	3717	2	p_rees
prices	10	45	2454	2	p_rices
prides	9	43	2418	2	p_rides
pried	8	44	2686	2	p_ried
prier	7	50	2776	2	p_rier
priers	8	45	2119	2	p_riers
priest	8	41	2542	2	p_riest
prigs	8	52	1970	2	p_rigs
primes	10	42	2526	2	p_rimes
prims	9	54	2593	2	p_rims
prise	7	46	3261	2	p_rise
prises	8	41	3317	2	p_rises
priss	7	46	2389	2	p_riss
prizes	17	38	1981	2	p_rizes
purees	8	47	2168	2	purees
purges	9	44	2176	2	purges
purines	9	44	2076	2	purines
purins	8	37	2265	2	purins
puris	7	53	3202	2	puri_s
purses	8	48	2637	2	purses
pyres	10	55	2388	2	pyr_es
pyrites	12	8	1220	2	pyrites
pyxies	18	33	829	2	pyxies
rabies	8	52	2602	2	rabies
ramies	8	46	3046	2	ramies
rares	5	52	4744	2	rar_es
sanies	6	30	3195	2	sanies
sarees	6	53	2994	2	sarees
sarges	7	51	2859	2	sarges
sarins	6	39	3262	2	sarins
saris	5	45	4495	2	sari_s
sauries	7	28	2162	2	sauries
scries	8	52	2682	2	scries
series	6	45	4097	2	series
spares	8	48	3455	2	spar_es
sparges	10	40	1634	2	sparges
sparids	10	35	1212	2	sparids
spavies	12	30	1294	2	spavies
tardies	8	42	2586	2	tardies
tares	5	74	5656	2	tar_es
targes	7	45	2459	2	targes
tarres	6	47	2304	2	tarres
tarries	7	33	2426	2	tarries
taxies	13	58	1733	2	taxies
tories	6	54	3588	2	tories
tries	5	57	4281	2	_tries
updries	10	20	908	2	updries
varias	9	50	1990	2	varias
varices	12	33	1357	2	varices
varied	10	48	1786	2	varied
varier	9	46	1935	2	varier
variers	10	37	1266	2	variers
varves	12	44	1478	2	varves
wadies	10	51	2120	2	wadies
walies	9	53	2452	2	walies
wares	8	82	5058	2	war_es
warier	9	37	2289	2	warier
wariest	10	51	2250	2	wariest
wavies	12	50	1984	2	wavies
wearies	10	30	2022	2	wearies
wries	8	58	2774	2	_wries
zaires	15	3	970	2	zaires
zanies	15	32	1967	2	zanies

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	82551	0.343	520965.0
2	DLD Change Limit	82551	309	2.360	34979.2
3	Display Results	309	309	0.093	3322.6
	(SQL Overall)	178691	309	2.796	63909.5