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

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

320 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
pear	6	97	4523	(None)
bear	6	68	4464	1	bear
dear	5	53	4360	1	dear
ear	3	68	6788	1	_ear
fear	7	53	3779	1	fear
gear	5	59	3497	1	gear
hear	7	61	4388	1	hear
lear	4	70	4595	1	lear
near	4	52	3650	1	near
par	5	74	6702	1	p_ar
pea	5	66	5724	1	pea_
peag	7	54	3134	1	peag
peak	10	65	3520	1	peak
peal	6	86	4810	1	peal
pean	6	61	4717	1	pean
pearl	7	53	2446	1	pearl
pears	7	51	3861	1	pears
peart	7	64	4075	1	peart
peas	6	57	5506	1	peas
peat	6	59	6793	1	peat
peer	6	62	3835	1	peer
per	5	63	5309	1	pe_r
rear	4	56	4455	1	rear
sear	4	73	5384	1	sear
spear	7	58	2106	1	spear
tear	4	52	4288	1	tear
wear	7	58	3672	1	wear
year	7	65	3425	1	year
afar	7	67	2078	2	afar
agar	5	87	2641	2	agar
ajar	11	62	1770	2	ajar
alar	4	63	4007	2	alar
anear	5	54	2032	2	anear
apeak	11	55	1345	2	apeak
aper	6	63	3623	2	ape_r
appear	10	37	934	2	appear
ar	2	113	7938	2	__ar
bar	5	80	7055	2	_bar
bead	7	59	3792	2	bead
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
beard	8	60	2496	2	beard
bears	7	57	3904	2	bears
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
beer	6	56	3599	2	beer
blear	7	59	1868	2	blear
boar	6	61	3429	2	boar
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
clear	7	62	1905	2	clear
czar	15	60	1313	2	czar
dead	6	54	3424	2	dead
deaf	8	58	3840	2	deaf
deair	6	58	1719	2	deair
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dears	6	57	3688	2	dears
deary	9	58	2684	2	deary
debar	8	55	1786	2	debar
deer	5	67	3902	2	deer
denar	6	52	2329	2	denar
dewar	9	58	1773	2	dewar
drear	6	50	1690	2	drear
earl	4	58	3814	2	_earl
earn	4	67	3755	2	_earn
ears	4	63	5659	2	_ears
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
er	2	83	4514	2	_e_r
era	3	57	4150	2	_era
err	3	56	2653	2	_err
far	6	77	6260	2	_far
feal	7	139	4042	2	feal
fears	8	48	2939	2	fears
feat	7	64	5822	2	feat
fer	6	66	4612	2	fe_r
feuar	8	3	1024	2	feuar
fiar	7	64	2733	2	fiar
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
gnar	5	60	2138	2	gnar
guar	5	69	2329	2	guar
haar	7	73	2349	2	haar
head	8	71	3717	2	head
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
heard	9	52	2275	2	heard
hears	8	67	3737	2	hears
heart	8	54	4074	2	heart
heat	7	70	6142	2	heat
heir	7	75	2380	2	heir
her	6	65	4781	2	he_r
hoar	7	67	2916	2	hoar
izar	13	66	1601	2	izar
jar	10	76	4615	2	_jar
jean	11	66	2928	2	jean
jeer	11	54	2646	2	jeer
kbar	10	65	1465	2	kbar
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
kebar	11	51	1353	2	kebar
keir	8	62	1787	2	keir
knar	8	58	1872	2	knar
kyar	11	69	1684	2	kyar
lar	3	79	6753	2	_lar
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
lean	4	63	4524	2	lean
leap	6	60	3268	2	leap
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leas	4	59	5418	2	leas
leer	4	62	3935	2	leer
lehr	7	55	1494	2	lehr
liar	4	72	2968	2	liar
maar	6	60	2505	2	maar
mar	5	79	6594	2	_mar
mead	7	55	3160	2	mead
meal	6	56	4317	2	meal
mean	6	55	3808	2	mean
meat	6	63	5960	2	meat
neap	6	69	2701	2	neap
nears	5	55	2942	2	nears
neat	4	63	5678	2	neat
oar	3	70	5795	2	_oar
opera	7	3	1357	2	opera
osar	4	68	2095	2	osar
pa	4	104	5648	2	p_a_
pac	7	90	5408	2	p_ac
pad	6	80	5732	2	p_ad
paean	7	72	2272	2	paean
pah	8	88	5359	2	p_ah
pair	6	60	3151	2	pair
pal	5	67	6167	2	p_al
pam	7	78	5839	2	p_am
pan	5	84	6644	2	p_an
pap	7	67	5840	2	p_ap
para	6	52	4217	2	p_ara
pard	7	64	4132	2	p_ard
pare	6	67	6084	2	p_are
park	10	52	3749	2	p_ark
parr	6	57	3115	2	parr
pars	6	75	6079	2	p_ars
part	6	59	6746	2	p_art
pas	5	87	7574	2	p_as
pat	5	80	8946	2	p_at
paw	8	76	5117	2	p_aw
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
peaks	11	48	2562	2	peaks
peaky	14	57	1815	2	peaky
peals	7	52	3549	2	peals
peans	7	54	3764	2	peans
pearls	8	47	1538	2	pearls
pearly	11	64	1484	2	pearly
pease	7	52	3111	2	pease
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
pecan	9	19	1903	2	pecan
pech	11	61	2545	2	pech
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
pedlar	9	33	1127	2	pedlar
pedro	8	3	1315	2	pedro
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
peen	6	59	3808	2	peen
peep	8	58	3369	2	peep
peers	7	51	3027	2	peers
peery	10	57	1944	2	peery
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
pein	6	58	3494	2	pein
pekan	11	16	1397	2	pekan
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pelf	9	70	3145	2	pelf
pelt	6	76	5108	2	pelt
pen	5	65	5884	2	pe_n
penal	7	52	2837	2	penal
pend	7	59	3453	2	pend
pens	6	56	4964	2	pens
pent	6	65	5907	2	pent
peon	6	56	3524	2	peon
pep	7	64	4708	2	pe_p
pepo	8	76	2215	2	pepo
peps	8	51	3451	2	peps
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
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
petard	9	50	1380	2	petard
peter	7	44	2759	2	peter
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
pia	5	68	4803	2	pia_
pial	6	56	3670	2	pial
pian	6	61	3609	2	pian
pias	6	65	4255	2	pias
pier	6	60	3529	2	pier
pilar	7	52	2150	2	pilar
plan	6	58	3394	2	plan
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
polar	7	56	2345	2	polar
poor	6	56	3022	2	poor
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
prearm	10	45	1234	2	prearm
prewar	11	47	1257	2	prewar
pur	5	68	4055	2	p_ur
purr	6	49	2581	2	purr
pya	8	70	2375	2	pya_
pyas	9	62	2570	2	pyas
read	5	59	4253	2	read
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rearm	7	59	2356	2	rearm
rears	5	47	3965	2	rears
rebar	7	54	2019	2	rebar
roar	4	63	2857	2	roar
scar	6	64	3420	2	scar
sea	3	61	6129	2	sea_
seal	4	56	5437	2	seal
seam	6	66	4597	2	seam
sears	5	47	4491	2	sears
seas	4	57	5527	2	seas
seat	4	75	7556	2	seat
seer	4	55	4704	2	seer
ser	3	67	5240	2	se_r
sera	4	61	4139	2	sera
sewar	8	54	2109	2	sewar
shear	8	54	2483	2	shear
smear	7	44	1639	2	smear
soar	4	68	3867	2	soar
spar	6	54	3330	2	spar
speak	11	46	1867	2	speak
spean	7	46	2051	2	spean
spears	8	40	1947	2	spears
speer	7	46	2390	2	speer
speir	7	53	1536	2	speir
star	4	80	3776	2	star
swear	8	53	1685	2	swear
tar	3	75	7069	2	_tar
tea	3	73	5332	2	tea_
teak	8	59	3084	2	teak
teal	4	55	4650	2	teal
team	6	62	3865	2	team
tears	5	54	3646	2	tears
teary	8	51	2405	2	teary
teas	4	58	5149	2	teas
teat	4	59	6363	2	teat
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
upbear	10	9	649	2	upbear
uprear	8	16	879	2	uprear
uptear	8	9	678	2	uptear
var	6	61	4833	2	_var
veal	7	69	3681	2	veal
veer	7	62	2957	2	veer
velar	8	58	1763	2	velar
vera	7	68	2884	2	vera
war	6	72	6242	2	_war
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
wean	7	57	3435	2	wean
wears	8	60	3030	2	wears
weary	11	56	2061	2	weary
weer	7	55	3509	2	weer
weir	7	60	1992	2	weir
yar	6	72	5383	2	_yar
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
yearn	8	63	1643	2	yearn
years	8	45	2767	2	years
yeas	7	86	3842	2	yeas
zeal	13	55	3033	2	zeal

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	29872	0.063	2836365.1
2	DLD Change Limit	29872	320	1.716	17407.9
3	Display Results	320	320	0.140	2285.7
	(SQL Overall)	178691	320	1.919	93116.7