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

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

313 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
lye	6	65	3341	(None)
aye	6	71	5176	1	aye
bye	8	61	3459	1	bye
dye	7	53	3484	1	dye
eye	6	55	3977	1	eye
kye	10	73	2727	1	kye
lee	3	60	6814	1	lee
ley	6	62	4681	1	ley
lie	3	82	6452	1	lie
lyes	7	55	3083	1	lyes
lyre	7	56	2379	1	lyre
lyse	7	63	2059	1	lyse
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
ae	2	125	9029	2	_ae
age	4	71	5433	2	age
alae	4	56	4375	2	alae
ale	3	65	7234	2	ale
alee	4	66	5232	2	alee
alme	6	58	3216	2	alme
aloe	4	55	4019	2	aloe
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
blae	6	61	3464	2	blae
blue	6	53	2846	2	blue
blype	12	42	967	2	blype
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
clue	6	53	2453	2	clue
cue	5	75	4418	2	cue
cyme	11	94	2037	2	cyme
de	3	70	4954	2	_de
dee	4	76	6582	2	dee
dey	7	72	4337	2	dey
die	4	67	5965	2	die
doe	4	73	6195	2	doe
due	4	52	4986	2	due
dyed	9	67	2076	2	dyed
dyer	8	55	2211	2	dyer
dyes	8	53	3189	2	dyes
dyke	12	64	1818	2	dyke
dyne	8	53	2093	2	dyne
eke	7	56	3009	2	eke
else	4	59	2308	2	else
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
flee	7	62	3879	2	flee
fley	10	66	2685	2	fley
floe	7	61	2977	2	floe
flue	7	53	2985	2	flue
fly	9	71	2495	2	fly_
flyer	11	49	1625	2	flyer
flyte	11	57	1394	2	flyte
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
glee	5	52	3906	2	glee
gley	8	57	2465	2	gley
glue	5	56	2849	2	glue
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
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
la	2	192	6163	2	l_a
lab	5	88	6478	2	lab
lac	5	101	5582	2	lac
lace	6	68	4847	2	lace
lad	4	81	6570	2	lad
lade	5	63	4598	2	lade
lag	4	78	6212	2	lag
lake	8	57	4160	2	lake
lam	5	76	6671	2	lam
lame	6	68	4929	2	lame
lane	4	51	5332	2	lane
lap	5	85	6527	2	lap
lar	3	79	6753	2	lar
las	3	72	8147	2	las
lase	4	61	4851	2	lase
lat	3	75	9340	2	lat
late	4	75	6048	2	late
lav	6	68	4734	2	lav
lave	7	56	4214	2	lave
law	6	86	5664	2	law
lax	10	76	5152	2	lax
lay	6	88	6535	2	lay
layed	9	51	2738	2	layed
layer	8	46	2647	2	layer
lays	7	60	4325	2	lays
laze	13	62	3505	2	laze
lea	3	76	6018	2	lea
led	4	62	5455	2	led
leek	8	53	3173	2	leek
leer	4	62	3935	2	leer
lees	4	54	5588	2	lees
leet	4	59	5790	2	leet
leg	4	64	4611	2	leg
lei	3	68	4638	2	lei
lek	7	56	4030	2	lek
leke	8	55	2740	2	leke
les	3	56	6307	2	les
let	3	64	8147	2	let
leu	3	60	4740	2	leu
lev	6	61	3942	2	lev
lex	10	79	4382	2	lex
leys	7	64	3018	2	leys
lez	12	55	4131	2	lez
li	2	99	4875	2	l_i
lib	5	77	5027	2	lib
lice	6	60	4506	2	lice
lid	4	74	5351	2	lid
lied	5	58	3809	2	lied
lief	7	60	3699	2	lief
lien	4	53	3980	2	lien
lier	4	59	4246	2	lier
lies	4	64	5419	2	lies
lieu	4	65	3436	2	lieu
life	7	54	3373	2	life
like	8	60	4084	2	like
lime	6	62	4493	2	lime
lin	3	79	6737	2	lin
line	4	69	6557	2	line
lip	5	147	5580	2	lip
lipe	6	68	3973	2	lipe
lire	4	78	4529	2	lire
lis	3	71	6227	2	lis
lit	3	93	7731	2	lit
lite	4	70	5454	2	lite
live	7	65	4099	2	live
lo	2	80	5344	2	l_o
lob	5	71	5446	2	lob
lobe	6	55	3536	2	lobe
lode	5	62	4011	2	lode
log	4	62	5268	2	log
loge	5	68	3719	2	loge
lone	4	58	4913	2	lone
loo	3	83	5982	2	loo
lop	5	82	5531	2	lop
lope	6	59	4192	2	lope
lore	4	58	5035	2	lore
lose	4	51	4458	2	lose
lot	3	81	7926	2	lot
love	7	52	3476	2	love
low	6	60	5187	2	low
lowe	7	54	3531	2	lowe
lox	10	82	4096	2	lox
lube	6	47	3156	2	lube
luce	6	51	3257	2	luce
lude	5	53	3164	2	lude
lues	4	59	4355	2	lues
lug	4	61	3806	2	lug
luge	5	55	3164	2	luge
lum	5	55	4293	2	lum
lune	4	71	4049	2	lune
lure	4	51	4246	2	lure
lute	4	63	4101	2	lute
luv	6	71	2577	2	luv
lux	10	65	2877	2	lux
luxe	11	52	2269	2	luxe
lwei	7	53	1264	2	lwei
lyase	8	55	1241	2	lyase
lycea	10	41	894	2	lycea
lycee	10	47	1674	2	lycee
lych	12	60	1576	2	lych
lynx	14	3	742	2	lynx
lyres	8	50	1996	2	lyres
lysed	9	50	1156	2	lysed
lyses	8	45	1825	2	lyses
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
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
plie	6	51	2739	2	plie
ply	8	63	2355	2	ply_
plyer	10	62	1433	2	plyer
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
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
sloe	4	55	3495	2	sloe
slue	4	53	3219	2	slue
sly	6	62	2856	2	sly_
slyer	8	55	1512	2	slyer
slype	10	51	1236	2	slype
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
ylem	9	2	1789	2	ylem
yo	5	97	4855	2	_yo
zee	12	61	4323	2	zee
zyme	18	191	1494	2	zyme

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	14084	0.076	2351197.4
2	DLD Change Limit	14084	313	1.250	11267.2
3	Display Results	313	313	0.516	606.6
	(SQL Overall)	178691	313	1.842	97009.2