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

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

271 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
darns	6	69	2789	(None)
barns	7	63	3514	1	barns
carns	7	59	3756	1	carns
damns	8	49	1692	1	damns
dans	5	67	4814	1	da_ns
darbs	8	53	2326	1	darbs
dares	6	61	4670	1	dares
darks	10	67	2787	1	darks
darn	5	64	3462	1	darn_
darts	6	76	3573	1	darts
dawns	9	59	1659	1	dawns
durns	6	48	1986	1	durns
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
adorns	7	42	1261	2	adorns
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
cains	7	53	3430	2	cains
cairns	8	53	1330	2	cairns
cans	6	50	5084	2	ca_ns
carbs	9	60	3146	2	carbs
cards	8	51	3793	2	cards
cares	7	73	6918	2	cares
carks	11	55	3421	2	carks
carls	7	70	3742	2	carls
carn	6	62	4543	2	carn_
carny	10	58	2292	2	carny
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
corns	7	60	3476	2	corns
curns	7	49	2427	2	curns
dabs	7	71	3940	2	da_bs
daces	8	50	3068	2	daces
dacrons	10	32	1103	2	dacrons
dadas	7	58	1986	2	dadas
dados	7	55	2243	2	dados
dads	6	74	4277	2	da_ds
daffs	12	51	1642	2	daffs
dagos	7	64	1944	2	dagos
dags	6	66	4259	2	da_gs
dahls	9	50	1228	2	dahls
dahs	8	82	3181	2	da_hs
dais	5	70	4070	2	da_is
daks	9	71	3060	2	da_ks
dales	6	64	3974	2	dales
dals	5	71	4512	2	da_ls
damans	9	47	1598	2	damans
dames	8	54	3585	2	dames
damn	7	57	2432	2	damn_
damps	10	52	2041	2	damps
dams	7	74	4437	2	da_ms
dan	4	68	5966	2	da_n_
dang	6	51	3153	2	da_ng
dangs	7	56	2320	2	dangs
dank	9	58	2823	2	da_nk
daps	7	72	3916	2	da_ps
darb	7	60	3353	2	dar_b
dare	5	58	4886	2	dar_e
dared	7	59	3501	2	dared
darer	6	52	3079	2	darer
darers	7	59	2187	2	darers
daric	8	56	2311	2	daric
darics	9	43	1411	2	darics
daring	8	49	2868	2	daring
darings	9	37	1364	2	darings
dark	9	51	3321	2	dar_k
darkens	12	40	987	2	darkens
darky	13	60	1883	2	darky
darned	8	50	1848	2	darned
darnel	7	43	1218	2	darnel
darnels	8	37	1043	2	darnels
darner	7	40	1730	2	darner
darners	8	38	1577	2	darners
dart	5	58	5787	2	dar_t
dates	6	56	3915	2	dates
datos	6	52	2278	2	datos
daubs	8	50	1456	2	daubs
daunt	6	59	2908	2	daunt
daunts	7	50	1408	2	daunts
dauts	6	78	2224	2	dauts
davens	10	46	1291	2	davens
dawks	13	52	1349	2	dawks
dawn	8	56	2420	2	dawn_
daws	8	66	3824	2	da_ws
dawts	9	72	1612	2	dawts
days	8	76	3713	2	da_ys
dazes	15	50	2414	2	dazes
deans	6	61	3139	2	deans
dears	6	57	3688	2	dear_s
dens	5	59	4507	2	d_ens
derms	8	50	2289	2	derms
dharna	10	5	526	2	dharna
dharnas	11	5	537	2	dharnas
dins	5	66	5204	2	d_ins
dirks	10	56	1952	2	dirks
dirls	6	47	2050	2	dirls
dirts	6	68	2446	2	dirts
djins	13	6	845	2	djins
dons	5	60	4870	2	d_ons
dorks	10	57	2444	2	dorks
dorms	8	57	2383	2	dorms
dorps	8	54	1922	2	dorps
dorrs	6	55	2059	2	dorrs
dors	5	67	4760	2	dor_s
downs	9	49	1857	2	downs
drabs	8	51	1967	2	drabs
drags	7	55	2111	2	drags
drains	7	37	1940	2	drains
drams	8	60	2583	2	drams
drank	10	48	1620	2	drank
drats	6	66	2837	2	drats
draws	9	51	1937	2	draws
drays	9	58	1977	2	drays
drys	8	63	1480	2	d_rys
duns	5	51	4043	2	d_uns
duras	6	57	2772	2	duras
dures	6	56	3592	2	dures
durn	5	61	2762	2	durn_
duros	6	54	2269	2	duros
durrs	6	55	1999	2	durrs
dwarfs	13	43	627	2	dwarfs
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
sharns	9	55	1698	2	sharns
sorns	5	50	2842	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 6 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.250	714764.0
2	DLD Change Limit	53800	271	4.466	12046.6
3	Display Results	271	271	0.220	1231.8
	(SQL Overall)	178691	271	4.936	36201.6