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

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

254 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
weans	8	53	2674	(None)
beans	7	57	3469	1	beans
deans	6	61	3139	1	deans
jeans	12	60	2211	1	jeans
leans	5	55	3625	1	leans
means	7	58	3123	1	means
peans	7	54	3764	1	peans
wans	7	64	5227	1	w_ans
weals	8	54	2874	1	weals
wean	7	57	3435	1	wean_
wears	8	60	3030	1	wears
weens	8	52	2405	1	weens
wens	7	63	3793	1	we_ns
yeans	8	66	2488	1	yeans
aeons	5	76	2465	2	aeons
alans	5	56	3617	2	alans
azans	14	65	1688	2	azans
bans	6	65	5514	2	_bans
beads	8	54	2950	2	beads
beaks	11	53	2662	2	beaks
beams	9	53	2817	2	beams
bean	6	64	4386	2	bean_
beano	7	54	2155	2	beano
beanos	8	55	1651	2	beanos
bears	7	57	3904	2	bears
beats	7	60	4224	2	beats
beaus	7	51	2711	2	beaus
bens	6	59	4570	2	be_ns
brans	7	54	3743	2	brans
cans	6	50	5085	2	_cans
clans	7	50	3101	2	clans
cleans	8	58	1705	2	cleans
cyans	10	57	1481	2	cyans
dans	5	67	4815	2	_dans
deads	7	57	2691	2	deads
deals	6	54	3534	2	deals
dean	5	60	3948	2	dean_
dears	6	57	3688	2	dears
dedans	8	59	1507	2	dedans
dens	5	59	4507	2	de_ns
dewans	10	52	1514	2	dewans
earns	5	59	2756	2	_earns
ears	4	63	5659	2	_ears
eats	4	70	5487	2	_eats
elans	5	55	2775	2	elans
ens	3	72	4592	2	_e_ns
eons	4	66	3871	2	_eons
erns	4	54	2823	2	_erns
fans	7	62	4737	2	_fans
fears	8	48	2939	2	fears
feats	8	64	3275	2	feats
fens	7	61	3976	2	fe_ns
ferns	8	52	2008	2	ferns
flans	8	53	2797	2	flans
gears	6	46	2869	2	gears
gens	5	57	4007	2	ge_ns
glans	6	51	2583	2	glans
gleans	7	50	1474	2	gleans
grans	6	48	3254	2	grans
guans	6	44	1944	2	guans
heads	9	51	2711	2	heads
heals	8	57	3345	2	heals
heaps	10	52	2322	2	heaps
hears	8	67	3737	2	hears
heats	8	58	3840	2	heats
hens	7	56	4257	2	he_ns
herns	8	48	2558	2	herns
jean	11	66	2928	2	jean_
keas	8	63	3709	2	kea_s
keens	9	57	2118	2	keens
kens	8	54	3523	2	ke_ns
kerns	9	47	1956	2	kerns
khans	12	46	1517	2	khans
koans	9	58	1862	2	koans
leads	6	60	2849	2	leads
leafs	8	57	2118	2	leafs
leaks	9	59	2391	2	leaks
lean	4	63	4524	2	lean_
leant	5	67	3778	2	leant
leaps	7	55	2293	2	leaps
learns	6	55	1374	2	learns
lears	5	59	3873	2	lears
leas	4	59	5418	2	lea_s
lemans	8	53	1639	2	lemans
lens	4	61	4649	2	le_ns
loans	5	60	2646	2	loans
mans	6	63	5455	2	_mans
meads	8	54	2532	2	meads
meals	7	59	3337	2	meals
mean	6	55	3809	2	mean_
meant	7	65	3721	2	meant
meany	10	46	2048	2	meany
meats	7	50	3405	2	meats
moans	7	46	2437	2	moans
naans	5	58	1525	2	naans
nans	4	61	3940	2	_nans
neaps	7	56	1832	2	neaps
nears	5	55	2942	2	nears
neats	5	59	3190	2	neats
neons	5	58	1868	2	neons
oceans	8	12	1100	2	oceans
paeans	8	51	1826	2	paeans
pans	6	58	5573	2	_pans
peags	8	61	2284	2	peags
peaks	11	48	2562	2	peaks
peals	7	52	3549	2	peals
pean	6	61	4717	2	pean_
pears	7	51	3861	2	pears
peas	6	57	5506	2	pea_s
peats	7	61	4019	2	peats
pecans	10	15	1583	2	pecans
peens	7	64	2819	2	peens
peins	7	61	2806	2	peins
pekans	12	17	1055	2	pekans
pens	6	56	4964	2	pe_ns
peons	7	53	2718	2	peons
pians	7	51	2696	2	pians
plans	7	57	3127	2	plans
queans	15	31	1075	2	queans
reads	6	48	3527	2	reads
reals	5	50	3865	2	reals
reams	7	57	2962	2	reams
reaps	7	56	2619	2	reaps
rears	5	47	3965	2	rears
redans	7	54	2102	2	redans
reins	5	62	3456	2	reins
remans	8	48	2300	2	remans
roans	5	49	2644	2	roans
sans	4	51	5336	2	_sans
scans	7	46	2510	2	scans
seals	5	48	3969	2	seals
seams	7	57	3166	2	seams
sears	5	47	4491	2	sears
seas	4	57	5527	2	sea_s
seats	5	48	4434	2	seats
sedans	7	48	1609	2	sedans
sewans	9	52	1590	2	sewans
skeans	10	45	1291	2	skeans
spans	7	45	2873	2	spans
speans	8	54	1714	2	speans
swans	8	46	2501	2	swans
swears	9	41	1407	2	swears
sweats	9	48	1461	2	sweats
tans	4	61	5482	2	_tans
teaks	9	42	2290	2	teaks
teals	5	62	3413	2	teals
teams	7	57	2651	2	teams
tears	5	54	3646	2	tears
teas	4	58	5149	2	tea_s
teats	5	56	3681	2	teats
teens	5	62	2748	2	teens
tens	4	56	4741	2	te_ns
terns	5	52	2687	2	terns
trans	5	49	3304	2	trans
tweaks	13	3	596	2	tweaks
tweens	9	48	984	2	tweens
ulans	5	49	2130	2	ulans
vans	7	62	3673	2	_vans
veals	8	49	2619	2	veals
vegans	10	39	1085	2	vegans
veins	8	46	2049	2	veins
wabs	9	73	3723	2	w_abs
wads	8	73	4314	2	w_ads
waes	7	60	4860	2	w_aes
wags	8	61	4055	2	w_ags
wains	8	69	3087	2	wains
wan	6	67	6194	2	w_an_
wand	8	58	3388	2	w_and
wands	9	64	2548	2	w_ands
wane	7	63	4472	2	w_ane
wanes	8	50	4088	2	w_anes
wank	11	56	3251	2	w_ank
wanks	12	61	2448	2	w_anks
want	7	61	5617	2	w_ant
wants	8	79	3221	2	w_ants
wany	10	64	3236	2	w_any
waps	9	66	4208	2	w_aps
warns	8	72	3100	2	warns
wars	7	86	5980	2	w_ars
was	6	87	6756	2	w_a_s
wats	7	75	5588	2	w_ats
waws	10	68	3490	2	w_aws
ways	10	77	3795	2	w_ays
weak	11	71	2630	2	wea_k
weakens	14	36	706	2	weakens
weakons	14	28	780	2	weakons
weal	7	58	3868	2	wea_l
weald	9	56	1502	2	weald
wealds	10	45	910	2	wealds
weaned	10	38	1615	2	weaned
weaner	9	38	1677	2	weaner
weaners	10	46	1383	2	weaners
weapons	12	27	860	2	weapons
wear	7	58	3672	2	wea_r
weary	11	56	2061	2	weary
weasons	10	23	1058	2	weasons
weave	11	52	1853	2	weave
weaves	12	36	1637	2	weaves
webs	9	66	2212	2	we_bs
weds	8	66	2893	2	we_ds
weeds	9	52	2221	2	weeds
weeks	12	50	1786	2	weeks
ween	7	58	3546	2	ween_
weensy	12	41	682	2	weensy
weeny	11	53	1616	2	weeny
weeps	10	41	2056	2	weeps
wees	7	62	4912	2	we_es
weets	8	54	2772	2	weets
wefts	11	67	1549	2	wefts
weirs	8	43	1649	2	weirs
wekas	12	39	1179	2	wekas
welds	9	47	1916	2	welds
wells	8	54	2619	2	wells
welts	8	52	2519	2	welts
wen	6	62	4960	2	we_n_
wend	8	53	3045	2	we_nd
wends	9	58	2281	2	wends
wenny	11	44	1246	2	wenny
went	7	60	5187	2	we_nt
wests	8	57	2700	2	wests
wets	7	59	4029	2	we_ts
whams	13	55	1564	2	whams
whang	12	48	1338	2	whang
whangs	13	43	972	2	whangs
whaps	13	51	1516	2	whaps
whats	11	77	1899	2	whats
wheals	12	45	1252	2	wheals
wheats	12	50	1322	2	wheats
wheens	12	46	1061	2	wheens
whenas	12	46	1046	2	whenas
whens	11	46	1876	2	whens
whins	11	49	2233	2	whins
wigans	10	45	1170	2	wigans
wins	7	59	4917	2	w_ins
witans	9	34	1293	2	witans
woads	9	48	1844	2	woads
womans	11	46	1365	2	womans
wons	7	49	4204	2	w_ons
wrang	9	47	1611	2	wrang
wrangs	10	46	1191	2	wrangs
wraps	10	56	1715	2	wraps
wreaks	13	47	1111	2	wreaks
wrens	8	50	1624	2	wrens
wynns	11	51	747	2	wynns
wyns	10	57	1703	2	w_yns
yeahs	11	52	1455	2	yeahs
yean	7	58	3458	2	yean_
yearns	9	50	954	2	yearns
years	8	45	2767	2	years
yeas	7	86	3842	2	yea_s
yens	7	58	3226	2	ye_ns
yuans	8	46	1332	2	yuans
zeals	14	53	2085	2	zeals
zeins	14	47	1539	2	zeins

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.296	603685.8
2	DLD Change Limit	53800	254	1.640	32804.9
3	Display Results	254	254	0.063	4031.7
	(SQL Overall)	178691	254	1.999	89390.2