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

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

357 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
bred	7	51	3097	(None)
bared	8	51	4448	1	bared
bed	6	79	5062	1	b_ed
bled	7	57	2931	1	bled
bored	8	50	3430	1	bored
brad	7	52	3434	1	brad
bread	8	55	2311	1	bread
brede	8	55	2050	1	brede
bree	6	72	4126	1	bree
breed	8	55	2669	1	breed
bren	6	56	2956	1	bren
brew	9	50	2356	1	brew
cred	7	65	3088	1	cred
ired	5	51	3187	1	ired
red	4	67	5580	1	_red
abed	7	97	3413	2	abed
abled	8	69	2683	2	abled
aced	7	95	4088	2	aced
acred	8	71	2635	2	acred
aged	6	73	3425	2	aged
ahed	8	95	3625	2	ahed
aired	6	60	3292	2	aired
aped	7	85	3815	2	aped
arced	8	82	2416	2	arced
are	3	78	7457	2	are_
area	4	58	4339	2	area
ares	4	58	7102	2	ares
arid	5	76	4271	2	arid
armed	8	63	2443	2	armed
awed	8	84	3603	2	awed
axed	12	88	2961	2	axed
baaed	8	52	1816	2	baaed
bad	6	77	6315	2	b_ad
bade	7	51	4088	2	bade
baked	12	61	3077	2	baked
bald	7	64	3290	2	bald
baled	8	54	3644	2	baled
band	7	67	4090	2	band
baned	8	54	3635	2	baned
barbed	11	51	2131	2	barbed
bard	7	56	4886	2	bard
barde	8	53	3077	2	barde
barded	10	54	2642	2	barded
bare	6	54	6052	2	bare_
barer	7	45	3580	2	barer
bares	7	54	5713	2	bares
barfed	12	54	1638	2	barfed
barged	10	58	2264	2	barged
barked	13	50	2731	2	barked
barned	9	56	2358	2	barned
barred	9	57	2579	2	barred
based	8	53	3158	2	based
bated	8	59	3553	2	bated
baud	7	49	2842	2	baud
bawd	10	55	2084	2	bawd
bayed	11	54	2302	2	bayed
be	4	79	4894	2	b_e_
bead	7	59	3792	2	bead
beds	7	59	3778	2	b_eds
bedu	7	59	2369	2	b_edu
bee	5	62	6240	2	b_ee
beedi	8	7	1166	2	beedi
beef	9	62	3368	2	beef
been	6	53	3578	2	been
beep	8	59	3121	2	beep
beer	6	56	3599	2	beer
bees	6	54	5338	2	bees
beet	6	64	5754	2	beet
beg	6	59	4413	2	b_eg
bel	5	71	4846	2	b_el
ben	5	65	5492	2	b_en
bend	7	64	3526	2	bend
beret	7	49	4636	2	beret
berg	7	54	2554	2	berg
berk	10	59	2984	2	berk
berm	8	67	3275	2	berm
bermed	11	52	1772	2	bermed
bes	5	65	5743	2	b_es
bet	5	83	7667	2	b_et
bey	8	66	4542	2	b_ey
bid	6	77	5179	2	b_id
bide	7	60	4148	2	bide
bided	9	54	2496	2	bided
bield	8	46	1465	2	bield
bier	6	55	3183	2	bier
biked	12	53	2003	2	biked
bind	7	62	3451	2	bind
biped	10	47	1883	2	biped
bird	7	61	2832	2	bird
birded	10	44	1430	2	birded
birled	9	44	1699	2	birled
birred	9	47	1320	2	birred
blared	9	50	1824	2	blared
bleb	8	54	2522	2	bleb
bleed	8	50	1980	2	bleed
blend	8	53	1745	2	blend
blet	6	62	4767	2	blet
blew	9	47	2243	2	blew
blued	8	45	2032	2	blued
bod	6	70	5554	2	b_od
bode	7	58	3875	2	bode
boded	9	51	2496	2	boded
bold	7	54	3281	2	bold
bond	7	53	3436	2	bond
boned	8	51	3324	2	boned
booed	8	51	2727	2	booed
bore	6	60	5133	2	bore_
borer	7	51	3127	2	borer
bores	7	64	4825	2	bores
borked	13	51	1729	2	borked
bowed	11	45	3342	2	bowed
boxed	15	43	1861	2	boxed
bra	5	63	3946	2	br_a
braced	11	54	2060	2	braced
brads	8	55	2829	2	brads
brae	6	56	3911	2	brae
braes	7	57	3505	2	braes
brag	7	52	2972	2	brag
braid	8	58	2226	2	braid
braked	13	53	1869	2	braked
bran	6	57	4038	2	bran
brand	8	51	2449	2	brand
bras	6	57	4645	2	bras
brat	6	60	5554	2	brat
braved	12	48	1744	2	braved
braw	9	48	2956	2	braw
bray	9	52	3290	2	bray
brayed	12	46	1578	2	brayed
brazed	18	47	1708	2	brazed
breads	9	54	1920	2	breads
bready	12	45	1118	2	bready
break	11	53	1940	2	break
bream	9	51	2181	2	bream
bredes	9	48	1847	2	bredes
breeds	9	49	1488	2	breeds
brees	7	56	3255	2	brees
brens	7	58	2336	2	brens
brent	7	57	3413	2	brent
breve	10	53	1705	2	breve
brewed	12	54	1187	2	brewed
brews	10	56	1707	2	brews
bribed	11	53	1284	2	bribed
bride	8	64	2553	2	bride
brie	6	58	3790	2	brie
brief	10	54	2260	2	brief
brier	7	45	2740	2	brier
bries	7	49	4215	2	bries
brig	7	65	2803	2	brig
brim	8	56	2937	2	brim
brin	6	70	3819	2	brin
brined	9	51	1841	2	brined
brio	6	54	3249	2	brio
bris	6	55	3961	2	bris
brit	6	63	5015	2	brit
bro	5	62	3660	2	br_o
broad	8	48	1769	2	broad
broo	6	51	2982	2	broo
brood	8	46	2024	2	brood
bros	6	56	3566	2	bros
brow	9	72	2844	2	brow
browed	12	52	1639	2	browed
brr	5	69	2192	2	br_r
brrr	6	53	1229	2	brrr
brut	6	65	3796	2	brut
bruted	9	51	1326	2	bruted
brux	13	63	1527	2	brux
bruxed	16	46	698	2	bruxed
bud	6	70	4127	2	b_ud
bund	7	55	3066	2	bund
burd	7	55	3426	2	burd
buret	7	74	4401	2	buret
buried	9	48	2237	2	buried
burked	13	52	2088	2	burked
burled	9	48	2538	2	burled
burned	9	58	1896	2	burned
burped	11	62	1550	2	burped
burred	9	58	2072	2	burred
bused	8	56	2449	2	bused
bye	8	61	3459	2	bye_
byes	9	52	3053	2	byes
byre	9	50	2385	2	byre_
byres	10	44	2138	2	byres
byrled	12	43	717	2	byrled
cared	8	60	5009	2	cared
cered	8	52	2744	2	cered
coed	7	71	4054	2	coed
cored	8	50	4422	2	cored
credo	8	48	1556	2	credo
creds	8	54	1877	2	creds
creed	8	57	2739	2	creed
crew	9	61	2267	2	crew
cried	8	46	2428	2	cried
crud	7	52	1961	2	crud
cued	7	63	2956	2	cued
cured	8	59	3213	2	cured
dared	7	59	3501	2	dared
deed	6	53	4090	2	deed
died	6	61	3785	2	died
dread	7	44	1902	2	dread
dree	5	66	3832	2	dree
dreed	7	52	2284	2	dreed
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drew	8	62	2167	2	drew
dried	7	53	2138	2	dried
dured	7	50	2540	2	dured
dyed	9	67	2076	2	dyed
eared	6	51	3950	2	eared
ebbed	10	41	1100	2	ebbed
ed	3	86	4518	2	__ed
eked	9	67	1802	2	eked
ere	3	63	5277	2	ere_
erred	6	59	1567	2	erred
exed	12	54	2059	2	exed
eyed	8	66	2323	2	eyed
fared	9	58	4234	2	fared
fed	7	65	4835	2	_fed
feed	8	45	3890	2	feed
fired	9	48	2974	2	fired
fled	8	54	2977	2	fled
free	7	59	4018	2	free
freed	9	52	2354	2	freed
fremd	11	50	1032	2	fremd
fret	7	58	4504	2	fret
fried	9	53	2291	2	fried
gaed	6	60	3151	2	gaed
ged	5	70	4453	2	_ged
geed	6	54	3550	2	geed
gied	6	46	3198	2	gied
gled	6	56	3114	2	gled
gored	7	52	2708	2	gored
grad	6	68	2986	2	grad
gree	5	66	4156	2	gree
greed	7	51	2569	2	greed
grew	8	56	2026	2	grew
grey	8	56	2404	2	grey
grid	6	58	2961	2	grid
gyred	10	51	1409	2	gyred
haed	8	63	3858	2	haed
hared	9	57	4218	2	hared
heed	8	64	3760	2	heed
herd	8	49	3306	2	herd
hied	8	54	3404	2	hied
hired	9	52	2626	2	hired
hoed	8	78	3798	2	hoed
hued	8	69	2585	2	hued
iced	7	87	2189	2	iced
inbred	9	30	1040	2	inbred
ire	3	69	4317	2	ire_
ires	4	56	3928	2	ires
irid	5	59	2717	2	irid
irked	10	45	1092	2	irked
jeed	12	54	2850	2	jeed
led	4	62	5455	2	_led
lied	5	58	3809	2	lied
lured	6	54	2749	2	lured
med	6	61	4674	2	_med
meed	7	49	3470	2	meed
mired	8	57	2922	2	mired
mured	8	57	2670	2	mured
need	5	49	3415	2	need
nerd	5	66	2494	2	nerd
oared	6	50	3065	2	oared
ohed	8	78	2518	2	ohed
oped	7	62	3015	2	oped
orad	5	60	3169	2	orad
orbed	8	55	1619	2	orbed
ore	3	66	6183	2	ore_
oread	6	46	1960	2	oread
ores	4	60	5668	2	ores
owed	8	68	3387	2	owed
pared	8	69	4676	2	pared
ped	6	67	5152	2	_ped
peed	7	62	3918	2	peed
pied	7	50	3536	2	pied
pled	7	52	3143	2	pled
pored	8	52	3451	2	pored
pree	6	70	4473	2	pree
preed	8	51	2811	2	preed
prep	8	64	2767	2	prep
prex	13	57	2297	2	prex
prey	9	62	2848	2	prey
prez	15	61	2631	2	prez
pried	8	44	2686	2	pried
prod	7	61	2950	2	prod
rad	4	76	6200	2	_rad
rared	6	57	3832	2	rared
re	2	61	5374	2	_re_
read	5	59	4253	2	_read
reb	5	58	4496	2	_reb
rebred	9	58	1635	2	rebred
rec	5	56	4546	2	_rec
redd	6	63	2317	2	_redd
rede	5	50	3766	2	_rede
redo	5	60	2936	2	_redo
reds	5	60	4286	2	_reds
ree	3	79	7407	2	_ree
reed	5	55	4962	2	reed
ref	6	60	5329	2	_ref
reg	4	61	4649	2	_reg
rei	3	56	4725	2	_rei
rem	5	61	5004	2	_rem
rend	5	61	3657	2	_rend
rep	5	58	4780	2	_rep
res	3	55	6504	2	_res
ret	3	59	8283	2	_ret
rev	6	53	3662	2	_rev
rex	10	57	4099	2	_rex
rid	4	67	5462	2	_rid
rod	4	79	5389	2	_rod
rued	5	57	2979	2	rued
sabred	9	59	1653	2	sabred
seed	5	55	4948	2	seed
sered	6	57	3729	2	sered
shed	8	65	3615	2	shed
shred	9	81	2561	2	shred
sired	6	61	3428	2	sired
sled	5	53	3437	2	sled
sned	5	60	2605	2	sned
sored	6	61	4178	2	sored
sped	7	60	3149	2	sped
sued	5	65	3793	2	sued
tared	6	93	4005	2	tared
ted	4	64	4656	2	_ted
teed	5	54	3926	2	teed
tied	5	55	3521	2	tied
tired	6	52	2890	2	tired
toed	5	61	3704	2	toed
trad	5	56	3091	2	trad
tread	6	48	2170	2	tread
tree	4	77	4581	2	tree
treed	6	56	2673	2	treed
tref	7	70	3099	2	tref
trek	8	62	2231	2	trek
trend	6	48	1745	2	trend
tres	4	65	4290	2	tres
tret	4	66	5353	2	tret
trey	7	72	2879	2	trey
tried	6	50	2691	2	tried
trod	5	76	2795	2	trod
trued	6	51	1769	2	trued
tyred	9	58	1643	2	tyred
unbred	9	26	1330	2	unbred
urd	4	64	2704	2	ur_d
urea	4	65	2805	2	urea
uredo	6	51	1299	2	uredo
urged	7	53	1603	2	urged
urped	8	46	1528	2	urped
used	5	57	2282	2	used
vied	8	63	2863	2	vied
wared	9	63	3987	2	wared
wed	7	58	4362	2	_wed
weed	8	56	3751	2	weed
wired	9	53	2764	2	wired
wren	7	82	2168	2	wren
wried	9	55	1856	2	wried
zed	13	54	3117	2	_zed

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.280	638182.1
2	DLD Change Limit	29872	357	2.280	13101.8
3	Display Results	357	357	0.173	2063.6
	(SQL Overall)	178691	357	2.733	65382.7