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

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

361 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
read	5	59	4253	(None)
bead	7	59	3792	1	bead
bread	8	55	2311	1	bread
dead	6	54	3424	1	dead
dread	7	44	1902	1	dread
head	8	71	3717	1	head
lead	5	60	3885	1	lead
mead	7	55	3160	1	mead
oread	6	46	1960	1	oread
rad	4	76	6200	1	r_ad
readd	7	46	1713	1	readd
reads	6	48	3527	1	reads
ready	9	48	2150	1	ready
real	4	57	5029	1	real
ream	6	58	4161	1	ream
reap	6	59	3474	1	reap
rear	4	56	4455	1	rear
red	4	67	5580	1	re_d
redd	6	63	2317	1	redd
reed	5	55	4962	1	reed
rend	5	61	3657	1	rend
road	5	63	3211	1	road
tread	6	48	2170	1	tread
ad	3	119	7503	2	__ad
ahead	9	68	1705	2	ahead
area	4	58	4339	2	area_
areae	5	52	2974	2	areae
areal	5	59	2873	2	areal
areas	5	59	3577	2	areas
bad	6	77	6315	2	_bad
beads	8	54	2950	2	beads
beady	11	47	1992	2	beady
beak	10	65	3438	2	beak
beam	8	69	3923	2	beam
bean	6	64	4386	2	bean
bear	6	68	4464	2	bear
beard	8	60	2496	2	beard
beat	6	61	6830	2	beat
beau	6	61	3727	2	beau
bed	6	79	5062	2	be_d
bend	7	64	3526	2	bend
brad	7	52	3434	2	brad
breads	9	54	1920	2	breads
bready	12	45	1118	2	bready
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bred	7	51	3097	2	bre_d
breed	8	55	2669	2	breed
broad	8	48	1769	2	broad
cad	6	74	5636	2	_cad
chad	10	55	2550	2	chad
clad	7	62	2582	2	clad
creak	11	54	1843	2	creak
cream	9	57	2135	2	cream
cred	7	65	3088	2	cre_d
creed	8	57	2739	2	creed
dad	5	84	5616	2	_dad
deads	7	57	2691	2	deads
deaf	8	58	3840	2	deaf
deal	5	63	4741	2	deal
dean	5	60	3948	2	dean
dear	5	53	4360	2	dear
deed	6	53	4090	2	deed
dreads	8	41	1502	2	dreads
dream	8	51	2039	2	dream
drear	6	50	1690	2	drear
dreed	7	52	2284	2	dreed
dryad	10	47	758	2	dryad
duad	6	65	2141	2	duad
dyad	9	64	1545	2	dyad
ear	3	68	6788	2	_ear
eat	3	69	8905	2	_eat
eau	3	74	5094	2	_eau
ed	3	86	4518	2	_e_d
egad	6	42	1541	2	egad
eld	4	67	3379	2	_eld
end	4	68	3435	2	_end
era	3	57	4150	2	era_
eras	4	54	4150	2	eras
fad	7	74	5241	2	_fad
feal	7	139	4042	2	feal
fear	7	53	3779	2	fear
feat	7	64	5822	2	feat
fed	7	65	4835	2	fe_d
feed	8	45	3890	2	feed
fend	8	48	3297	2	fend
feod	8	155	2300	2	feod
feud	8	65	2302	2	feud
freak	12	51	1524	2	freak
freed	9	52	2354	2	freed
fremd	11	50	1032	2	fremd
gad	5	75	5665	2	_gad
gaed	6	60	3151	2	gaed
gear	5	59	3497	2	gear
ged	5	70	4453	2	ge_d
geed	6	54	3550	2	geed
geld	6	58	2843	2	geld
glad	6	56	2401	2	glad
goad	6	68	3098	2	goad
grad	6	68	2986	2	grad
great	6	60	3424	2	great
greed	7	51	2569	2	greed
had	7	76	5876	2	_had
haed	8	63	3858	2	haed
heads	9	51	2711	2	heads
heady	12	51	1726	2	heady
heal	7	56	4569	2	heal
heap	9	64	3289	2	heap
hear	7	61	4388	2	hear
heard	9	52	2275	2	heard
heat	7	70	6142	2	heat
heed	8	64	3760	2	heed
held	8	53	3040	2	held
herd	8	49	3306	2	herd
hexad	16	49	1062	2	hexad
ired	5	51	3187	2	ire_d
jean	11	66	2928	2	jean
jeed	12	54	2850	2	jeed
jehad	16	3	768	2	jehad
kea	7	65	4091	2	kea_
keas	8	63	3709	2	keas
knead	10	42	966	2	knead
lad	4	81	6570	2	_lad
lea	3	76	6018	2	lea_
leads	6	60	2849	2	leads
leady	9	56	1860	2	leady
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
lear	4	70	4595	2	lear
leas	4	59	5418	2	leas
led	4	62	5455	2	le_d
lend	5	62	3367	2	lend
leud	5	72	2342	2	leud
lewd	8	57	1659	2	lewd
load	5	67	3060	2	load
mad	6	89	5871	2	_mad
meads	8	54	2532	2	meads
meal	6	56	4317	2	meal
mean	6	55	3809	2	mean
meat	6	63	5960	2	meat
med	6	61	4674	2	me_d
meed	7	49	3470	2	meed
meld	7	58	3047	2	meld
menad	8	59	1898	2	menad
mend	7	53	3403	2	mend
neap	6	69	2701	2	neap
near	4	52	3650	2	near
neat	4	63	5678	2	neat
need	5	49	3415	2	need
nerd	5	66	2494	2	nerd
orad	5	60	3169	2	orad
oreads	7	39	1577	2	oreads
pad	6	80	5732	2	_pad
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
pear	6	97	4523	2	pear
peas	6	57	5506	2	peas
peat	6	59	6793	2	peat
ped	6	67	5152	2	pe_d
peed	7	62	3918	2	peed
pend	7	59	3453	2	pend
plead	8	58	1846	2	plead
preed	8	51	2812	2	preed
quad	14	46	1870	2	quad
rads	5	60	4660	2	r_ads
rag	4	57	6132	2	r_ag
rah	6	80	5240	2	r_ah
rai	3	76	5822	2	r_ai
raid	5	52	4307	2	raid
raj	10	57	4022	2	r_aj
ram	5	68	6727	2	r_am
ran	3	82	6662	2	r_an
rand	5	58	3957	2	rand
rap	5	62	6196	2	r_ap
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
readds	8	41	1164	2	readds
reader	7	36	2829	2	reader
realm	7	56	2162	2	realm
reals	5	50	3865	2	reals
reamed	9	43	2612	2	reamed
reams	7	57	2962	2	reams
reaped	9	41	2245	2	reaped
reaps	7	56	2619	2	reaps
reared	7	59	3001	2	reared
rearm	7	59	2357	2	rearm
rears	5	47	3965	2	rears
reata	5	42	2539	2	reata
reave	8	45	2802	2	reave
reaved	10	45	2392	2	reaved
reb	5	58	4496	2	re_b
rebar	7	54	2019	2	rebar
rebid	8	51	2136	2	rebid
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
reclad	9	3	1187	2	reclad
recs	6	57	3418	2	recs
redan	6	61	2501	2	redan
redds	7	46	1783	2	redds
rede	5	50	3767	2	rede
reded	7	48	2912	2	reded
redid	7	49	2239	2	redid
redo	5	60	2936	2	redo
reds	5	60	4286	2	reds
ree	3	79	7407	2	re_e
reeds	6	54	3090	2	reeds
reedy	9	100	2029	2	reedy
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
refed	9	39	2192	2	refed
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
regs	5	54	3657	2	regs
rehab	10	3	1244	2	rehab
rei	3	56	4725	2	re_i
reif	7	69	3765	2	reif
rein	4	60	4089	2	rein
reis	4	53	4323	2	reis
relaid	7	55	1844	2	relaid
reland	7	59	2043	2	reland
relax	12	48	1780	2	relax
relay	8	44	2467	2	relay
reload	7	4	1389	2	reload
rely	7	54	2895	2	rely
rem	5	61	5004	2	re_m
remade	9	43	1698	2	remade
reman	7	57	3015	2	reman
remand	9	56	1896	2	remand
remap	9	54	1810	2	remap
rems	6	62	3772	2	rems
renal	5	59	2950	2	renal
rends	6	51	2995	2	rends
rent	4	66	6124	2	rent
rep	5	58	4780	2	re_p
repaid	9	47	1632	2	repaid
repand	9	53	1606	2	repand
repay	10	48	1845	2	repay
repo	6	60	2754	2	repo
repp	8	54	1874	2	repp
reps	6	59	3795	2	reps
reran	5	73	2910	2	reran
reread	7	17	1543	2	reread
res	3	55	6504	2	re_s
resaid	7	45	1708	2	resaid
resat	5	51	3968	2	resat
resaw	8	41	1725	2	resaw
resay	8	53	2054	2	resay
resh	7	65	2345	2	resh
resid	6	41	2409	2	resid
resod	6	47	2005	2	resod
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
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	1764	2	reward
rewax	15	57	1392	2	rewax
rewed	9	54	2545	2	rewed
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
rid	4	67	5463	2	r_id
rind	5	65	3560	2	rind
roads	6	65	2362	2	roads
roam	6	71	3241	2	roam
roan	4	72	3420	2	roan
roar	4	63	2857	2	roar
rod	4	79	5389	2	r_od
rood	5	67	3300	2	rood
rudd	6	59	1747	2	rudd
rued	5	57	2979	2	rued
rya	6	76	2201	2	rya_
ryas	7	72	2461	2	ryas
rynd	8	64	1410	2	rynd
sad	4	74	5920	2	_sad
scad	7	57	2577	2	scad
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
seed	5	55	4948	2	seed
send	5	52	3729	2	send
shad	8	62	3091	2	shad
spread	9	3	1253	2	spread
stead	6	55	2027	2	stead
tad	4	79	5982	2	_tad
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
ted	4	64	4656	2	te_d
teed	5	54	3926	2	teed
tend	5	64	3377	2	tend
thread	10	50	1109	2	thread
toad	5	58	3018	2	toad
trad	5	56	3091	2	trad
treads	7	48	1792	2	treads
treat	5	62	4035	2	treat
treed	6	56	2673	2	treed
trend	6	48	1745	2	trend
triad	6	52	1772	2	triad
unread	7	34	1267	2	unread
urea	4	65	2806	2	urea_
ureal	5	67	2268	2	ureal
ureas	5	58	2601	2	ureas
veal	7	69	3681	2	veal
veld	8	53	2320	2	veld
vend	8	66	2642	2	vend
wad	7	70	5389	2	_wad
weak	11	71	2630	2	weak
weal	7	58	3868	2	weal
weald	9	56	1502	2	weald
wean	7	57	3435	2	wean
wear	7	58	3672	2	wear
wed	7	58	4362	2	we_d
weed	8	56	3751	2	weed
weld	8	47	2773	2	weld
wend	8	53	3045	2	wend
woad	8	55	2394	2	woad
wreak	12	55	1327	2	wreak
yea	6	64	4575	2	yea_
yeah	10	67	2541	2	yeah
yean	7	58	3458	2	yean
year	7	65	3425	2	year
yeas	7	86	3842	2	yeas
yeld	8	114	2387	2	yeld
zeal	13	55	3033	2	zeal
zed	13	54	3117	2	ze_d

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.296	603685.8
2	DLD Change Limit	29872	361	0.920	32469.6
3	Display Results	361	361	0.080	4512.5
	(SQL Overall)	178691	361	1.296	137878.9