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

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

300 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
dye	7	53	3484	(None)
aye	6	71	5176	1	aye
bye	8	61	3459	1	bye
de	3	70	4954	1	d_e
dee	4	76	6582	1	dee
dey	7	72	4337	1	dey
die	4	67	5965	1	die
doe	4	73	6195	1	doe
due	4	52	4986	1	due
dyed	9	67	2076	1	dyed
dyer	8	55	2211	1	dyer
dyes	8	53	3189	1	dyes
dyke	12	64	1818	1	dyke
dyne	8	53	2093	1	dyne
eye	6	55	3977	1	eye
kye	10	73	2727	1	kye
lye	6	65	3341	1	lye
pye	8	64	3250	1	pye
rye	6	60	3254	1	rye
tye	6	58	3744	1	tye
wye	9	63	3197	1	wye
ye	5	76	5006	1	_ye
abye	9	79	2100	2	abye
ace	5	96	5683	2	ace
adze	14	128	2057	2	adze
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
awe	6	77	4662	2	awe
axe	10	82	3949	2	axe
ay	5	117	7389	2	ay_
ayes	7	65	4351	2	ayes
ays	6	70	5029	2	ays
be	4	79	4894	2	_be
bee	5	62	6240	2	bee
bey	8	66	4542	2	bey
by	7	75	2923	2	by_
byes	9	52	3053	2	byes
byre	9	50	2385	2	byre
bys	8	52	2946	2	bys
byte	9	65	2181	2	byte
cee	5	59	5270	2	cee
cue	5	75	4418	2	cue
cyme	11	94	2037	2	cyme
dab	6	74	5556	2	dab
dace	7	69	3492	2	dace
dad	5	84	5616	2	dad
dag	5	77	5300	2	dag
dah	7	81	4898	2	dah
dak	8	63	4069	2	dak
dal	4	75	5495	2	dal
dale	5	56	4398	2	dale
dam	6	74	5704	2	dam
dame	7	71	4031	2	dame
dan	4	68	5966	2	dan
dap	6	66	5245	2	dap
dare	5	58	4886	2	dare
date	5	64	4332	2	date
daw	7	71	4836	2	daw
day	7	62	5411	2	day
days	8	76	3713	2	days
daze	14	73	2723	2	daze
deb	6	63	4269	2	deb
debye	11	3	890	2	debye
deed	6	53	4090	2	deed
deem	7	54	3289	2	deem
deep	7	60	3188	2	deep
deer	5	67	3902	2	deer
dees	5	63	5663	2	dees
deet	5	73	5658	2	deet
def	7	65	4672	2	def
deke	9	52	2876	2	deke
del	4	67	5275	2	del
dele	5	68	4308	2	dele
deme	7	65	3628	2	deme
den	4	75	5434	2	den
dene	5	66	4341	2	dene
dere	5	68	4590	2	dere
dev	7	60	3377	2	dev
dew	7	71	3992	2	dew
dex	11	69	3688	2	dex
deys	8	50	2747	2	deys
dib	6	57	4693	2	dib
dice	7	58	4189	2	dice
did	5	68	5051	2	did
died	6	61	3785	2	died
diel	5	90	3460	2	diel
dies	5	56	5352	2	dies
diet	5	73	5753	2	diet
dif	7	68	4689	2	dif
dig	5	75	4447	2	dig
dike	9	59	3576	2	dike
dim	6	81	4649	2	dim
dime	7	62	3764	2	dime
din	4	64	5946	2	din
dine	5	55	5533	2	dine
dip	6	78	4898	2	dip
dire	5	66	4414	2	dire
dis	4	64	5989	2	dis
dit	4	70	7133	2	dit
dite	5	55	4755	2	dite
dive	8	56	3477	2	dive
do	3	101	5525	2	d_o
doc	6	68	4151	2	doc
doer	5	77	3470	2	doer
does	5	65	5447	2	does
dog	5	74	4975	2	dog
doge	6	62	3380	2	doge
dol	4	71	5065	2	dol
dole	5	65	5000	2	dole
dom	6	97	5244	2	dom
dome	7	72	4073	2	dome
don	4	67	5765	2	don
done	5	57	4791	2	done
dope	7	60	3889	2	dope
dor	4	72	5392	2	dor
dore	5	63	5330	2	dore
dos	4	80	6231	2	dos
dose	5	64	4243	2	dose
dot	4	75	7318	2	dot
dote	5	54	4288	2	dote
dove	8	51	3156	2	dove
dow	7	67	4997	2	dow
doyen	9	50	1441	2	doyen
doze	14	58	2908	2	doze
dree	5	66	3832	2	dree
dreg	6	68	2165	2	dreg
drek	9	63	2108	2	drek
drew	8	62	2167	2	drew
dry	7	65	2603	2	dry
dryer	9	51	1146	2	dryer
drys	8	63	1480	2	drys
dub	6	66	4220	2	dub
duce	7	69	3350	2	duce
dud	5	67	3759	2	dud
dude	6	56	2966	2	dude
duel	5	67	2970	2	duel
dues	5	60	4550	2	dues
duet	5	64	4626	2	duet
dug	5	81	3869	2	dug
duh	7	79	3038	2	duh
dui	4	64	3338	2	dui
duke	9	56	2810	2	duke
dun	4	65	4558	2	dun
dune	5	61	3758	2	dune
duo	4	85	3614	2	duo
dup	6	76	3788	2	dup
dupe	7	66	3060	2	dupe
dure	5	63	4181	2	dure
dyad	9	64	1545	2	dyad
dyers	9	66	1713	2	dyers
dyked	14	53	1095	2	dyked
dykes	13	52	1557	2	dykes
dykey	16	60	867	2	dykey
dynel	9	56	985	2	dynel
dynes	9	59	1758	2	dynes
edge	6	57	1966	2	edge
eke	7	56	3009	2	eke
eme	5	58	3718	2	eme
ere	3	63	5277	2	ere
eve	6	63	3116	2	eve
ewe	6	66	3098	2	ewe
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
fey	9	59	4088	2	fey
fie	6	71	5244	2	fie
foe	6	63	5081	2	foe
fyce	12	63	1683	2	fyce
fyke	14	59	1529	2	fyke
gae	4	64	5770	2	gae
gee	4	53	5920	2	gee
gey	7	57	3830	2	gey
gie	4	71	4954	2	gie
gybe	10	59	1624	2	gybe
gym	9	57	1906	2	gym
gyp	9	83	1901	2	gyp
gyre	8	47	2276	2	gyre
gyve	11	62	1508	2	gyve
hae	6	73	6400	2	hae
he	5	81	5195	2	_he
hey	9	67	4106	2	hey
hie	6	76	5270	2	hie
hoe	6	75	6272	2	hoe
hue	6	66	4230	2	hue
hyp	11	78	2246	2	hyp
hype	12	55	1981	2	hype
hyte	10	90	1894	2	hyte
ice	5	67	3724	2	ice
idle	5	54	2376	2	idle
idyl	8	59	1230	2	idyl
ire	3	69	4317	2	ire
jee	10	66	4864	2	jee
joe	10	66	4235	2	joe
kae	7	67	4454	2	kae
key	10	58	3333	2	key
kue	7	66	3186	2	kue
kyes	11	51	2493	2	kyes
kyte	11	70	1776	2	kyte
lee	3	60	6814	2	lee
ley	6	62	4681	2	ley
lie	3	82	6452	2	lie
lyes	7	55	3083	2	lyes
lyre	7	56	2379	2	lyre
lyse	7	63	2059	2	lyse
mae	5	76	5910	2	mae
me	4	77	4833	2	_me
my	7	81	2565	2	my_
myc	10	65	1950	2	myc
nae	3	59	5274	2	nae
ne	2	70	4510	2	_ne
nee	3	66	5778	2	nee
obe	5	66	3864	2	obe
ode	4	74	4658	2	ode
odyl	8	41	1146	2	odyl
odyle	9	34	959	2	odyle
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
owe	6	70	4103	2	owe
oy	5	89	5013	2	oy_
oyer	7	59	2765	2	oyer
oyes	7	49	4013	2	oyes
oyez	16	60	2035	2	oyez
pe	4	76	4903	2	_pe
pee	5	60	6651	2	pee
pie	5	54	5740	2	pie
pya	8	70	2375	2	pya
pyes	9	55	2899	2	pyes
pyre	9	49	2555	2	pyre
pyx	15	78	1701	2	pyx
re	2	61	5374	2	_re
redye	9	44	1346	2	redye
ree	3	79	7407	2	ree
roe	3	68	6107	2	roe
rue	3	55	4926	2	rue
rya	6	76	2201	2	rya
ryes	7	55	2935	2	ryes
ryke	11	56	1640	2	ryke
sae	3	83	6518	2	sae
see	3	57	7226	2	see
she	6	68	3769	2	she
snye	7	71	1549	2	snye
stye	7	62	1897	2	stye
sue	3	56	5146	2	sue
syce	9	58	2028	2	syce
syke	11	54	2056	2	syke
syn	6	70	2412	2	syn
syne	7	57	2576	2	syne
tae	3	82	6705	2	tae
tee	3	83	6687	2	tee
the	6	74	3605	2	the
tie	3	65	5753	2	tie
toe	3	101	6685	2	toe
tyee	7	51	3142	2	tyee
tyer	7	53	2339	2	tyer
tyes	7	64	3337	2	tyes
tyke	11	57	2050	2	tyke
tyne	7	63	2505	2	tyne
type	9	62	2374	2	type
tyre	7	54	2825	2	tyre
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
we	5	70	4345	2	_we
wee	6	67	6081	2	wee
woe	6	66	5124	2	woe
wyes	10	57	2750	2	wyes
wyle	10	55	1938	2	wyle
wyn	9	59	2144	2	wyn
wyte	10	60	1864	2	wyte
ya	5	102	5150	2	_ya
yea	6	64	4575	2	_yea
yeh	9	71	3577	2	_yeh
yen	6	68	4738	2	_yen
yep	8	66	3896	2	_yep
yes	6	62	5061	2	_yes
yet	6	69	6069	2	_yet
yew	9	64	3629	2	_yew
yo	5	97	4855	2	_yo
zee	12	61	4323	2	zee
zyme	18	191	1494	2	zyme

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.110	1624463.6
2	DLD Change Limit	14084	300	0.720	19561.1
3	Display Results	300	300	0.063	4761.9
	(SQL Overall)	178691	300	0.893	200101.9