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

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

284 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
barbs	9	59	2819	(None)
arbs	6	68	3473	1	_arbs
barb	8	52	4006	1	barb_
barbe	9	53	2828	1	barbe
barbes	10	45	2623	1	barbes
bards	8	71	3964	1	bards
bares	7	54	5713	1	bares
barfs	10	48	2600	1	barfs
barks	11	57	3581	1	barks
barms	9	61	2847	1	barms
barns	7	63	3514	1	barns
bars	6	65	6409	1	bar_s
burbs	9	54	2349	1	burbs
carbs	9	60	3146	1	carbs
darbs	8	53	2326	1	darbs
garbs	8	63	2141	1	garbs
abris	7	57	2261	2	abris
abs	5	93	5607	2	_a_bs
albs	6	86	2857	2	_albs
arb	5	104	4842	2	_arb_
arcs	6	78	3478	2	_arcs
ares	4	58	7102	2	_ares
arfs	7	60	2996	2	_arfs
arks	8	59	3687	2	_arks
arms	6	61	3750	2	_arms
ars	3	76	7093	2	_ar_s
arts	4	96	5026	2	_arts
baals	7	61	2270	2	baals
baas	6	68	4467	2	ba_as
baba	8	88	2835	2	ba_ba
babas	9	63	2573	2	babas
babe	8	68	3582	2	ba_be
babes	9	58	3411	2	babes
babu	8	58	2923	2	ba_bu
babus	9	56	2033	2	babus
baby	11	67	2368	2	ba_by
backs	13	57	2962	2	backs
bads	7	70	4887	2	ba_ds
baffs	13	47	1805	2	baffs
bags	7	66	4550	2	ba_gs
bahts	10	56	1780	2	bahts
bails	7	59	3352	2	bails
bairns	8	67	1087	2	bairns
baits	7	66	3058	2	baits
bakes	11	70	3537	2	bakes
balas	7	69	3721	2	balas
balds	8	55	2464	2	balds
bales	7	62	5008	2	bales
balks	11	49	2629	2	balks
balls	7	62	3641	2	balls
balms	9	57	2392	2	balms
bals	6	63	5404	2	ba_ls
bams	8	70	4445	2	ba_ms
bands	8	52	3343	2	bands
banes	7	49	4558	2	banes
bangs	8	56	2778	2	bangs
banks	11	55	2790	2	banks
banns	7	53	2123	2	banns
bans	6	65	5514	2	ba_ns
baps	8	60	4084	2	ba_ps
bar	5	80	7055	2	bar__
barbal	10	40	1667	2	barbal
barbed	11	51	2131	2	barbed
barbel	10	43	1707	2	barbel
barbels	11	45	1443	2	barbels
barber	10	44	1932	2	barber
barbers	11	43	1750	2	barbers
barbet	10	44	2788	2	barbet
barbets	11	49	1585	2	barbets
barbie	10	50	1835	2	barbie
barbies	11	45	1959	2	barbies
barbut	10	46	1700	2	barbut
barbuts	11	43	984	2	barbuts
barca	9	13	1944	2	barca
barcas	10	10	1661	2	barcas
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
bared	8	51	4448	2	bared
barer	7	45	3580	2	barer
barest	8	53	2769	2	barest
barf	9	58	4441	2	bar_f
barge	8	56	3102	2	barge
barges	9	45	2825	2	barges
baric	9	61	2569	2	baric
bark	10	62	4215	2	bar_k
barky	14	57	2161	2	barky
barm	8	67	3961	2	bar_m
barmy	12	52	1877	2	barmy
barn	6	64	4464	2	bar_n
barny	10	58	2173	2	barny
baron	7	81	3124	2	baron
barons	8	50	2538	2	barons
barre	7	59	2955	2	barre
barres	8	44	2755	2	barres
barye	10	50	2149	2	barye
baryes	11	62	1850	2	baryes
bas	5	86	8175	2	ba__s
bases	7	56	4435	2	bases
basis	7	54	2986	2	basis
basks	11	56	2176	2	basks
bass	6	61	4678	2	ba_ss
basts	7	59	3693	2	basts
bates	7	58	4634	2	bates
baths	10	59	2292	2	baths
bats	6	69	6233	2	ba_ts
batts	7	67	2756	2	batts
bauds	8	58	2104	2	bauds
bawds	11	61	1549	2	bawds
bawls	10	57	1932	2	bawls
bays	9	71	4391	2	ba_ys
beards	9	41	1667	2	beards
bears	7	57	3904	2	bear_s
bergs	8	47	1804	2	bergs
berks	11	54	2312	2	berks
berms	9	53	2366	2	berms
bibbs	8	49	1158	2	bibbs
bibs	8	48	3100	2	b_ibs
bicarbs	13	3	601	2	bicarbs
birds	8	54	2134	2	birds
birks	11	49	2030	2	birks
birls	7	40	2316	2	birls
biros	7	53	2513	2	biros
birrs	7	49	1710	2	birrs
blabs	9	56	1963	2	blabs
blares	8	50	2163	2	blares
blebs	9	64	1615	2	blebs
blobs	9	56	2003	2	blobs
blubs	9	58	1815	2	blubs
blurbs	10	48	931	2	blurbs
boards	9	46	1693	2	boards
boars	7	52	2960	2	boar_s
boarts	8	47	1687	2	boarts
bobs	8	63	4065	2	b_obs
bombs	11	58	1882	2	bombs
boobs	9	62	2199	2	boobs
boras	7	59	3830	2	boras
bores	7	64	4825	2	bores
borks	11	57	2770	2	borks
borts	7	67	3545	2	borts
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
brans	7	54	3743	2	brans
bras	6	57	4645	2	b_ras
brass	7	54	2802	2	brass
brats	7	53	3602	2	brats
braws	10	64	2519	2	braws
brays	10	67	2311	2	brays
bris	6	55	3961	2	b_ris
bros	6	56	3566	2	b_ros
bubs	8	62	3550	2	b_ubs
bulbs	9	60	1693	2	bulbs
buras	7	47	3630	2	buras
burb	8	53	3467	2	burb_
burds	8	46	2606	2	burds
burgs	8	49	2409	2	burgs
burls	7	42	2885	2	burls
burns	7	49	2678	2	burns
burps	9	42	2017	2	burps
burrs	7	49	2565	2	burrs
burs	6	58	4742	2	bur_s
byres	10	44	2138	2	byres
byrls	10	57	1123	2	byrls
cabs	8	67	3942	2	ca_bs
carb	8	51	4316	2	carb_
carbo	9	49	2384	2	carbo
carbos	10	51	2226	2	carbos
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carns	7	59	3756	2	carns
carobs	10	48	1810	2	carobs
carps	9	69	3225	2	carps
carrs	7	57	3085	2	carrs
cars	6	73	6476	2	car_s
carts	7	89	4629	2	carts
crabs	9	54	2139	2	crabs
curbs	9	48	2165	2	curbs
dabs	7	71	3940	2	da_bs
darb	7	60	3353	2	darb_
dares	6	61	4670	2	dares
darks	10	67	2787	2	darks
darns	6	69	2789	2	darns
darts	6	76	3573	2	darts
daubs	8	50	1456	2	daubs
drabs	8	51	1967	2	drabs
earls	5	61	2751	2	earls
earns	5	59	2756	2	earns
ears	4	63	5659	2	ear_s
fabs	9	86	3586	2	fa_bs
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2496	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
forbs	10	57	2080	2	forbs
gabs	7	67	4042	2	ga_bs
gambs	10	57	2112	2	gambs
garb	7	53	3267	2	garb_
gars	5	57	5074	2	gar_s
grabs	8	57	1969	2	grabs
hards	9	64	3565	2	hards
hares	8	62	5554	2	hares
harks	12	63	3343	2	harks
harls	8	56	3450	2	harls
harms	10	68	2902	2	harms
harps	10	59	2687	2	harps
harts	8	84	4159	2	harts
herbs	10	55	2050	2	herbs
iambs	9	58	1506	2	iambs
jabs	13	58	3009	2	ja_bs
jambs	16	60	1462	2	jambs
jarls	12	61	2096	2	jarls
jars	11	73	3835	2	jar_s
kabs	10	71	3085	2	ka_bs
karns	9	66	2415	2	karns
karts	9	76	3012	2	karts
kbars	11	46	1260	2	kbar_s
kerbs	11	50	1367	2	kerbs
labs	6	71	4512	2	la_bs
lambs	9	59	2141	2	lambs
lards	6	53	3186	2	lards
lares	5	48	5263	2	lares
laris	5	47	3746	2	laris
larks	9	52	2781	2	larks
lars	4	69	5657	2	lar_s
maras	7	54	4330	2	maras
marcs	9	57	2662	2	marcs
mares	7	64	5763	2	mares
marks	11	59	3348	2	marks
marls	7	55	3516	2	marls
mars	6	62	6187	2	mar_s
marts	7	74	4223	2	marts
nabs	6	62	3619	2	na_bs
narcs	7	61	2202	2	narcs
nards	6	59	2846	2	nards
nares	5	55	4415	2	nares
naris	5	57	3529	2	naris
narks	9	60	2603	2	narks
oars	4	68	4603	2	oar_s
orbs	6	66	2625	2	_orbs
paras	7	61	4305	2	paras
pards	8	56	3433	2	pards
pares	7	71	6448	2	pares
paris	7	51	4594	2	paris
parks	11	61	3446	2	parks
parrs	7	59	2867	2	parrs
pars	6	75	6079	2	par_s
parts	7	77	4337	2	parts
rares	5	52	4744	2	rares
sabs	6	66	4374	2	sa_bs
sards	6	47	3618	2	sards
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
sorbs	7	50	2210	2	sorbs
tabs	6	68	4298	2	ta_bs
tares	5	74	5656	2	tares
tarns	5	64	3395	2	tarns
taros	5	56	4082	2	taros
tarps	7	65	2712	2	tarps
tars	4	67	6395	2	tar_s
tarts	5	72	4202	2	tarts
urbs	6	59	2206	2	_urbs
varas	8	60	2820	2	varas
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
verbs	10	46	1439	2	verbs
wabs	9	73	3723	2	wa_bs
wards	9	77	3440	2	wards
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2686	2	warms
warns	8	72	3100	2	warns
warps	10	71	2642	2	warps
wars	7	86	5980	2	war_s
warts	8	148	4040	2	warts
yards	9	53	2461	2	yards
yarns	8	56	2179	2	yarns
zarfs	17	47	1362	2	zarfs

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	53800	0.326	548131.9
2	DLD Change Limit	53800	284	1.750	30742.9
3	Display Results	284	284	0.110	2581.8
	(SQL Overall)	178691	284	2.186	81743.4