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

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

363 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
rede	5	50	3767	(None)
brede	8	55	2050	1	brede
cede	7	49	2877	1	cede
red	4	67	5580	1	red_
redd	6	63	2317	1	redd
reded	7	48	2912	1	reded
redes	6	51	3913	1	redes
redo	5	60	2936	1	redo
reds	5	60	4286	1	reds
redye	9	44	1347	1	redye
ree	3	79	7407	1	re_e
reed	5	55	4962	1	reed
rete	4	49	4413	1	rete
ride	5	59	4513	1	ride
rode	5	58	4430	1	rode
rude	5	56	3278	1	rude
aedes	6	46	2515	2	aedes
aide	5	60	4500	2	aide
areae	5	52	2974	2	areae
arene	5	53	2941	2	arene
arete	5	60	3135	2	arete
bade	7	51	4088	2	bade
bed	6	79	5062	2	bed_
bedel	8	42	1940	2	bedel
bedew	11	45	1304	2	bedew
beds	7	59	3778	2	beds
bedu	7	59	2369	2	bedu
bee	5	62	6240	2	be_e
bene	6	64	3949	2	bene
bide	7	60	4150	2	bide
bode	7	58	3875	2	bode
bred	7	51	3097	2	bred_
bredes	9	48	1847	2	bredes
bree	6	72	4126	2	bre_e
breed	8	55	2669	2	breed
breve	10	53	1705	2	breve
bride	8	64	2553	2	bride
cade	7	64	4391	2	cade
ceded	9	61	1856	2	ceded
ceder	8	53	2224	2	ceder
cedes	8	49	2733	2	cedes
cedi	7	49	1927	2	cedi
cee	5	59	5270	2	ce_e
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
code	7	73	4773	2	code
cred	7	65	3088	2	cred_
credo	8	48	1557	2	credo
creds	8	54	1877	2	creds
creed	8	57	2739	2	creed
creme	9	43	1932	2	creme
crepe	9	55	2072	2	crepe
crude	8	60	1857	2	crude
de	3	70	4954	2	__de
dee	4	76	6582	2	de_e
deed	6	53	4090	2	deed
deke	9	52	2876	2	deke
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
dene	5	66	4341	2	dene
dere	5	68	4590	2	dere
dredge	9	30	856	2	dredge
dree	5	66	3832	2	dre_e
dreed	7	52	2284	2	dreed
dude	6	56	2966	2	dude
ed	3	86	4518	2	_ed_
edge	6	57	1968	2	_edge
edh	7	69	2156	2	_edh
eds	4	66	3892	2	_eds
eide	5	58	3224	2	eide
eke	7	56	3009	2	_eke
eme	5	58	3718	2	_eme
ere	3	63	5277	2	_ere
erne	4	67	2743	2	erne
erode	6	45	2099	2	erode
eve	6	63	3116	2	_eve
ewe	6	66	3098	2	_ewe
eye	6	55	3977	2	_eye
fade	8	57	3634	2	fade
fed	7	65	4835	2	fed_
fedex	16	9	960	2	fedex
feds	8	52	3431	2	feds
fee	6	68	6201	2	fe_e
feed	8	45	3890	2	feed
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
free	7	59	4018	2	fre_e
freed	9	52	2354	2	freed
frere	8	56	1772	2	frere
ged	5	70	4453	2	ged_
geds	6	67	3081	2	geds
gee	4	53	5920	2	ge_e
geed	6	54	3550	2	geed
gene	5	62	3722	2	gene
geode	7	4	1259	2	geode
glede	7	55	1783	2	glede
grade	7	51	2609	2	grade
grebe	8	51	1494	2	grebe
gree	5	66	4156	2	gre_e
greed	7	51	2569	2	greed
gride	7	52	2358	2	gride
gude	6	54	2333	2	gude
hade	8	54	4019	2	hade
hebe	9	64	2470	2	hebe
heder	9	56	2364	2	heder
hedge	10	53	1735	2	hedge
heed	8	64	3760	2	heed
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hide	8	51	3464	2	hide
irade	6	56	1815	2	irade
ired	5	51	3187	2	ired_
jade	12	53	2544	2	jade
jee	10	66	4864	2	je_e
jeed	12	54	2850	2	jeed
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
kedge	11	55	1373	2	kedge
krewe	12	3	819	2	krewe
lade	5	63	4598	2	lade
led	4	62	5455	2	led_
ledge	7	65	1949	2	ledge
lee	3	60	6814	2	le_e
leke	8	55	2740	2	leke
lode	5	62	4011	2	lode
lude	5	53	3164	2	lude
made	7	54	4024	2	made
med	6	61	4674	2	med_
meds	7	57	3536	2	meds
meed	7	49	3470	2	meed
meme	8	53	3055	2	meme
merde	8	43	2012	2	merde
mere	6	72	4444	2	mere
mete	6	44	3813	2	mete
meze	15	44	2090	2	meze
mode	7	58	4030	2	mode
nee	3	66	5778	2	ne_e
need	5	49	3415	2	need
nene	4	59	3206	2	nene
neve	7	62	2483	2	neve
nide	5	55	3579	2	nide
node	5	130	3688	2	node
nude	5	66	2627	2	nude
ode	4	74	4658	2	_ode
oreide	7	3	1167	2	oreide
ped	6	67	5152	2	ped_
pedes	8	53	2729	2	pedes
peds	7	58	3524	2	peds
pee	5	60	6651	2	pe_e
peed	7	62	3918	2	peed
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pere	6	64	5026	2	pere
pree	6	70	4473	2	pre_e
preed	8	51	2812	2	preed
prese	7	52	2838	2	prese
pride	8	47	2473	2	pride
prude	8	46	1597	2	prude
race	6	67	4626	2	race
rad	4	76	6200	2	rad_
rads	5	60	4660	2	rads
rage	5	57	4235	2	rage
rake	8	48	4157	2	rake
rale	4	50	5056	2	rale
rape	6	50	4163	2	rape
rare	4	53	4843	2	rare
rase	4	61	4998	2	rase
rate	4	54	5876	2	rate
rave	7	55	4209	2	rave
raze	13	52	3543	2	raze
re	2	61	5374	2	r__e
read	5	59	4253	2	read
readd	7	46	1713	2	readd
reader	7	36	2829	2	reader
reads	6	48	3527	2	reads
ready	9	48	2150	2	ready
real	4	57	5029	2	real
ream	6	58	4161	2	ream
reap	6	59	3474	2	reap
rear	4	56	4455	2	rear
reave	8	45	2802	2	reave
reb	5	58	4496	2	re_b
rebbe	9	3	1316	2	rebbe
rebec	9	44	1654	2	rebec
rebel	7	34	2129	2	rebel
rebs	6	57	3356	2	rebs
rec	5	56	4546	2	re_c
recce	9	5	1456	2	recce
recede	9	55	1553	2	recede
reck	10	61	3056	2	reck
recode	9	36	1871	2	recode
recs	6	57	3418	2	recs
redan	6	61	2501	2	redan
redate	7	41	2468	2	redate
redded	9	40	1955	2	redded
redden	8	36	1362	2	redden
redder	8	39	1814	2	redder
reddle	8	38	1591	2	reddle
redds	7	46	1783	2	redds
redear	7	35	1517	2	redear
redeem	9	3	1153	2	redeem
redefy	13	38	876	2	redefy
redeny	10	27	1273	2	redeny
redeye	10	38	1179	2	redeye
redia	6	55	2448	2	redia
rediae	7	42	2199	2	rediae
redid	7	49	2239	2	redid
redip	8	78	1696	2	redip
redleg	8	3	927	2	redleg
redly	9	42	1720	2	redly
redoes	7	46	2377	2	redoes
redon	6	54	2488	2	redon
redone	7	48	2005	2	redone
redos	6	51	2676	2	redos
redox	13	47	1423	2	redox
redrew	10	30	951	2	redrew
redry	9	43	1436	2	redry
redub	8	42	1241	2	redub
reduce	9	7	1325	2	reduce
redux	13	38	1110	2	redux
redyed	11	46	1124	2	redyed
redyes	10	42	1409	2	redyes
reeded	8	40	2256	2	reeded
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
reeve	8	41	2132	2	reeve
ref	6	60	5329	2	re_f
refed	9	39	2192	2	refed
refel	8	49	2081	2	refel
refer	8	48	2214	2	refer
refs	7	57	3224	2	refs
reft	7	51	4127	2	reft
reg	4	61	4649	2	re_g
reges	6	56	2879	2	reges
regs	5	54	3657	2	regs
rehem	10	38	1535	2	rehem
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
reive	8	55	2294	2	reive
rekey	12	40	1473	2	rekey
relet	5	47	4982	2	relet
rely	7	54	2895	2	rely
rem	5	61	5004	2	re_m
remade	9	43	1698	2	remade
remet	7	48	4372	2	remet
remex	14	63	1579	2	remex
rems	6	62	3772	2	rems
rend	5	61	3657	2	rend
rended	8	45	2410	2	rended
render	7	40	2414	2	render
rends	6	51	2995	2	rends
renew	8	39	1751	2	renew
rent	4	66	6124	2	rent
rente	5	47	3378	2	rente
rep	5	58	4780	2	re_p
repeg	8	40	1505	2	repeg
repel	7	49	2140	2	repel
repo	6	60	2754	2	repo
repp	8	54	1874	2	repp
reps	6	59	3795	2	reps
res	3	55	6504	2	re_s
resee	5	43	3633	2	resee
reset	5	50	5186	2	reset
resew	8	45	1950	2	resew
resh	7	65	2345	2	resh
reside	7	42	2493	2	reside
rest	4	64	5984	2	rest
ret	3	59	8283	2	re_t
retem	7	42	2195	2	retem
retie	5	57	3530	2	retie
rets	4	53	5256	2	rets
reuse	5	60	2536	2	reuse
rev	6	53	3662	2	re_v
revel	8	44	2316	2	revel
revet	8	49	3884	2	revet
revs	7	50	2705	2	revs
revue	8	11	1445	2	revue
rewed	9	54	2545	2	rewed
rewet	8	51	3515	2	rewet
rex	10	57	4099	2	re_x
rexes	12	45	2695	2	rexes
rheme	10	62	1405	2	rheme
rice	6	49	4291	2	rice
rid	4	67	5463	2	rid_
rider	6	52	3130	2	rider
rides	6	61	4081	2	rides
ridge	7	50	1867	2	ridge
rids	5	65	3955	2	rids
rife	7	46	3232	2	rife
rile	4	56	5053	2	rile
rime	6	51	3888	2	rime
ripe	6	60	3892	2	ripe
rise	4	59	4523	2	rise
rite	4	58	4945	2	rite
rive	7	55	3772	2	rive
robe	6	53	3564	2	robe
rod	4	79	5389	2	rod_
rodeo	6	59	2109	2	rodeo
rodes	6	140	3908	2	rodes
rods	5	64	4206	2	rods
roe	3	68	6108	2	r_oe
role	4	58	5182	2	role
rope	6	55	4291	2	rope
rose	4	61	4890	2	rose
rote	4	62	4902	2	rote
roue	4	59	4174	2	roue
rove	7	51	3698	2	rove
rube	6	55	3201	2	rube
rudd	6	59	1747	2	rudd
ruder	6	53	2054	2	ruder
rue	3	55	4926	2	r_ue
rued	5	57	2979	2	rued_
rule	4	99	3842	2	rule
rune	4	52	3630	2	rune
ruse	4	59	3893	2	ruse
rye	6	60	3254	2	r_ye
ryke	11	56	1640	2	ryke
sade	5	55	4447	2	sade
seder	6	48	2676	2	seder
sedge	7	50	1997	2	sedge
see	3	57	7226	2	se_e
seed	5	55	4948	2	seed
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
side	5	54	4449	2	side
suede	6	44	1975	2	suede
swede	9	44	1320	2	swede
ted	4	64	4656	2	ted_
teds	5	49	3257	2	teds
tee	3	83	6687	2	te_e
teed	5	54	3926	2	teed
tele	4	50	4087	2	tele
tide	5	52	3738	2	tide
trade	6	50	2604	2	trade
tree	4	77	4581	2	tre_e
treed	6	56	2673	2	treed
trode	6	53	2285	2	trode
unde	5	58	2548	2	unde
uredo	6	51	1299	2	uredo
ureide	7	3	1036	2	ureide
vee	6	57	5018	2	ve_e
vide	8	54	3276	2	vide
wade	8	52	3706	2	wade
wed	7	58	4362	2	wed_
wedel	9	45	1396	2	wedel
wedge	10	52	1566	2	wedge
weds	8	66	2893	2	weds
wee	6	67	6081	2	we_e
weed	8	56	3751	2	weed
were	7	62	3833	2	were
wide	8	52	3541	2	wide
zed	13	54	3117	2	zed_
zeds	14	58	2180	2	zeds
zee	12	61	4323	2	ze_e

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.283	631417.0
2	DLD Change Limit	29872	363	0.890	33564.0
3	Display Results	363	363	0.093	3903.2
	(SQL Overall)	178691	363	1.266	141146.1