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

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

346 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
rear	4	56	4455	(None)
bear	6	68	4464	1	bear
dear	5	53	4360	1	dear
drear	6	50	1690	1	drear
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
read	5	59	4253	1	read
real	4	57	5029	1	real
ream	6	58	4161	1	ream
reap	6	59	3474	1	reap
rearm	7	59	2356	1	rearm
rears	5	47	3965	1	rears
rebar	7	54	2019	1	rebar
roar	4	63	2857	1	roar
sear	4	73	5384	1	sear
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
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areal	5	59	2873	2	areal
areas	5	59	3577	2	areas
arrear	6	3	1025	2	arrear
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
bread	8	55	2311	2	bread
break	11	53	1940	2	break
bream	9	51	2181	2	bream
briar	7	57	1815	2	briar
car	5	91	6556	2	_car
cedar	8	40	1432	2	cedar
char	9	51	3215	2	char
clear	7	62	1905	2	clear
creak	11	54	1843	2	creak
cream	9	57	2134	2	cream
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
dread	7	44	1902	2	dread
dream	8	51	2039	2	dream
drears	7	46	1425	2	drears
dreary	10	46	1167	2	dreary
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_
eras	4	54	4150	2	eras
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
freak	12	51	1524	2	freak
freer	8	60	2124	2	freer
friar	8	54	1427	2	friar
gar	4	72	5990	2	_gar
gears	6	46	2869	2	gears
gnar	5	60	2138	2	gnar
great	6	60	3424	2	great
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
oread	6	46	1960	2	oread
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
prearm	10	45	1234	2	prearm
prewar	11	47	1257	2	prewar
rad	4	76	6200	2	r_ad
radar	6	13	1672	2	radar
rag	4	57	6132	2	r_ag
rah	6	80	5240	2	r_ah
rai	3	76	5822	2	r_ai
raj	10	57	4022	2	r_aj
ram	5	68	6727	2	r_am
ran	3	82	6661	2	r_an
rap	5	62	6196	2	r_ap
rare	4	53	4843	2	r_are
ras	3	75	7539	2	r_as
rat	3	78	9274	2	r_at
raw	6	72	5225	2	r_aw
rax	10	84	4572	2	r_ax
ray	6	63	6199	2	r_ay
re	2	61	5374	2	re__
reach	10	51	2388	2	reach
react	7	46	3433	2	react
readd	7	46	1713	2	readd
reader	7	36	2829	2	reader
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
realer	6	35	2859	2	realer
realm	7	56	2162	2	realm
reals	5	50	3865	2	reals
reamer	8	43	2521	2	reamer
reams	7	57	2962	2	reams
reaper	8	42	2314	2	reaper
reaps	7	56	2619	2	reaps
reared	7	59	3001	2	reared
rearer	6	49	2891	2	rearer
rearms	8	51	1465	2	rearms
reata	5	42	2539	2	reata
reave	8	45	2802	2	reave
reaver	9	45	2473	2	reaver
reb	5	58	4496	2	re_b
rebars	8	40	1982	2	rebars
rebs	6	57	3356	2	rebs
rec	5	56	4546	2	re_c
recap	9	57	1802	2	recap
reck	10	61	3056	2	reck
recs	6	57	3418	2	recs
recur	7	41	1684	2	recur
red	4	67	5580	2	re_d
redan	6	61	2501	2	redan
redd	6	63	2317	2	redd
rede	5	50	3766	2	rede
redear	7	35	1517	2	redear
redo	5	60	2936	2	redo
redry	9	43	1436	2	redry
reds	5	60	4286	2	reds
ree	3	79	7407	2	re_e
reearn	6	6	1214	2	reearn
reed	5	55	4962	2	reed
reef	7	49	3821	2	reef
reek	8	52	3252	2	reek
reel	4	52	4053	2	reel
rees	4	53	6419	2	rees
ref	6	60	5329	2	re_f
refer	8	48	2214	2	refer
refry	11	44	1246	2	refry
refs	7	57	3224	2	refs
reft	7	51	4127	2	reft
reg	4	61	4649	2	re_g
regal	6	50	2379	2	regal
regard	8	52	1577	2	regard
regear	7	35	1274	2	regear
regs	5	54	3657	2	regs
rehab	10	3	1244	2	rehab
rehear	9	37	1322	2	rehear
rei	3	56	4725	2	re_i
reif	7	69	3764	2	reif
rein	4	60	4089	2	rein
reis	4	53	4323	2	reis
relax	12	48	1780	2	relax
relay	8	44	2467	2	relay
rely	7	54	2895	2	rely
rem	5	61	5004	2	re_m
reman	7	57	3015	2	reman
remap	9	54	1810	2	remap
remark	12	35	1237	2	remark
rems	6	62	3772	2	rems
renal	5	59	2950	2	renal
rend	5	61	3657	2	rend
rent	4	66	6124	2	rent
rep	5	58	4780	2	re_p
repair	8	40	1146	2	repair
repark	12	35	1171	2	repark
repay	10	48	1845	2	repay
repo	6	60	2754	2	repo
repp	8	54	1874	2	repp
repro	7	53	1591	2	repro
reps	6	59	3795	2	reps
reran	5	73	2910	2	reran
res	3	55	6504	2	re_s
resat	5	51	3968	2	resat
resaw	8	41	1725	2	resaw
resay	8	53	2054	2	resay
resh	7	65	2345	2	resh
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
retag	6	36	1841	2	retag
retard	7	50	1893	2	retard
retax	12	45	1797	2	retax
rete	4	49	4413	2	rete
retear	6	31	1548	2	retear
retro	5	50	2095	2	retro
retry	8	47	1808	2	retry
rets	4	53	5256	2	rets
rev	6	53	3662	2	re_v
revs	7	50	2705	2	revs
rewan	8	56	2366	2	rewan
reward	10	60	1763	2	reward
rewarm	11	59	1348	2	rewarm
rewax	15	57	1392	2	rewax
rewear	9	30	1199	2	rewear
rex	10	57	4099	2	re_x
rhea	7	50	1743	2	rhea_
rheas	8	48	1695	2	rheas
ria	3	67	4550	2	ria_
rial	4	59	3809	2	rial
rias	4	55	4059	2	rias
road	5	63	3211	2	road
roam	6	71	3241	2	roam
roan	4	72	3420	2	roan
roars	5	56	2223	2	roars
ruer	4	61	2756	2	ruer
rya	6	76	2201	2	rya_
ryas	7	72	2461	2	ryas
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
spear	7	58	2106	2	spear
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
tread	6	48	2170	2	tread
treat	5	62	4035	2	treat
tsar	4	78	1980	2	tsar
tzar	13	63	1537	2	tzar
uprear	8	16	879	2	uprear
urea	4	65	2805	2	urea_
ureal	5	67	2268	2	ureal
ureas	5	58	2601	2	ureas
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
wreak	12	55	1327	2	wreak
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	346	1.003	29782.7
3	Display Results	346	346	0.093	3720.4
	(SQL Overall)	178691	346	1.172	152466.7