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

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

272 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
warns	8	72	3100	(None)
barns	7	63	3514	1	barns
carns	7	59	3756	1	carns
darns	6	69	2789	1	darns
earns	5	59	2756	1	earns
karns	9	66	2414	1	karns
tarns	5	64	3395	1	tarns
wains	8	69	3087	1	wains
wans	7	64	5227	1	wa_ns
wards	9	77	3440	1	wards
wares	8	82	5058	1	wares
warks	12	79	3240	1	warks
warms	10	77	2685	1	warms
warn	7	52	3932	1	warn_
warps	10	71	2642	1	warps
wars	7	86	5980	1	war_s
warts	8	148	4040	1	warts
yarns	8	56	2179	1	yarns
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
awards	10	71	1345	2	awards
awns	7	53	2443	2	_awns
bairns	8	67	1087	2	bairns
banns	7	53	2123	2	banns
bans	6	65	5514	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	2678	2	burns
cains	7	53	3430	2	cains
cairns	8	53	1330	2	cairns
cans	6	50	5085	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	2428	2	curns
damns	8	49	1692	2	damns
dans	5	67	4815	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	1987	2	durns
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	2823	2	_erns
fans	7	62	4737	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	2687	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	3511	2	mains
mans	6	63	5455	2	ma_ns
maras	7	54	4329	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
morns	7	55	2744	2	morns
naans	5	58	1525	2	naans
nans	4	61	3940	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	5573	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	5336	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
swains	9	45	1395	2	swains
swans	8	46	2501	2	swa_ns
swards	10	54	1513	2	swards
swarfs	12	56	1206	2	swarfs
swarms	11	61	1217	2	swarms
tains	5	49	3632	2	tains
tans	4	61	5482	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	2324	2	turns
twains	9	58	1118	2	twains
urns	4	63	2390	2	_urns
vans	7	62	3673	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
wabs	9	73	3723	2	wa_bs
wacks	14	66	2628	2	wacks
wades	9	56	3414	2	wades
wadis	9	52	2396	2	wadis
wads	8	73	4314	2	wa_ds
waes	7	60	4860	2	wa_es
waffs	14	63	1547	2	waffs
wafts	11	69	2055	2	wafts
wages	9	53	3093	2	wages
wagons	10	39	1121	2	wagons
wags	8	61	4055	2	wa_gs
waifs	11	57	1987	2	waifs
wails	8	66	3148	2	wails
wain	7	58	4020	2	wain_
wairs	8	64	2406	2	wairs
waits	8	83	3352	2	waits
wakens	13	50	1204	2	wakens
wakes	12	66	3365	2	wakes
wales	8	61	4283	2	wales
walks	12	62	1850	2	walks
walls	8	55	2938	2	walls
walrus	9	5	643	2	walrus
wames	10	64	3280	2	wames
wamus	10	55	1468	2	wamus
wan	6	67	6194	2	wa_n_
wand	8	58	3388	2	wa_nd
wands	9	64	2548	2	wands
wane	7	63	4472	2	wa_ne
wanes	8	50	4088	2	wanes
wank	11	56	3251	2	wa_nk
wanks	12	61	2448	2	wanks
want	7	61	5617	2	wa_nt
wants	8	79	3221	2	wants
wany	10	64	3236	2	wa_ny
waps	9	66	4208	2	wa_ps
war	6	72	6242	2	war__
ward	8	65	4225	2	war_d
wardens	11	37	1190	2	wardens
ware	7	62	5472	2	war_e
wared	9	63	3987	2	wared
waring	10	50	2944	2	waring
wark	11	57	3777	2	war_k
warm	9	59	3567	2	war_m
warned	10	40	1891	2	warned
warner	9	37	1722	2	warner
warners	10	33	1556	2	warners
warp	9	56	3500	2	war_p
warrens	10	38	1089	2	warrens
wart	7	78	6608	2	war_t
warty	11	93	2382	2	warty
wary	10	67	4001	2	war_y
was	6	87	6756	2	wa__s
wasps	10	67	1469	2	wasps
wasts	8	74	3367	2	wasts
wats	7	75	5588	2	wa_ts
watts	8	69	2309	2	watts
wauks	12	55	1516	2	wauks
wauls	8	61	2055	2	wauls
waves	11	56	3392	2	waves
wawls	11	54	1647	2	wawls
waws	10	68	3490	2	wa_ws
waxes	15	58	2550	2	waxes
ways	10	77	3795	2	wa_ys
weans	8	53	2674	2	weans
wears	8	60	3030	2	wear_s
weens	8	52	2405	2	weens
wens	7	63	3793	2	w_ens
wharfs	15	4	637	2	wharfs
whens	11	46	1876	2	whens
whins	11	49	2233	2	whins
wins	7	59	4917	2	w_ins
wires	8	60	3491	2	wires
wons	7	49	4204	2	w_ons
words	9	54	2507	2	words
works	12	56	2190	2	works
worms	10	53	2076	2	worms
worn	7	56	3175	2	worn_
worts	8	86	3118	2	worts
wrang	9	47	1611	2	wrang
wrangs	10	46	1191	2	wrangs
wraps	10	56	1715	2	wraps
wrens	8	50	1624	2	wrens
wynns	11	51	747	2	wynns
wyns	10	57	1703	2	w_yns
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 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.313	570897.8
2	DLD Change Limit	53800	272	1.656	32487.9
3	Display Results	272	272	0.063	4317.5
	(SQL Overall)	178691	272	2.032	87938.5