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

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

302 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
parr	6	57	3115	(None)
carr	6	54	3470	1	carr
pair	6	60	3151	1	pair
par	5	74	6702	1	pa_r
para	6	52	4217	1	para
pard	7	64	4132	1	pard
pare	6	67	6084	1	pare
parer	7	58	3990	1	parer
park	10	52	3749	1	park
parrs	7	59	2867	1	parrs
parry	10	53	2375	1	parry
pars	6	75	6079	1	pars
part	6	59	6746	1	part
purr	6	49	2581	1	purr
air	3	80	5839	2	_air
apart	7	43	3067	2	apart
aper	6	63	3623	2	aper
ar	2	113	7938	2	_a_r
arb	5	104	4842	2	_arb
arc	5	102	5090	2	_arc
are	3	78	7457	2	_are
arf	6	74	5337	2	_arf
ark	7	70	4496	2	_ark
arm	5	84	4962	2	_arm
ars	3	76	7093	2	_ars
art	3	86	7914	2	_art
bar	5	80	7055	2	ba_r
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barer	7	45	3580	2	barer
barf	9	58	4441	2	barf
bark	10	62	4215	2	bark
barm	8	67	3960	2	barm
barn	6	64	4464	2	barn
barre	7	59	2954	2	barre
bars	6	65	6409	2	bars
birr	6	60	2236	2	birr
brr	5	69	2192	2	_brr
brrr	6	53	1229	2	brrr
burr	6	56	3123	2	burr
car	5	91	6556	2	ca_r
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
carer	7	49	4233	2	carer
cark	10	55	3927	2	cark
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carrs	7	57	3085	2	carrs
carry	10	58	2378	2	carry
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
charr	10	48	2178	2	charr
curr	6	54	2965	2	curr
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
darer	6	52	3079	2	darer
dark	9	51	3321	2	dark
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
dorr	5	66	2772	2	dorr
durr	5	56	2435	2	durr
ear	3	68	6788	2	ea_r
earl	4	58	3814	2	earl
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
err	3	56	2653	2	_err
fair	7	63	3252	2	fair
far	6	77	6260	2	fa_r
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farer	8	67	3314	2	farer
farl	7	63	3855	2	farl
farm	9	59	3453	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
gar	4	72	5990	2	ga_r
garb	7	53	3267	2	garb
gars	5	57	5074	2	gars
gaur	5	67	2335	2	gaur
gnarr	6	48	1069	2	gnarr
haar	7	73	2349	2	haar
hair	7	63	3014	2	hair
hard	8	54	4350	2	hard
hare	7	62	5573	2	hare
hark	11	52	3739	2	hark
harl	7	57	4000	2	harl
harm	9	56	3779	2	harm
harp	9	61	3429	2	harp
harry	11	53	2295	2	harry
hart	7	68	6577	2	hart
jar	10	76	4615	2	ja_r
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
karn	8	61	2941	2	karn
kart	8	67	5080	2	kart
lair	4	59	3415	2	lair
lar	3	79	6753	2	la_r
lard	5	67	4200	2	lard
lari	4	58	3915	2	lari
lark	8	57	3386	2	lark
lars	4	69	5657	2	lars
maar	6	60	2506	2	maar
mair	6	61	3378	2	mair
mar	5	79	6595	2	ma_r
mara	6	74	4457	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
mark	10	51	3806	2	mark
marl	6	63	4162	2	marl
marry	10	48	2169	2	marry
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
murr	6	52	2513	2	murr
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
nark	8	52	3006	2	nark
nary	7	69	3122	2	nary
oar	3	70	5795	2	oa_r
oars	4	68	4603	2	oars
pa	4	104	5648	2	pa__
pac	7	90	5408	2	pa_c
paca	8	51	3224	2	paca
pace	8	63	4577	2	pace
pacer	9	61	3161	2	pacer
pack	12	55	3544	2	pack
pacs	8	58	4218	2	pacs
pact	8	66	4872	2	pact
pacy	11	53	2868	2	pacy
pad	6	80	5732	2	pa_d
padi	7	63	3178	2	padi
padre	8	60	1816	2	padre
padri	8	58	1517	2	padri
pads	7	67	4295	2	pads
page	7	60	3610	2	page
pager	8	47	2820	2	pager
pah	8	88	5359	2	pa_h
paid	7	57	3748	2	paid
paik	10	57	2680	2	paik
pail	6	61	4183	2	pail
pain	6	56	4724	2	pain
pairs	7	53	2583	2	pairs
pal	5	67	6167	2	pa_l
pale	6	60	5501	2	pale
paler	7	54	3693	2	paler
pall	6	50	3934	2	pall
palm	8	53	3136	2	palm
palp	8	58	2857	2	palp
pals	6	69	5135	2	pals
paly	9	58	3553	2	paly
pam	7	78	5839	2	pa_m
pams	8	56	4176	2	pams
pan	5	84	6645	2	pa_n
pane	6	49	5029	2	pane
pang	7	53	3629	2	pang
pans	6	58	5573	2	pans
pant	6	60	6126	2	pant
pap	7	67	5840	2	pa_p
papa	8	58	2714	2	papa
paper	9	51	2866	2	paper
paps	8	64	4345	2	paps
parae	7	63	3570	2	parae
paras	7	61	4304	2	paras
parch	12	51	2300	2	parch
pardi	8	57	2395	2	pardi
pards	8	56	3433	2	pards
pardy	11	55	2395	2	pardy
pared	8	69	4676	2	pared
pareo	7	46	3260	2	pareo
parers	8	55	3074	2	parers
pares	7	71	6448	2	pares
pareu	7	49	2874	2	pareu
parge	8	58	3185	2	parge
pargo	8	67	2372	2	pargo
paris	7	51	4594	2	paris
parka	11	51	2088	2	parka
parker	12	41	2137	2	parker
parks	11	61	3446	2	parks
parle	7	58	3616	2	parle
parlor	8	3	1267	2	parlor
parol	7	48	2627	2	parol
parral	8	55	1753	2	parral
parred	9	50	2407	2	parred
parrel	8	45	1598	2	parrel
parrot	8	3	2066	2	parrot
parse	7	52	3699	2	parse
parser	8	48	2237	2	parser
parts	7	77	4337	2	parts
party	10	66	3061	2	party
parura	8	3	1058	2	parura
parure	8	3	1252	2	parure
parve	10	98	2485	2	parve
parvo	10	77	1918	2	parvo
pas	5	87	7574	2	pa_s
pase	6	53	4686	2	pase
pash	9	56	3813	2	pash
pass	6	52	3995	2	pass
past	6	59	5901	2	past
pat	5	80	8946	2	pa_t
pate	6	53	5046	2	pate
pater	7	47	4072	2	pater
path	9	91	3491	2	path
pats	6	64	6085	2	pats
paty	9	52	3456	2	paty
pave	9	61	3389	2	pave
paver	10	42	2583	2	paver
paw	8	76	5117	2	pa_w
pawer	10	44	2297	2	pawer
pawl	9	51	2326	2	pawl
pawn	9	46	2530	2	pawn
paws	9	60	3818	2	paws
pax	12	73	4685	2	pa_x
pay	8	84	6118	2	pa_y
payer	10	51	2572	2	payer
payor	10	54	1384	2	payor
pays	9	59	4022	2	pays
pear	6	97	4523	2	pear
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
peer	6	62	3835	2	peer
per	5	63	5309	2	p_er
pere	6	64	5026	2	pere
peri	6	56	3697	2	peri
perk	10	62	3284	2	perk
perm	8	58	3463	2	perm
perp	8	90	2989	2	perp
perry	10	52	2271	2	perry
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pier	6	60	3529	2	pier
pirn	6	71	2837	2	pirn
poor	6	56	3022	2	poor
pore	6	64	5126	2	pore
pork	10	69	2968	2	pork
porn	6	56	3602	2	porn
port	6	60	5963	2	port
pour	6	115	2747	2	pour
pram	8	57	3349	2	pram
prao	6	62	2902	2	prao
prat	6	59	5204	2	prat
prau	6	65	2947	2	prau
pray	9	63	3153	2	pray
pro	5	58	3726	2	p_ro
pry	8	57	2805	2	p_ry
pur	5	68	4055	2	p_ur
pure	6	55	4333	2	pure
purer	7	51	2790	2	purer
puri	6	59	3144	2	puri
purl	6	56	3142	2	purl
purrs	7	53	2043	2	purrs
purs	6	56	4104	2	purs
pyre	9	49	2555	2	pyre
pyro	9	60	1939	2	pyro
rare	4	53	4843	2	rare
rarer	5	47	3170	2	rarer
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sark	8	49	3897	2	sark
spar	6	54	3330	2	spa_r
spare	7	51	3556	2	spare
sparer	8	45	2496	2	sparer
spark	11	49	2089	2	spark
sparry	11	51	1130	2	sparry
spars	7	54	3154	2	spars
tahr	7	52	1715	2	tahr
tar	3	75	7069	2	ta_r
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taro	4	68	4691	2	taro
tarp	6	69	3641	2	tarp
tarre	5	58	2563	2	tarre
tarry	8	54	2251	2	tarry
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
torr	4	56	3090	2	torr
vair	7	56	2414	2	vair
var	6	61	4833	2	va_r
vara	7	55	3088	2	vara
vars	7	57	4207	2	vars
vary	10	52	2606	2	vary
wair	7	58	3005	2	wair
war	6	72	6242	2	wa_r
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
wark	11	57	3777	2	wark
warm	9	59	3567	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
waur	7	68	1990	2	waur
yar	6	72	5383	2	ya_r
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarer	8	43	2157	2	yarer
yarn	7	52	3004	2	yarn
yirr	7	65	1357	2	yirr
zarf	16	69	2912	2	zarf

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	29872	0.280	638182.1
2	DLD Change Limit	29872	302	0.876	34100.5
3	Display Results	302	302	0.076	3973.7
	(SQL Overall)	178691	302	1.232	145041.4