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

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

340 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
pean	6	61	4717	(None)
bean	6	64	4386	1	bean
dean	5	60	3948	1	dean
jean	11	66	2928	1	jean
lean	4	63	4524	1	lean
mean	6	55	3809	1	mean
paean	7	72	2272	1	paean
pan	5	84	6645	1	p_an
pea	5	66	5724	1	pea_
peag	7	54	3134	1	peag
peak	10	65	3520	1	peak
peal	6	86	4810	1	peal
peans	7	54	3764	1	peans
pear	6	97	4523	1	pear
peas	6	57	5506	1	peas
peat	6	59	6793	1	peat
pecan	9	19	1903	1	pecan
peen	6	59	3808	1	peen
pein	6	58	3494	1	pein
pekan	11	16	1397	1	pekan
pen	5	65	5884	1	pe_n
peon	6	56	3524	1	peon
pian	6	61	3609	1	pian
plan	6	58	3394	1	plan
spean	7	46	2051	1	spean
wean	7	57	3435	1	wean
yean	7	58	3458	1	yean
aeon	4	56	3461	2	aeon
alan	4	68	4408	2	alan
an	2	118	7908	2	__an
apeak	11	55	1345	2	apeak
apian	7	50	1833	2	apian
azan	13	65	2178	2	azan
ban	5	83	6684	2	_ban
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
beano	7	54	2155	2	beano
beans	7	57	3469	2	beans
bear	6	68	4464	2	bear
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
been	6	53	3578	2	been
began	8	63	1957	2	began
ben	5	65	5492	2	be_n
bran	6	57	4038	2	bran
can	5	77	6014	2	_can
clan	6	56	3392	2	clan
clean	7	54	2041	2	clean
cyan	9	64	1962	2	cyan
dan	4	68	5967	2	_dan
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
deans	6	61	3139	2	deans
dear	5	53	4360	2	dear
den	4	75	5434	2	de_n
dewan	9	57	1804	2	dewan
ear	3	68	6788	2	_ear
earn	4	67	3755	2	_earn
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
elan	4	67	3424	2	elan
en	2	80	5239	2	_e_n
eon	3	60	5208	2	_eon
ern	3	57	3835	2	_ern
fan	6	71	5886	2	_fan
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fen	6	68	5135	2	fe_n
fern	7	61	2932	2	fern
flan	7	61	3418	2	flan
gaen	5	73	2960	2	gaen
gan	4	80	6013	2	_gan
gear	5	59	3497	2	gear
gen	4	59	5051	2	ge_n
glean	6	58	1820	2	glean
gran	5	63	3501	2	gran
guan	5	53	2558	2	guan
haen	7	62	2945	2	haen
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heat	7	70	6142	2	heat
hen	6	75	5527	2	he_n
hern	7	61	3489	2	hern
hewn	10	67	1985	2	hewn
hwan	10	57	1689	2	hwan
jeans	12	60	2211	2	jeans
jeon	11	68	2144	2	jeon
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
keen	8	48	3040	2	keen
ken	7	63	4398	2	ke_n
kern	8	53	2621	2	kern
khan	11	58	1914	2	khan
koan	8	54	2503	2	koan
lea	3	76	6018	2	lea_
lead	5	60	3885	2	lead
leaf	7	64	4103	2	leaf
leak	8	62	3371	2	leak
leal	4	60	4327	2	leal
leans	5	55	3625	2	leans
leant	5	67	3778	2	leant
leap	6	60	3268	2	leap
lear	4	70	4595	2	lear
learn	5	53	2266	2	learn
leas	4	59	5418	2	leas
leman	7	56	2260	2	leman
loan	4	74	3645	2	loan
man	5	74	6587	2	_man
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
means	7	58	3123	2	means
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meat	6	63	5960	2	meat
men	5	92	5285	2	me_n
moan	6	58	3202	2	moan
naan	4	76	2193	2	naan
nan	3	78	5488	2	_nan
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
neon	4	70	2642	2	neon
ocean	7	12	1296	2	ocean
open	6	64	2700	2	ope_n
pa	4	104	5648	2	p_a_
pac	7	90	5408	2	p_ac
pad	6	80	5732	2	p_ad
paeans	8	51	1826	2	paeans
paeon	7	48	1949	2	paeon
paesan	8	51	1409	2	paesan
pagan	8	61	2116	2	pagan
pah	8	88	5359	2	p_ah
pain	6	56	4724	2	pain
pal	5	67	6167	2	p_al
pam	7	78	5839	2	p_am
pane	6	49	5029	2	p_ane
pang	7	53	3629	2	p_ang
pans	6	58	5573	2	p_ans
pant	6	60	6126	2	p_ant
pap	7	67	5840	2	p_ap
par	5	74	6702	2	p_ar
pas	5	87	7574	2	p_as
pat	5	80	8946	2	p_at
pavan	10	65	1847	2	pavan
paw	8	76	5117	2	p_aw
pawn	9	46	2530	2	pawn
pax	12	73	4685	2	p_ax
pay	8	84	6118	2	p_ay
pe	4	76	4903	2	pe__
peace	9	50	2608	2	peace
peach	12	54	2249	2	peach
peage	8	47	2356	2	peage
peags	8	61	2284	2	peags
peahen	11	34	1013	2	peahen
peaks	11	48	2562	2	peaks
peaky	14	57	1815	2	peaky
peals	7	52	3549	2	peals
peanut	8	3	1818	2	peanut
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
pease	7	52	3111	2	pease
peasen	8	48	1596	2	peasen
peats	7	61	4019	2	peats
peaty	10	57	2569	2	peaty
peavy	13	50	1484	2	peavy
pec	7	67	4441	2	pe_c
pecans	10	15	1583	2	pecans
pech	11	61	2545	2	pech
pechan	13	5	1154	2	pechan
peck	12	57	3068	2	peck
pecs	8	46	3410	2	pecs
ped	6	67	5152	2	pe_d
pedal	8	60	2250	2	pedal
pedant	9	3	1949	2	pedant
peds	7	58	3524	2	peds
pee	5	60	6651	2	pe_e
peed	7	62	3918	2	peed
peek	10	60	3143	2	peek
peel	6	55	3561	2	peel
peens	7	64	2819	2	peens
peep	8	58	3369	2	peep
peer	6	62	3835	2	peer
pees	6	52	5737	2	pees
peg	6	58	4306	2	pe_g
pegs	7	55	3176	2	pegs
peh	8	67	4096	2	pe_h
pehs	9	56	2576	2	pehs
peins	7	61	2806	2	peins
pekans	12	17	1055	2	pekans
peke	10	59	2620	2	peke
pekin	11	15	1442	2	pekin
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelon	7	44	2321	2	pelon
pelt	6	76	5108	2	pelt
penal	7	52	2837	2	penal
penang	9	25	1111	2	penang
pend	7	59	3453	2	pend
penman	10	3	1232	2	penman
penna	7	45	2020	2	penna
penne	7	54	2385	2	penne
penni	7	46	1790	2	penni
penny	10	51	1945	2	penny
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
peons	7	53	2718	2	peons
peony	10	57	1756	2	peony
pep	7	64	4708	2	pe_p
pepo	8	76	2215	2	pepo
peps	8	51	3451	2	peps
per	5	63	5309	2	pe_r
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
pert	6	67	5932	2	pert
perv	9	72	2481	2	perv
pes	5	72	5978	2	pe_s
peso	6	69	2582	2	peso
pest	6	55	5529	2	pest
pet	5	64	7730	2	pe_t
petal	7	65	2689	2	petal
pets	6	62	4833	2	pets
pew	8	64	4230	2	pe_w
pews	9	57	3153	2	pews
phat	9	58	3786	2	phat
phon	9	59	2538	2	phon
pia	5	68	4803	2	pia_
pial	6	56	3670	2	pial
piano	7	61	1871	2	piano
pians	7	51	2696	2	pians
pias	6	65	4255	2	pias
pin	5	70	6672	2	p_in
pina	6	58	4263	2	pina
pion	6	72	3529	2	pion
pirn	6	71	2837	2	pirn
plain	7	48	2330	2	plain
plane	7	49	2914	2	plane
plank	11	52	2114	2	plank
plans	7	57	3127	2	plans
plant	7	54	3711	2	plant
plat	6	60	4887	2	plat
play	9	59	2898	2	play
plea	6	68	3060	2	plea_
plead	8	58	1846	2	plead
pleas	7	56	2703	2	pleas
pleat	7	47	3447	2	pleat
plena	7	58	1639	2	plena
pleon	7	42	1638	2	pleon
poon	6	73	4126	2	poon
porn	6	56	3602	2	porn
pram	8	57	3349	2	pram
prang	8	48	2032	2	prang
prank	11	50	1945	2	prank
prao	6	62	2902	2	prao
prat	6	59	5204	2	prat
prau	6	65	2947	2	prau
prawn	10	53	1243	2	prawn
pray	9	63	3153	2	pray
preen	7	59	2505	2	preen
preman	10	41	1745	2	preman
pun	5	88	4651	2	p_un
puna	6	53	3165	2	puna
pya	8	70	2375	2	pya_
pyas	9	62	2570	2	pyas
pyin	9	68	2323	2	pyin
pyran	10	5	1447	2	pyran
quean	14	36	1284	2	quean
ran	3	82	6662	2	_ran
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
redan	6	61	2501	2	redan
rein	4	60	4089	2	rein
reman	7	57	3015	2	reman
reran	5	73	2910	2	reran
rewan	8	56	2366	2	rewan
roan	4	72	3420	2	roan
scan	6	55	3045	2	scan
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sear	4	73	5384	2	sear
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
sedan	6	56	2042	2	sedan
seen	4	69	4312	2	seen
sen	3	60	5852	2	se_n
sewan	8	59	2129	2	sewan
sewn	7	61	2433	2	sewn
skean	9	44	1562	2	skean
span	6	52	3466	2	span
speak	11	46	1867	2	speak
speans	8	54	1714	2	speans
spear	7	58	2106	2	spear
swan	7	66	3131	2	swan
tan	3	71	6757	2	_tan
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tear	4	52	4288	2	tear
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
teen	4	59	3820	2	teen
ten	3	58	5611	2	te_n
tern	4	61	3480	2	tern
than	7	61	2877	2	than
ulan	4	65	2739	2	ulan
van	6	62	4633	2	_van
veal	7	69	3681	2	veal
vegan	9	51	1415	2	vegan
vein	7	56	2575	2	vein
vena	7	61	2629	2	vena
wan	6	67	6194	2	_wan
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weans	8	53	2674	2	weans
wear	7	58	3672	2	wear
ween	7	58	3546	2	ween
wen	6	62	4960	2	we_n
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yeans	8	66	2488	2	yeans
year	7	65	3425	2	year
yearn	8	63	1643	2	yearn
yeas	7	86	3842	2	yeas
yen	6	68	4738	2	ye_n
yuan	7	61	2001	2	yuan
zeal	13	55	3033	2	zeal
zein	13	56	2060	2	zein

Search took 6 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.356	501941.0
2	DLD Change Limit	29872	340	4.236	7051.9
3	Display Results	340	340	0.356	955.1
	(SQL Overall)	178691	340	4.948	36113.8