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

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

404 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
sear	4	73	5384	(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
pear	6	97	4523	1	pear
rear	4	56	4455	1	rear
scar	6	64	3420	1	scar
sea	3	61	6129	1	sea_
seal	4	56	5437	1	seal
seam	6	66	4597	1	seam
sears	5	47	4491	1	sears
seas	4	57	5527	1	seas
seat	4	75	7556	1	seat
seer	4	55	4704	1	seer
ser	3	67	5240	1	se_r
sera	4	61	4139	1	sera
sewar	8	54	2109	1	sewar
shear	8	54	2483	1	shear
smear	7	44	1639	1	smear
soar	4	68	3867	1	soar
spar	6	54	3330	1	spar
spear	7	58	2106	1	spear
star	4	80	3776	1	star
swear	8	53	1685	1	swear
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
ar	2	113	7938	2	__ar
asea	4	63	2718	2	asea_
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
escar	7	40	1199	2	escar
eskar	9	45	745	2	eskar
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
osar	4	68	2095	2	osar
par	5	74	6702	2	_par
pea	5	66	5724	2	pea_
peag	7	54	3134	2	peag
peak	10	65	3520	2	peak
peal	6	86	4810	2	peal
pean	6	61	4717	2	pean
pearl	7	53	2446	2	pearl
pears	7	51	3861	2	pears
peart	7	64	4075	2	peart
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
peer	6	62	3835	2	peer
per	5	63	5309	2	pe_r
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
sab	5	65	6320	2	s_ab
sac	5	74	5286	2	s_ac
sad	4	74	5920	2	s_ad
sae	3	83	6518	2	s_ae
sag	4	61	6340	2	s_ag
sal	3	64	6288	2	s_al
sap	5	64	6323	2	s_ap
sard	5	53	4424	2	s_ard
sari	4	54	4404	2	s_ari
sark	8	49	3897	2	s_ark
sat	3	62	8848	2	s_at
sau	3	63	5657	2	s_au
saw	6	82	5535	2	s_aw
sax	10	74	4764	2	s_ax
say	6	72	6476	2	s_ay
scab	8	59	2671	2	scab
scad	7	57	2576	2	scad
scag	7	66	2689	2	scag
scam	8	59	3235	2	scam
scan	6	55	3045	2	scan
scare	7	53	3446	2	scare
scarf	10	54	2714	2	scarf
scarp	9	57	2410	2	scarp
scars	7	54	3353	2	scars
scart	7	61	3977	2	scart
scary	10	52	2259	2	scary
scat	6	58	4837	2	scat
scaur	7	58	1490	2	scaur
sealer	6	39	2896	2	sealer
seals	5	48	3969	2	seals
seamer	8	42	2361	2	seamer
seams	7	57	3166	2	seams
seamy	10	59	2127	2	seamy
search	11	33	1242	2	search
seared	7	52	3284	2	seared
searer	6	54	3202	2	searer
seater	6	45	3415	2	seater
seats	5	48	4434	2	seats
sec	5	59	4532	2	se_c
secpar	10	3	792	2	secpar
secs	6	50	3389	2	secs
sect	6	74	4362	2	sect
sedan	6	56	2042	2	sedan
seder	6	48	2675	2	seder
see	3	57	7226	2	se_e
seed	5	55	4948	2	seed
seek	8	59	3548	2	seek
seel	4	50	4298	2	seel
seem	6	54	3856	2	seem
seen	4	69	4312	2	seen
seep	6	65	4034	2	seep
seers	5	51	3638	2	seers
sees	4	53	6105	2	sees
seg	4	55	4488	2	se_g
seggar	8	35	781	2	seggar
sego	5	65	2518	2	sego
segs	5	49	3388	2	segs
sei	3	60	4893	2	se_i
seif	7	56	3873	2	seif
seis	4	55	4239	2	seis
sel	3	82	5332	2	se_l
selah	8	3	1961	2	selah
self	7	51	3829	2	self
sell	4	58	4061	2	sell
sels	4	63	4598	2	sels
seme	6	58	3665	2	seme
semi	6	51	2722	2	semi
sen	3	60	5852	2	se_n
senary	9	37	1607	2	senary
send	5	52	3729	2	send
sene	4	68	4805	2	sene
senor	5	38	2279	2	senor
sent	4	69	6301	2	sent
sepal	7	77	2300	2	sepal
sept	6	58	4436	2	sept
serac	7	59	2520	2	serac
serai	5	68	3016	2	serai
seral	5	63	3638	2	seral
sere	4	61	5347	2	sere
serer	5	59	3550	2	serer
serf	7	63	4011	2	serf
serry	8	48	2412	2	serry
sers	4	57	4665	2	sers
set	3	66	8125	2	se_t
seta	4	56	3731	2	seta
setae	5	60	2622	2	setae
setal	5	64	3090	2	setal
sets	4	55	4950	2	sets
sett	4	59	4905	2	sett
sever	8	54	2605	2	sever
sew	6	62	4726	2	se_w
sewan	8	59	2129	2	sewan
sewars	9	40	1862	2	sewars
sewer	8	44	2621	2	sewer
sewn	7	61	2433	2	sewn
sews	7	58	3602	2	sews
sex	10	70	4322	2	se_x
sext	11	73	3809	2	sext
sexy	14	64	1802	2	sexy
sha	6	98	3778	2	sha_
shad	8	62	3091	2	shad
shag	8	64	3056	2	shag
shah	10	56	2778	2	shah
sham	9	64	3635	2	sham
shard	9	61	2596	2	shard
share	8	64	3708	2	share
shark	12	62	2502	2	shark
sharn	8	48	2370	2	sharn
sharp	10	49	2253	2	sharp
shat	7	64	5659	2	shat
shaw	10	81	3255	2	shaw
shay	10	71	3334	2	shay
shea	7	60	3157	2	shea_
sheaf	11	54	2412	2	sheaf
sheal	8	49	2770	2	sheal
shears	9	38	2090	2	shears
sheas	8	63	3179	2	sheas
sheer	8	47	2689	2	sheer
shmear	11	7	693	2	shmear
sial	4	59	3883	2	sial
sieur	5	9	1189	2	sieur
simar	7	49	2081	2	simar
sir	3	57	4667	2	s_ir
sitar	5	48	2054	2	sitar
sizar	14	52	1499	2	sizar
ska	7	69	2586	2	ska_
skag	9	63	2151	2	skag
skas	8	53	2571	2	skas
skat	8	70	3789	2	skat
skean	9	44	1562	2	skean
slab	6	71	3376	2	slab
slag	5	59	3435	2	slag
slam	6	77	3797	2	slam
slap	6	64	3404	2	slap
slat	4	69	5902	2	slat
slaw	7	79	3071	2	slaw
slay	7	64	3638	2	slay
slur	4	55	2515	2	slur
smarm	9	55	1760	2	smarm
smart	7	58	3409	2	smart
smears	8	47	1443	2	smears
smeary	11	41	1080	2	smeary
snag	5	58	2787	2	snag
snap	6	57	2703	2	snap
snare	5	44	2998	2	snare
snarf	8	65	2542	2	snarf
snark	9	54	1994	2	snark
snarl	5	49	2108	2	snarl
snaw	7	89	2307	2	snaw
sneak	9	60	1617	2	sneak
sneap	7	55	1482	2	sneap
sneer	5	49	1995	2	sneer
soak	8	72	2766	2	soak
soap	6	58	3113	2	soap
soars	5	47	3251	2	soars
sofar	8	61	1549	2	sofar
solar	5	59	2734	2	solar
sonar	5	65	2342	2	sonar
sora	4	57	4691	2	sora
sour	4	59	3589	2	sour
sowar	8	58	2134	2	sowar
spa	5	57	3081	2	spa_
spae	6	50	3432	2	spae
spam	8	59	3004	2	spam
span	6	52	3466	2	span
spare	7	51	3556	2	spare
spark	11	49	2089	2	spark
spars	7	54	3154	2	spars
spas	6	70	3672	2	spas
spat	6	65	4852	2	spat
spay	9	66	3166	2	spay
spaz	15	56	2616	2	spaz
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
spur	6	53	2119	2	spur
stab	6	73	2993	2	stab
stag	5	73	3200	2	stag
stair	5	47	1993	2	stair
stare	5	44	4026	2	stare
stark	9	54	2562	2	stark
stars	5	58	3657	2	stars
start	5	56	4231	2	start
stat	4	73	5269	2	stat
staw	7	86	2769	2	staw
stay	7	83	3372	2	stay
stead	6	55	2027	2	stead
steak	9	52	1980	2	steak
steal	5	61	2547	2	steal
steam	7	63	2292	2	steam
steer	5	54	2386	2	steer
stelar	6	40	1386	2	stelar
stir	4	57	2324	2	stir
suer	4	53	3403	2	suer
sugar	6	3	1291	2	sugar
sura	4	57	4029	2	sura
swab	9	68	2531	2	swab
swag	8	75	2673	2	swag
swam	9	63	2998	2	swam
swan	7	66	3131	2	swan
swap	9	59	2543	2	swap
sward	9	42	2146	2	sward
sware	8	58	2821	2	sware
swarf	11	53	2465	2	swarf
swarm	10	62	1883	2	swarm
swart	8	62	3464	2	swart
swat	7	72	4444	2	swat
sway	10	71	2823	2	sway
swears	9	41	1407	2	swears
sweat	8	56	2840	2	sweat
sweer	8	49	1857	2	sweer
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
user	4	50	2300	2	use_r
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 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.076	2351197.4
2	DLD Change Limit	29872	404	0.953	31345.2
3	Display Results	404	404	0.093	4344.1
	(SQL Overall)	178691	404	1.122	159261.1