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

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

286 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
ewe	6	66	3098	(None)
awe	6	77	4662	1	awe
eke	7	56	3009	1	eke
eme	5	58	3718	1	eme
ere	3	63	5277	1	ere
eve	6	63	3116	1	eve
ewer	7	75	2398	1	ewer
ewes	7	63	2870	1	ewes
eye	6	55	3977	1	eye
owe	6	70	4103	1	owe
we	5	70	4345	1	_we
wee	6	67	6081	1	wee
ace	5	96	5683	2	ace
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
ale	3	65	7234	2	ale
ane	3	78	6694	2	ane
ape	5	72	5118	2	ape
are	3	78	7457	2	are
ate	3	70	5924	2	ate
ave	6	77	4870	2	ave
aw	5	125	6340	2	aw_
awa	6	119	3967	2	awa
awed	8	84	3603	2	awed
awee	7	63	3664	2	awee
awes	7	60	3755	2	awes
awl	6	76	3530	2	awl
awn	6	80	3591	2	awn
axe	10	82	3949	2	axe
aye	6	71	5176	2	aye
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bene	6	64	3949	2	bene
bye	8	61	3459	2	bye
cede	7	49	2876	2	cede
cee	5	59	5270	2	cee
cepe	8	49	2665	2	cepe
cere	6	67	4147	2	cere
cete	6	49	3478	2	cete
cue	5	75	4418	2	cue
cwm	10	68	1508	2	cwm
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
deke	9	52	2876	2	deke
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
dene	5	66	4341	2	dene
dere	5	68	4590	2	dere
dew	7	71	3992	2	dew_
dewed	10	50	2030	2	dewed
dews	8	62	3060	2	dews
dewy	11	54	1902	2	dewy
die	4	67	5965	2	die
doe	4	73	6195	2	doe
due	4	52	4986	2	due
dye	7	53	3484	2	dye
ear	3	68	6788	2	ear
ease	4	50	4233	2	ease
eat	3	69	8905	2	eat
eau	3	74	5094	2	eau
eave	7	57	3358	2	eave
ebb	7	24	1862	2	ebb
eche	9	75	2028	2	eche
ecu	5	68	2823	2	ecu
ed	3	86	4518	2	e_d
edge	6	57	1966	2	edge
edh	7	69	2156	2	edh
eds	4	66	3892	2	eds
eek	7	79	3510	2	eek
eel	3	79	4684	2	eel
ef	5	73	4536	2	e_f
eff	9	61	2862	2	eff
efs	6	68	2960	2	efs
eft	6	60	3882	2	eft
eger	5	59	2356	2	eger
egg	5	69	1867	2	egg
ego	4	67	2605	2	ego
eh	5	83	3996	2	e_h
eide	5	58	3223	2	eide
eked	9	67	1802	2	eked
ekes	8	67	2660	2	ekes
el	2	67	4529	2	e_l
eld	4	67	3379	2	eld
elf	6	61	3852	2	elf
elk	7	67	2612	2	elk
ell	3	67	3568	2	ell
elm	5	75	3174	2	elm
els	3	76	4572	2	els
else	4	59	2308	2	else
em	4	94	4515	2	e_m
emes	6	54	3466	2	emes
emeu	6	67	2343	2	emeu
ems	5	64	3549	2	ems
emu	5	59	2998	2	emu
en	2	80	5239	2	e_n
end	4	68	3435	2	end
eng	4	67	2678	2	eng
ens	3	72	4592	2	ens
eon	3	60	5208	2	eon
epee	6	46	2850	2	epee
er	2	83	4514	2	e_r
era	3	57	4150	2	era
erg	4	55	3107	2	erg
ern	3	57	3835	2	ern
erne	4	67	2742	2	erne
err	3	56	2653	2	err
ers	3	60	4628	2	ers
es	2	90	4822	2	e_s
eses	4	53	3610	2	eses
esne	4	70	1879	2	esne
ess	3	60	3088	2	ess
et	2	69	6419	2	e_t
eta	3	58	3419	2	eta
eth	6	66	3098	2	eth
etwee	8	41	1533	2	etwee
even	7	52	2227	2	even
ever	7	70	2769	2	ever
eves	7	62	3046	2	eves
ewers	8	60	1882	2	ewers
ex	9	88	3564	2	e_x
exec	13	53	1394	2	exec
exed	12	54	2059	2	exed
exes	11	65	3081	2	exes
eyed	8	66	2323	2	eyed
eyen	7	62	2366	2	eyen
eyer	7	61	2728	2	eyer
eyes	7	58	3788	2	eyes
eyne	7	63	2246	2	eyne
eyre	7	55	2525	2	eyre
fe	5	79	4474	2	_fe
fee	6	68	6201	2	fee
feme	9	61	3054	2	feme
fere	7	63	4223	2	fere
fete	7	57	3492	2	fete
few	9	54	3696	2	few_
fewer	11	52	1612	2	fewer
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
gae	4	64	5770	2	gae
gee	4	53	5920	2	gee
gene	5	62	3722	2	gene
gie	4	71	4954	2	gie
hae	6	73	6400	2	hae
he	5	81	5195	2	_he
hebe	9	64	2470	2	hebe
heme	9	50	3441	2	heme
here	7	64	4710	2	here
hew	9	76	4272	2	hew_
hewed	12	56	1943	2	hewed
hewer	11	57	1993	2	hewer
hewn	10	67	1985	2	hewn
hews	10	56	3157	2	hews
hie	6	76	5270	2	hie
hoe	6	75	6272	2	hoe
howe	10	67	3410	2	howe
hue	6	66	4230	2	hue
ice	5	67	3724	2	ice
ire	3	69	4317	2	ire
jee	10	66	4864	2	jee
jefe	14	65	1688	2	jefe
jete	11	59	2725	2	jete
jew	13	51	2908	2	jew_
jewed	16	51	1483	2	jewed
jewel	15	67	1170	2	jewel
jews	14	58	2208	2	jews
joe	10	66	4235	2	joe
kae	7	67	4454	2	kae
krewe	12	3	819	2	krewe
kue	7	66	3186	2	kue
kye	10	73	2727	2	kye
lee	3	60	6814	2	lee
leke	8	55	2740	2	leke
lewd	8	57	1659	2	lewd
lie	3	82	6452	2	lie
lowe	7	54	3531	2	lowe
lwei	7	53	1264	2	lwei
lye	6	65	3341	2	lye
mae	5	76	5910	2	mae
me	4	77	4833	2	_me
meme	8	53	3055	2	meme
mere	6	72	4444	2	mere
mete	6	44	3813	2	mete
mew	8	61	3773	2	mew_
mewed	11	52	1801	2	mewed
mewl	9	56	1832	2	mewl
mews	9	66	2933	2	mews
meze	15	44	2090	2	meze
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
nene	4	59	3206	2	nene
neve	7	62	2483	2	neve
new	6	62	3709	2	new_
newel	8	61	1413	2	newel
newer	8	57	1746	2	newer
newie	8	18	1348	2	newie
news	7	61	2737	2	news
newt	7	69	3374	2	newt
obe	5	66	3864	2	obe
ode	4	74	4658	2	ode
oe	2	84	7306	2	_oe
oke	7	58	3948	2	oke
ole	3	71	5521	2	ole
one	3	70	5091	2	one
ope	5	68	4524	2	ope
ore	3	66	6183	2	ore
ose	3	81	4734	2	ose
ow	5	89	5017	2	ow_
owed	8	68	3387	2	owed
owes	7	51	3710	2	owes
owl	6	62	2897	2	owl
own	6	64	2970	2	own
owse	7	63	2162	2	owse
pe	4	76	4903	2	_pe
pee	5	60	6651	2	pee
peke	10	59	2620	2	peke
pele	6	55	3955	2	pele
pere	6	64	5026	2	pere
pew	8	64	4230	2	pew_
pewee	10	3	1997	2	pewee
pews	9	57	3153	2	pews
pie	5	54	5740	2	pie
pye	8	64	3250	2	pye
re	2	61	5374	2	_re
rede	5	50	3766	2	rede
ree	3	79	7407	2	ree
rete	4	49	4413	2	rete
rewed	9	54	2545	2	rewed
rewet	8	51	3515	2	rewet
roe	3	68	6107	2	roe
rue	3	55	4926	2	rue
rye	6	60	3254	2	rye
sae	3	83	6518	2	sae
see	3	57	7226	2	see
seme	6	58	3665	2	seme
sene	4	68	4805	2	sene
sere	4	61	5347	2	sere
sew	6	62	4726	2	sew_
sewed	9	53	2516	2	sewed
sewer	8	44	2621	2	sewer
sewn	7	61	2433	2	sewn
sews	7	58	3602	2	sews
she	6	68	3769	2	she
sue	3	56	5146	2	sue
tae	3	82	6705	2	tae
tee	3	83	6687	2	tee
tele	4	50	4087	2	tele
tew	6	66	4015	2	tew_
tewed	9	47	1853	2	tewed
tews	7	64	3164	2	tews
the	6	74	3605	2	the
tie	3	65	5753	2	tie
toe	3	101	6685	2	toe
twa	6	77	2164	2	twa
twae	7	47	1957	2	twae
twee	7	68	2708	2	twee
two	6	79	2583	2	two
tye	6	58	3744	2	tye
uke	7	57	2729	2	uke
use	3	68	3516	2	use
ute	3	53	3588	2	ute
vee	6	57	5018	2	vee
vie	6	54	4763	2	vie
voe	6	77	3905	2	voe
wae	6	75	5695	2	wae
web	8	57	3556	2	web
wed	7	58	4362	2	wed
weed	8	56	3751	2	weed
week	11	64	2815	2	week
weel	7	58	3408	2	weel
ween	7	58	3546	2	ween
weep	9	51	3165	2	weep
weer	7	55	3509	2	weer
wees	7	62	4912	2	wees
weet	7	52	5415	2	weet
wen	6	62	4960	2	wen
were	7	62	3833	2	were
wet	6	59	6662	2	wet
wo	5	104	4776	2	_wo
woe	6	66	5124	2	woe
wye	9	63	3197	2	wye
ye	5	76	5006	2	_ye
yew	9	64	3629	2	yew_
yews	10	53	2396	2	yews
yowe	10	67	2874	2	yowe
zee	12	61	4323	2	zee

Search took 1 second 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	14084	0.063	2836365.1
2	DLD Change Limit	14084	286	0.360	39122.2
3	Display Results	286	286	0.063	4539.7
	(SQL Overall)	178691	286	0.486	367677.0