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

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

355 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
carns	7	59	3756	(None)
barns	7	63	3514	1	barns
cains	7	53	3430	1	cains
cairns	8	53	1330	1	cairns
cans	6	50	5084	1	ca_ns
carbs	9	60	3146	1	carbs
cards	8	51	3793	1	cards
cares	7	73	6918	1	cares
carks	11	55	3421	1	carks
carls	7	70	3742	1	carls
carn	6	62	4543	1	carn_
carny	10	58	2292	1	carny
carps	9	69	3225	1	carps
carrs	7	57	3085	1	carrs
cars	6	73	6476	1	car_s
carts	7	89	4629	1	carts
corns	7	60	3476	1	corns
curns	7	49	2427	1	curns
darns	6	69	2789	1	darns
earns	5	59	2756	1	earns
karns	9	66	2414	1	karns
tarns	5	64	3395	1	tarns
warns	8	72	3100	1	warns
yarns	8	56	2179	1	yarns
acarus	8	3	1219	2	acarus
acorns	8	50	1301	2	acorns
acres	7	63	2776	2	acres
ains	4	61	5888	2	_ains
airns	5	55	2103	2	airns
arbs	6	68	3473	2	_arbs
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	3749	2	_arms
ars	3	76	7093	2	_ar_s
arts	4	96	5026	2	_arts
awns	7	53	2443	2	_awns
bairns	8	67	1087	2	bairns
banns	7	53	2123	2	banns
bans	6	65	5513	2	ba_ns
barbs	9	59	2819	2	barbs
bards	8	71	3964	2	bards
bares	7	54	5713	2	bares
barfs	10	48	2600	2	barfs
barks	11	57	3581	2	barks
barms	9	61	2846	2	barms
barn	6	64	4464	2	barn_
barny	10	58	2173	2	barny
barons	8	50	2538	2	barons
bars	6	65	6409	2	bar_s
brans	7	54	3743	2	brans
burns	7	49	2677	2	burns
cabins	10	44	1892	2	cabins
cabs	8	67	3942	2	ca_bs
cacas	9	56	2798	2	cacas
cades	8	54	4073	2	cades
cadis	8	44	2849	2	cadis
cadres	9	40	1792	2	cadres
cads	7	61	4452	2	ca_ds
cafes	10	64	2692	2	cafes
caffs	13	54	1737	2	caffs
cages	8	59	3601	2	cages
caids	8	52	2642	2	caids
cain	6	56	4391	2	cain_
cairds	9	64	1151	2	cairds
cairn	7	57	1751	2	cairn_
cairny	11	55	782	2	cairny
cakes	11	60	3767	2	cakes
calfs	10	49	1938	2	calfs
calks	11	54	2160	2	calks
calls	7	56	3473	2	calls
calms	9	52	2235	2	calms
calos	7	44	3190	2	calos
camas	9	63	3352	2	camas
cames	9	70	4731	2	cames
camos	9	59	2761	2	camos
camps	11	63	3026	2	camps
cams	8	70	4728	2	ca_ms
can	5	77	6013	2	ca_n_
cane	6	66	5311	2	ca_ne
canes	7	53	5037	2	canes
canna	7	59	1933	2	canna
cannas	8	45	1840	2	cannas
canny	10	58	1769	2	canny
canons	8	55	2206	2	canons
canso	7	50	1940	2	ca_nso
canst	7	49	3221	2	ca_nst
cant	6	63	6202	2	ca_nt
cants	7	70	3694	2	cants
capes	9	54	4192	2	capes
caphs	12	45	1537	2	caphs
capons	10	41	1950	2	capons
capos	9	48	2607	2	capos
capris	10	4	1507	2	capris
caps	8	71	4789	2	ca_ps
car	5	91	6556	2	car__
carat	7	50	4879	2	carat
carats	8	59	2902	2	carats
carb	8	51	4316	2	car_b
carbo	9	49	2384	2	carbo
carbons	11	54	1894	2	carbons
carbos	10	51	2226	2	carbos
card	7	102	4587	2	car_d
cardons	10	45	1993	2	cardons
care	6	69	6837	2	car_e
cared	8	60	5009	2	cared
careens	9	45	1470	2	careens
carer	7	49	4233	2	carer
carers	8	51	3395	2	carers
caress	8	57	2026	2	caress
caret	7	53	6056	2	caret
carets	8	53	3077	2	carets
carex	14	48	2229	2	carex
cargo	8	53	2207	2	cargo
cargos	9	46	1918	2	cargos
caries	8	51	4762	2	caries
carina	8	43	2532	2	carina
carinas	9	36	2238	2	carinas
caring	9	51	3799	2	caring
cark	10	55	3927	2	car_k
carl	6	51	4478	2	car_l
carle	7	45	3570	2	carle
carles	8	54	3508	2	carles
carlins	9	39	2191	2	carlins
carnal	8	39	1920	2	carnal
carnet	8	47	3287	2	carnet
carnets	9	39	1840	2	carnets
carney	11	53	1570	2	carney
carneys	12	43	1054	2	carneys
carnie	8	44	2109	2	carnie
carnies	9	41	2396	2	carnies
carob	9	53	2522	2	carob
carobs	10	48	1810	2	carobs
carol	7	51	2861	2	carol
carols	8	51	2498	2	carols
carom	9	50	2556	2	carom
caroms	10	56	1957	2	caroms
carp	8	51	3981	2	car_p
carpi	9	43	1939	2	carpi
carpus	10	55	1430	2	carpus
carr	6	54	3470	2	car_r
carry	10	58	2378	2	carry
carse	7	49	3433	2	carse
carses	8	52	3365	2	carses
cart	6	65	7034	2	car_t
carte	7	59	4042	2	carte
cartes	8	62	3947	2	cartes
cartons	9	41	2247	2	cartons
carve	10	62	2775	2	carve
carves	11	51	2845	2	carves
casas	7	53	2784	2	casas
caserns	9	47	1121	2	caserns
cases	7	50	4838	2	cases
casks	11	57	2006	2	casks
casts	7	72	3779	2	casts
casus	7	64	1925	2	casus
cates	7	59	5187	2	cates
cats	6	63	5634	2	ca_ts
cauls	7	57	2777	2	cauls
caverns	12	45	1024	2	caverns
caves	10	56	3970	2	caves
caws	9	60	3610	2	ca_ws
cays	9	54	3767	2	ca_ys
ceres	7	55	4001	2	ceres
ceros	7	47	2607	2	ceros
chains	11	48	1970	2	chains
charas	11	42	2359	2	charas
chards	12	51	1972	2	chards
chares	11	56	3180	2	chares
charks	15	52	1970	2	charks
charms	13	52	1883	2	charms
charrs	11	52	1918	2	charrs
chars	10	59	3663	2	char_s
charts	11	58	2309	2	charts
chins	10	56	3146	2	chins
churns	11	49	1023	2	churns
cions	7	52	2285	2	cions
cires	7	49	3291	2	cires
clans	7	50	3101	2	clans
claros	8	40	1511	2	claros
clons	7	52	2813	2	clons
coins	7	58	3455	2	coins
conns	7	50	2423	2	conns
cons	6	60	5769	2	c_ons
coons	7	67	3728	2	coons
cords	8	60	3062	2	cords
cores	7	63	6185	2	cores
corks	11	60	2827	2	corks
corms	9	56	2622	2	corms
corn	6	99	4581	2	corn_
cornu	7	59	2132	2	cornu
cornus	8	48	1656	2	cornus
corny	10	60	2327	2	corny
corps	9	59	2704	2	corps
cors	6	66	5644	2	cor_s
crabs	9	54	2139	2	crabs
crags	8	56	2257	2	crags
crams	9	62	2915	2	crams
crane	7	53	3160	2	crane
cranes	8	43	3075	2	cranes
crank	11	48	1961	2	crank
cranks	12	50	1531	2	cranks
craps	9	53	2864	2	craps
crass	7	63	2804	2	crass
craws	10	57	2312	2	craws
cris	6	62	3343	2	c_ris
crus	6	58	2848	2	c_rus
curbs	9	48	2165	2	curbs
curds	8	57	2561	2	curds
cures	7	56	4543	2	cures
curfs	10	51	2214	2	curfs
curls	7	49	2710	2	curls
curn	6	67	3188	2	curn_
currs	7	56	2439	2	currs
curs	6	56	4554	2	cur_s
cyans	10	57	1481	2	cyans
czars	16	48	1291	2	czar_s
damns	8	49	1692	2	damns
dans	5	67	4814	2	da_ns
darbs	8	53	2326	2	darbs
dares	6	61	4670	2	dares
darks	10	67	2787	2	darks
darn	5	64	3462	2	darn_
darts	6	76	3573	2	darts
dawns	9	59	1659	2	dawns
durns	6	48	1986	2	durns
earls	5	61	2751	2	earls
earn	4	67	3755	2	earn_
ears	4	63	5659	2	ear_s
erns	4	54	2822	2	_erns
fans	7	62	4736	2	fa_ns
fards	9	66	2984	2	fards
fares	8	58	5287	2	fares
farls	8	57	3111	2	farls
farms	10	63	2495	2	farms
faros	8	55	3202	2	faros
farts	8	83	3684	2	farts
fauns	8	45	1675	2	fauns
fawns	11	59	1426	2	fawns
ferns	8	52	2008	2	ferns
firns	8	60	1854	2	firns
gains	6	57	2951	2	gains
garbs	8	63	2141	2	garbs
garni	6	3	1570	2	garni
gars	5	57	5074	2	gar_s
girns	6	45	1680	2	girns
grans	6	48	3254	2	grans
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	2901	2	harms
harps	10	59	2686	2	harps
harts	8	84	4159	2	harts
herns	8	48	2558	2	herns
horns	8	61	2533	2	horns
jarls	12	61	2096	2	jarls
jars	11	73	3835	2	jar_s
kains	9	61	2564	2	kains
kaons	9	50	1485	2	kaons
karn	8	61	2941	2	karn_
karts	9	76	3011	2	karts
kerns	9	47	1956	2	kerns
kirns	9	53	1545	2	kirns
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
lawns	8	52	1542	2	lawns
learns	6	55	1374	2	learns
mains	7	56	3510	2	mains
mans	6	63	5453	2	ma_ns
maras	7	54	4328	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	6186	2	mar_s
marts	7	74	4223	2	marts
morns	7	55	2744	2	morns
naans	5	58	1525	2	naans
nans	4	61	3939	2	na_ns
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
pains	7	51	3828	2	pains
pans	6	58	5572	2	pa_ns
paras	7	61	4304	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
pawns	10	88	1813	2	pawns
pirns	7	60	2009	2	pirns
porns	7	55	2734	2	porns
rains	5	51	4023	2	rains
rares	5	52	4744	2	rares
sains	5	56	3997	2	sains
sans	4	51	5335	2	sa_ns
sarans	6	42	2443	2	sarans
sards	6	47	3618	2	sards
sarins	6	39	3262	2	sarins
saris	5	45	4495	2	saris
sarks	9	66	3246	2	sarks
saros	5	52	3806	2	saros
scans	7	46	2510	2	sca_ns
scares	8	50	3300	2	scares
scarfs	11	47	1468	2	scarfs
scarps	10	47	1860	2	scarps
scars	7	54	3353	2	scar_s
scarts	8	53	2149	2	scarts
scorns	8	57	1301	2	scorns
sharns	9	55	1698	2	sharns
sorns	5	50	2841	2	sorns
tains	5	49	3632	2	tains
tans	4	61	5481	2	ta_ns
tares	5	74	5656	2	tares
tarn	4	68	4272	2	tarn_
taros	5	56	4082	2	taros
tarps	7	65	2711	2	tarps
tars	4	67	6395	2	tar_s
tarts	5	72	4202	2	tarts
terns	5	52	2687	2	terns
trans	5	49	3304	2	trans
turns	5	56	2323	2	turns
urns	4	63	2389	2	_urns
vans	7	62	3672	2	va_ns
varas	8	60	2819	2	varas
varna	8	45	1617	2	varna
varnas	9	42	1282	2	varnas
vars	7	57	4207	2	var_s
varus	8	59	2118	2	varus
wains	8	69	3086	2	wains
wans	7	64	5226	2	wa_ns
wards	9	77	3440	2	wards
wares	8	82	5058	2	wares
warks	12	79	3240	2	warks
warms	10	77	2685	2	warms
warn	7	52	3932	2	warn_
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
yarn	7	52	3004	2	yarn_
yawns	11	42	1327	2	yawns
yearns	9	50	954	2	yearns
zarfs	17	47	1362	2	zarfs

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	53800	0.093	1921408.6
2	DLD Change Limit	53800	355	1.623	33148.5
3	Display Results	355	355	0.093	3817.2
	(SQL Overall)	178691	355	1.809	98778.9