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

Here are the results of your fuzzy-string dictionary search for “bearded” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

76 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
bearded	11	42	1213	(None)
barded	10	54	2642	1	b_arded
beaded	10	49	2242	1	bea_ded
boarded	11	39	1050	1	boarded
awarded	12	3	622	2	awarded
balded	10	54	1751	2	b_alded
banded	10	52	2317	2	b_anded
barbed	11	51	2131	2	b_arbed
barde	8	53	3077	2	b_arde_
bardes	9	50	2693	2	b_ardes
bared	8	51	4448	2	b_ar_ed
barfed	12	54	1638	2	b_arfed
barged	10	58	2264	2	b_arged
barked	13	50	2731	2	b_arked
barned	9	56	2358	2	b_arned
barred	9	57	2579	2	b_arred
beached	15	45	1655	2	beached
beader	9	46	2379	2	bea_der
beaked	13	59	1949	2	bea_ked
beamed	11	57	2073	2	bea_med
beaned	9	56	2147	2	bea_ned
beard	8	60	2496	2	bear__d
beards	9	41	1667	2	beard_s
bearer	8	53	2391	2	bear_er
bedded	11	51	1406	2	be_dded
begirded	13	3	417	2	begirded
belauded	12	4	479	2	belauded
bended	10	55	2123	2	be_nded
beraked	14	43	1243	2	beraked
berated	10	44	2213	2	berated
bermed	11	52	1772	2	be_rmed
berried	10	37	1404	2	berried
betided	11	48	1020	2	betided
bewared	13	3	1011	2	bewar_ed
birded	10	44	1430	2	b_irded
bladed	10	47	1776	2	bla_ded
blared	9	50	1824	2	blar_ed
bleared	10	42	1125	2	blear_ed
boarder	10	39	1032	2	boarder
bradded	12	38	871	2	bradded
braided	11	40	1321	2	braided
branded	11	44	1410	2	branded
breaded	11	50	1406	2	brea_ded
carded	10	54	2490	2	_carded
debearded	14	4	337	2	debearded
eared	6	51	3950	2	_ear_ed
earned	7	48	1833	2	_earned
farded	11	45	1895	2	_farded
feared	10	63	2043	2	fear_ed
geared	8	53	1774	2	gear_ed
guarded	10	3	615	2	guarded
headed	11	40	2047	2	hea_ded
hearsed	11	38	1140	2	hearsed
hearted	11	33	1402	2	hearted
herded	11	42	1564	2	he_rded
hoarded	12	36	834	2	hoarded
larded	8	43	1909	2	_larded
leaded	8	42	2154	2	lea_ded
learned	8	32	930	2	learned
neared	7	51	1980	2	near_ed
pearled	10	4	1153	2	pearled
readded	10	33	1073	2	readded
reared	7	59	3001	2	rear_ed
rearmed	10	39	1282	2	rearmed
regarded	11	27	980	2	regarded
retarded	10	24	1075	2	retarded
rewarded	13	22	952	2	rewarded
seared	7	52	3284	2	sear_ed
swarded	12	3	815	2	swarded
teared	7	57	2215	2	tear_ed
unbearded	13	14	634	2	unbearded
warded	11	50	2104	2	_warded
wearied	11	29	1180	2	wearied
weirded	12	3	451	2	weirded
yarded	11	47	1402	2	_yarded
yearned	11	32	737	2	yearned

Search took 9 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	107671	0.296	603685.8
2	DLD Change Limit	107671	76	8.140	13227.4
3	Display Results	76	76	0.046	1652.2
	(SQL Overall)	178691	76	8.482	21067.1