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

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

330 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
lark	8	57	3386	(None)
ark	7	70	4496	1	_ark
bark	10	62	4215	1	bark
cark	10	55	3927	1	cark
dark	9	51	3321	1	dark
hark	11	52	3739	1	hark
lack	10	58	3768	1	lack
lank	8	47	3445	1	lank
lar	3	79	6753	1	lar_
lard	5	67	4200	1	lard
lari	4	58	3915	1	lari
larks	9	52	2781	1	larks
larky	12	52	1887	1	larky
lars	4	69	5657	1	lars
lurk	8	66	2416	1	lurk
mark	10	51	3806	1	mark
nark	8	52	3006	1	nark
park	10	52	3749	1	park
sark	8	49	3897	1	sark
wark	11	57	3777	1	wark
alack	11	48	2006	2	alack
alar	4	63	4007	2	alar_
alarm	7	66	2142	2	alarm
alary	8	61	2344	2	alary
ar	2	113	7938	2	_ar_
arak	8	69	2958	2	_arak
arb	5	104	4842	2	_arb
arc	5	102	5090	2	_arc
are	3	78	7457	2	_are
arf	6	74	5337	2	_arf
arks	8	59	3687	2	_arks
arm	5	84	4963	2	_arm
ars	3	76	7093	2	_ars
art	3	86	7914	2	_art
ask	7	71	3070	2	_ask
auk	7	62	3414	2	_auk
back	12	55	3576	2	back
balk	10	51	3222	2	balk
bank	10	58	3575	2	bank
bar	5	80	7055	2	bar_
barb	8	52	4006	2	barb
bard	7	56	4886	2	bard
bare	6	54	6052	2	bare
barf	9	58	4441	2	barf
barks	11	57	3581	2	barks
barky	14	57	2161	2	barky
barm	8	67	3961	2	barm
barn	6	64	4464	2	barn
bars	6	65	6409	2	bars
bask	10	51	3142	2	bask
berk	10	59	2984	2	berk
birk	10	63	2687	2	birk
black	13	47	1907	2	black
blank	11	54	1855	2	blank
blare	7	58	2623	2	blare
bork	10	69	3382	2	bork
calk	10	55	2766	2	calk
car	5	91	6556	2	car_
carb	8	51	4316	2	carb
card	7	102	4587	2	card
care	6	69	6837	2	care
carks	11	55	3421	2	carks
carl	6	51	4478	2	carl
carn	6	62	4543	2	carn
carp	8	51	3981	2	carp
carr	6	54	3470	2	carr
cars	6	73	6476	2	cars
cart	6	65	7034	2	cart
cask	10	56	2643	2	cask
chark	14	42	2271	2	chark
clack	13	47	2017	2	clack
clank	11	47	1952	2	clank
claro	7	50	1869	2	claro
clary	10	57	1961	2	clary
clerk	11	58	1245	2	clerk
cork	10	66	3569	2	cork
dak	8	63	4069	2	da_k
dank	9	58	2824	2	dank
darb	7	60	3353	2	darb
dare	5	58	4886	2	dare
darks	10	67	2787	2	darks
darky	13	60	1883	2	darky
darn	5	64	3462	2	darn
dart	5	58	5787	2	dart
dawk	12	61	1728	2	dawk
dirk	9	63	2684	2	dirk
dork	9	65	3146	2	dork
ear	3	68	6788	2	ear_
earl	4	58	3814	2	earl
earn	4	67	3755	2	earn
ears	4	63	5659	2	ears
far	6	77	6260	2	far_
fard	8	56	3906	2	fard
fare	7	63	5446	2	fare
farl	7	63	3855	2	farl
farm	9	59	3454	2	farm
faro	7	61	3692	2	faro
fart	7	68	6056	2	fart
flack	14	45	1941	2	flack
flak	11	60	2617	2	fla_k
flank	12	46	1809	2	flank
flare	8	48	2363	2	flare
flask	12	55	1242	2	flask
fork	11	59	3094	2	fork
gar	4	72	5990	2	gar_
garb	7	53	3267	2	garb
gars	5	57	5074	2	gars
gawk	12	67	1669	2	gawk
glare	6	52	2296	2	glare
glary	9	60	1854	2	glary
hack	13	51	3454	2	hack
haik	11	55	2698	2	haik
hank	11	51	3414	2	hank
hard	8	54	4350	2	hard
hare	7	62	5573	2	hare
harks	12	63	3343	2	harks
harl	7	57	4000	2	harl
harm	9	56	3780	2	harm
harp	9	61	3429	2	harp
hart	7	68	6577	2	hart
hawk	14	55	2115	2	hawk
irk	7	64	2637	2	_irk
jack	17	52	2486	2	jack
jar	10	76	4615	2	jar_
jarl	11	58	2813	2	jarl
jars	11	73	3835	2	jars
jauk	15	58	1609	2	jauk
jerk	15	49	2013	2	jerk
karn	8	61	2943	2	karn
kart	8	67	5082	2	kart
kirk	7	62	2158	2	kirk
la	2	192	6163	2	la__
laari	5	44	1571	2	laari
lab	5	88	6478	2	la_b
labra	7	54	1546	2	labra
labs	6	71	4512	2	labs
lac	5	101	5582	2	la_c
lace	6	68	4847	2	lace
lacks	11	61	2920	2	lacks
lacs	6	69	4248	2	lacs
lacy	9	58	2963	2	lacy
lad	4	81	6571	2	la_d
lade	5	63	4599	2	lade
lads	5	65	4914	2	lads
lady	8	65	2716	2	lady
lag	4	78	6212	2	la_g
lags	5	65	4622	2	lags
laic	6	59	3156	2	laic
laid	5	64	3915	2	laid
lain	4	61	4628	2	lain
lair	4	59	3415	2	lair
laird	6	54	1779	2	laird
lairs	5	54	2587	2	lairs
lake	8	57	4160	2	lake
lakh	11	49	1995	2	lakh
laky	11	67	2582	2	laky
lall	4	55	3131	2	lall
lam	5	76	6671	2	la_m
lama	6	66	3530	2	lama
lamb	8	68	3214	2	lamb
lame	6	68	4929	2	lame
lamp	8	62	3382	2	lamp
lams	6	65	5226	2	lams
land	5	63	3731	2	land
lane	4	51	5333	2	lane
lang	5	66	3739	2	lang
lanky	12	55	1748	2	lanky
lap	5	85	6527	2	la_p
laps	6	68	4887	2	laps
larch	10	59	1979	2	larch
lards	6	53	3186	2	lards
lardy	9	61	1927	2	lardy
laree	5	60	3630	2	laree
lares	5	48	5263	2	lares
large	6	53	2546	2	large
largo	6	53	1978	2	largo
laris	5	47	3746	2	laris
larked	11	45	1947	2	larked
larker	10	45	1924	2	larker
larum	7	43	1797	2	larum
larva	8	3	1249	2	larva
las	3	72	8147	2	la_s
lase	4	61	4851	2	lase
lash	7	65	3965	2	lash
lass	4	74	4454	2	lass
last	4	62	6032	2	last
lat	3	75	9340	2	la_t
late	4	75	6048	2	late
lath	7	66	4038	2	lath
lati	4	64	3827	2	lati
latke	9	48	1709	2	latke
lats	4	59	6270	2	lats
latu	4	79	3418	2	latu
laud	5	65	2772	2	laud
laura	5	41	1620	2	laura
lav	6	68	4734	2	la_v
lava	7	67	2542	2	lava
lave	7	56	4214	2	lave
lavs	7	67	3415	2	lavs
law	6	86	5664	2	la_w
lawn	7	59	2563	2	lawn
laws	7	64	4168	2	laws
lax	10	76	5152	2	la_x
lay	6	88	6535	2	la_y
lays	7	60	4325	2	lays
laze	13	62	3505	2	laze
lazy	16	64	2307	2	lazy
leak	8	62	3371	2	leak
lear	4	70	4595	2	lear_
learn	5	53	2266	2	learn
lears	5	59	3873	2	lears
leary	8	59	2738	2	leary
leek	8	53	3173	2	leek
lek	7	56	4030	2	l_ek
liar	4	72	2969	2	liar_
liard	6	54	1859	2	liard
liars	5	47	2316	2	liars
lick	10	69	3508	2	lick
link	8	69	4345	2	link
lira	4	69	2869	2	lira
lire	4	78	4530	2	lire
liri	4	51	2826	2	liri
lock	10	61	3436	2	lock
look	8	73	3347	2	look
lord	5	50	3208	2	lord
lore	4	58	5035	2	lore
lorn	4	64	3525	2	lorn
lory	7	59	3171	2	lory
luck	10	53	2982	2	luck
lunk	8	60	3072	2	lunk
lure	4	51	4246	2	lure
lurks	9	52	1874	2	lurks
lyard	9	51	1321	2	lyard
lyart	8	51	2188	2	lyart
lyre	7	56	2379	2	lyre
mack	12	57	3365	2	mack
mar	5	79	6595	2	mar_
mara	6	74	4458	2	mara
marc	8	70	3463	2	marc
mare	6	47	5933	2	mare
marka	11	46	2080	2	marka
marks	11	59	3348	2	marks
marl	6	63	4162	2	marl
mars	6	62	6187	2	mars
mart	6	68	6598	2	mart
mask	10	52	2736	2	mask
merk	10	60	2794	2	merk
mirk	10	67	2951	2	mirk
murk	10	55	2725	2	murk
narc	6	71	2795	2	narc
nard	5	66	3445	2	nard
narks	9	60	2603	2	narks
narky	12	60	1780	2	narky
nary	7	69	3122	2	nary
oak	7	62	3865	2	oa_k
oar	3	70	5795	2	oar_
oars	4	68	4603	2	oars
pack	12	55	3544	2	pack
paik	10	57	2680	2	paik
par	5	74	6702	2	par_
para	6	52	4218	2	para
pard	7	64	4132	2	pard
pare	6	67	6084	2	pare
parka	11	51	2089	2	parka
parks	11	61	3446	2	parks
parr	6	57	3115	2	parr
pars	6	75	6079	2	pars
part	6	59	6746	2	part
perk	10	62	3284	2	perk
plack	13	50	1784	2	plack
plank	11	52	2114	2	plank
pork	10	69	2968	2	pork
quark	18	46	1412	2	quark
rack	10	62	3488	2	rack
rank	8	51	3553	2	rank
rare	4	53	4843	2	rare
sack	10	53	3731	2	sack
sank	8	52	3683	2	sank
sard	5	53	4424	2	sard
sari	4	54	4404	2	sari
sarks	9	66	3246	2	sarks
sarky	12	55	2178	2	sarky
shark	12	62	2502	2	shark
slack	11	50	2176	2	slack
slank	9	58	2277	2	slank
snark	9	54	1994	2	snark
spark	11	49	2089	2	spark
stark	9	54	2562	2	stark
tack	10	65	3629	2	tack
talk	8	62	3009	2	talk
tank	8	51	3403	2	tank
tar	3	75	7069	2	tar_
tare	4	59	5762	2	tare
tarn	4	68	4272	2	tarn
taro	4	68	4691	2	taro
tarok	9	79	2107	2	tarok
tarp	6	69	3642	2	tarp
tars	4	67	6395	2	tars
tart	4	75	6618	2	tart
task	8	53	2665	2	task
turk	8	61	2586	2	turk
var	6	61	4833	2	var_
vara	7	55	3089	2	vara
vars	7	57	4207	2	vars
vary	10	52	2606	2	vary
wack	13	53	3091	2	wack
walk	11	56	2561	2	walk
wank	11	56	3251	2	wank
war	6	72	6242	2	war_
ward	8	65	4225	2	ward
ware	7	62	5472	2	ware
warks	12	79	3240	2	warks
warm	9	59	3568	2	warm
warn	7	52	3932	2	warn
warp	9	56	3500	2	warp
wars	7	86	5980	2	wars
wart	7	78	6608	2	wart
wary	10	67	4001	2	wary
wauk	11	52	2059	2	wauk
work	11	55	2884	2	work
yack	13	54	2597	2	yack
yak	10	70	3856	2	ya_k
yank	11	54	2367	2	yank
yar	6	72	5383	2	yar_
yard	8	56	3325	2	yard
yare	7	56	3694	2	yare
yarn	7	52	3004	2	yarn
yerk	11	62	2208	2	yerk
zarf	16	69	2912	2	zarf
zerk	17	53	1925	2	zerk

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.300	595636.7
2	DLD Change Limit	29872	330	1.076	27762.1
3	Display Results	330	330	0.063	5238.1
	(SQL Overall)	178691	330	1.439	124177.2