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

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

236 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
barked	13	50	2731	(None)
backed	15	57	2572	1	backed
baked	12	61	3077	1	ba_ked
balked	13	52	1941	1	balked
banked	13	50	2144	1	banked
barbed	11	51	2131	1	barbed
barded	10	54	2642	1	barded
bared	8	51	4448	1	bar_ed
barfed	12	54	1638	1	barfed
barged	10	58	2264	1	barged
barker	12	48	2286	1	barker
barned	9	56	2358	1	barned
barred	9	57	2580	1	barred
basked	13	52	1860	1	basked
borked	13	51	1729	1	borked
braked	13	53	1869	1	braked
burked	13	52	2088	1	burked
carked	13	40	2482	1	carked
darked	12	39	1963	1	darked
harked	14	54	2255	1	harked
larked	11	45	1947	1	larked
marked	13	39	2162	1	marked
narked	11	41	1674	1	narked
parked	13	44	2514	1	parked
warked	14	44	2121	1	warked
arced	8	82	2416	2	_arced
arcked	13	62	1194	2	_arcked
armed	8	63	2444	2	_armed
asked	10	69	1931	2	_asked
baaed	8	52	1816	2	ba_aed
babied	11	49	1351	2	babied
bached	14	55	1989	2	bached
backer	14	45	2553	2	backer
badged	11	48	1479	2	badged
baffed	15	48	1217	2	baffed
bagged	11	45	1990	2	bagged
bailed	9	47	2665	2	bailed
baited	9	53	1924	2	baited
bake	10	56	3751	2	ba_ke_
baker	11	56	2954	2	ba_ker
bakes	11	70	3537	2	ba_kes
balded	10	54	1751	2	balded
baled	8	54	3644	2	ba_led
balker	12	45	1916	2	balker
balled	9	49	2689	2	balled
bammed	13	39	1324	2	bammed
banded	10	52	2317	2	banded
baned	8	54	3635	2	ba_ned
banged	10	49	2373	2	banged
banker	12	42	2273	2	banker
banned	9	47	2134	2	banned
barbe	9	53	2828	2	barbe_
barbel	10	43	1707	2	barbel
barber	10	44	1932	2	barber
barbes	10	45	2623	2	barbes
barbet	10	44	2788	2	barbet
bard	7	56	4886	2	bar__d
barde	8	53	3077	2	barde_
bardes	9	50	2693	2	bardes
bare	6	54	6052	2	bar_e_
barer	7	45	3580	2	bar_er
bares	7	54	5713	2	bar_es
barge	8	56	3102	2	barge_
bargee	9	46	2445	2	bargee
barges	9	45	2825	2	barges
bark	10	62	4215	2	bark__
barkeep	15	3	636	2	barkeep
barkers	13	43	1851	2	barkers
barkier	13	38	1448	2	barkier
barks	11	57	3581	2	bark_s
barky	14	57	2161	2	bark_y
barley	11	51	1676	2	barley
barmen	10	54	1854	2	barmen
barney	11	53	1445	2	barney
barre	7	59	2955	2	barre_
barrel	8	45	1788	2	barrel
barren	8	53	1762	2	barren
barres	8	44	2755	2	barres
barret	8	49	3049	2	barret
bartend	10	3	875	2	bartend
barter	8	55	2538	2	barter
barye	10	50	2149	2	barye_
baryes	11	62	1850	2	baryes
based	8	53	3158	2	ba_sed
bashed	12	62	2570	2	bashed
basket	12	57	2291	2	basket
basted	9	52	2723	2	basted
bated	8	59	3553	2	ba_ted
bathed	12	55	1874	2	bathed
batiked	14	3	596	2	batiked
batted	9	56	2365	2	batted
baulked	14	46	562	2	baulked
bawled	12	44	1569	2	bawled
bayed	11	54	2302	2	ba_yed
beaked	13	59	1949	2	beaked
bearded	11	42	1213	2	bearded
becked	15	54	1776	2	becked
beraked	14	43	1243	2	beraked
bermed	11	52	1772	2	bermed
biked	12	53	2003	2	b_iked
bilked	13	40	1294	2	bilked
birded	10	44	1430	2	birded
birled	9	44	1699	2	birled
birred	9	47	1320	2	birred
blacked	16	36	1337	2	blacked
blanked	14	40	1122	2	blanked
blared	9	50	1824	2	blar_ed
boarded	11	39	1050	2	boarded
bonked	13	55	1731	2	bonked
booked	13	53	1950	2	booked
bored	8	50	3430	2	bor_ed
braced	11	54	2060	2	braced
brake	11	60	2534	2	brake_
brakes	12	49	2312	2	brakes
braved	12	48	1744	2	braved
brayed	12	46	1578	2	brayed
brazed	18	47	1708	2	brazed
bred	7	51	3097	2	b_r_ed
breed	8	55	2669	2	b_reed
bucked	15	51	2106	2	bucked
bulked	13	42	1674	2	bulked
bunked	13	51	1837	2	bunked
buried	9	48	2237	2	buried
burke	11	51	2276	2	burke_
burker	12	52	2117	2	burker
burkes	12	44	2131	2	burkes
burled	9	48	2538	2	burled
burned	9	58	1896	2	burned
burped	11	62	1550	2	burped
burred	9	58	2072	2	burred
busked	13	49	1770	2	busked
byrled	12	43	717	2	byrled
caked	12	61	2862	2	ca_ked
calked	13	46	1740	2	calked
carded	10	54	2490	2	carded
cared	8	60	5009	2	car_ed
caried	9	45	2869	2	caried
carped	11	59	2376	2	carped
carted	9	86	3144	2	carted
carved	12	43	2085	2	carved
casked	13	48	1551	2	casked
charked	17	48	1401	2	charked
corked	13	50	2078	2	corked
dared	7	59	3501	2	dar_ed
darken	11	40	1344	2	darken
darker	11	47	1869	2	darker
darkey	14	52	1242	2	darkey
darkled	13	37	872	2	darkled
darned	8	50	1848	2	darned
darted	8	46	2092	2	darted
debarked	16	17	583	2	debarked
dirked	12	49	1227	2	dirked
eared	6	51	3950	2	ear_ed
earned	7	48	1833	2	earned
embarked	17	20	522	2	embarked
faked	13	52	2548	2	fa_ked
farced	12	52	1653	2	farced
farded	11	45	1895	2	farded
fared	9	58	4234	2	far_ed
farmed	12	51	1766	2	farmed
farted	10	51	2178	2	farted
forked	14	52	1714	2	forked
garbed	10	48	1566	2	garbed
garred	8	52	1741	2	garred
gawked	15	46	876	2	gawked
hacked	16	49	2351	2	hacked
hanked	14	42	2060	2	hanked
hared	9	57	4218	2	har_ed
harken	13	51	1634	2	harken
harmed	12	52	1884	2	harmed
harped	12	44	1840	2	harped
hawked	17	47	1267	2	hawked
imbarked	17	25	406	2	imbarked
irked	10	45	1092	2	_irked
jacked	20	48	1752	2	jacked
jarred	14	46	1325	2	jarred
jauked	18	48	901	2	jauked
jerked	18	47	959	2	jerked
lacked	13	53	2465	2	lacked
laked	10	57	3112	2	la_ked
larded	8	43	1909	2	larded
larker	10	45	1924	2	larker
lurked	11	45	1197	2	lurked
marker	12	44	2039	2	marker
market	12	32	2604	2	market
marled	9	55	2317	2	marled
marred	9	54	2104	2	marred
marted	9	44	2521	2	marted
masked	13	43	1652	2	masked
naked	10	53	2085	2	na_ked
oared	6	50	3065	2	oar_ed
packed	15	48	2260	2	packed
paiked	13	51	1343	2	paiked
pared	8	69	4676	2	par_ed
parged	10	49	2204	2	parged
parker	12	41	2137	2	parker
parled	9	46	2629	2	parled
parred	9	50	2407	2	parred
parsed	9	63	2389	2	parsed
parted	9	42	2868	2	parted
perked	13	46	1769	2	perked
porked	13	47	1762	2	porked
racked	13	45	2608	2	racked
raked	10	58	3142	2	ra_ked
ranked	11	46	2074	2	ranked
rared	6	57	3832	2	rar_ed
sacked	13	55	2521	2	sacked
sharked	15	36	1391	2	sharked
sparked	14	35	1314	2	sparked
tacked	13	47	2394	2	tacked
talked	11	40	1540	2	talked
tanked	11	39	1930	2	tanked
tared	6	93	4005	2	tar_ed
tarred	7	47	2028	2	tarred
tarted	7	49	2337	2	tarted
tasked	11	47	1464	2	tasked
varied	10	48	1786	2	varied
varved	13	41	1060	2	varved
waked	13	56	2675	2	wa_ked
walked	14	53	1378	2	walked
wanked	14	45	1715	2	wanked
warded	11	50	2104	2	warded
wared	9	63	3987	2	war_ed
warmed	12	45	1690	2	warmed
warned	10	40	1891	2	warned
warped	12	48	1641	2	warped
warred	10	40	1985	2	warred
warted	10	42	2323	2	warted
wauked	14	42	1057	2	wauked
worked	14	53	1470	2	worked
yacked	16	45	1679	2	yacked
yakked	13	36	609	2	yakked
yanked	14	43	1224	2	yanked
yarded	11	47	1402	2	yarded
yarned	10	55	1402	2	yarned
yerked	14	50	937	2	yerked

Search took 5 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	82551	0.550	324892.7
2	DLD Change Limit	82551	236	3.296	25045.8
3	Display Results	236	236	0.186	1268.8
	(SQL Overall)	178691	236	4.032	44318.2