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

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

469 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
rays	7	76	4235	(None)
ays	6	70	5029	1	_ays
bays	9	71	4391	1	bays
brays	10	67	2311	1	brays
cays	9	54	3767	1	cays
days	8	76	3713	1	days
drays	9	58	1977	1	drays
fays	10	85	3536	1	fays
frays	11	69	2010	1	frays
gays	8	73	3802	1	gays
grays	9	56	2133	1	grays
hays	10	61	3807	1	hays
jays	14	63	2834	1	jays
kays	11	60	3219	1	kays
lays	7	60	4325	1	lays
mays	9	69	4002	1	mays
nays	7	59	3159	1	nays
pays	9	59	4022	1	pays
prays	10	50	2243	1	prays
rads	5	60	4660	1	rads
rags	5	54	4837	1	rags
rais	4	52	5262	1	rais
rams	6	59	5077	1	rams
raps	6	62	4773	1	raps
ras	3	75	7539	1	ra_s
rats	4	62	6037	1	rats
raws	7	52	3821	1	raws
ray	6	63	6199	1	ray_
raya	7	52	2482	1	raya
rayas	8	59	2205	1	rayas
ryas	7	72	2461	1	ryas
says	7	59	4210	1	says
trays	8	56	2343	1	trays
ways	10	77	3795	1	ways
yays	10	57	2891	1	yays
aahs	7	164	2856	2	aahs
aals	4	99	4114	2	aals
aas	3	109	7539	2	_aas
abs	5	93	5607	2	_abs
abys	9	72	2188	2	abys
ads	4	97	5573	2	_ads
ags	4	75	5166	2	_ags
ahs	6	86	4482	2	_ahs
ais	3	90	8357	2	_ais
als	3	66	6302	2	_als
araks	9	48	2088	2	araks
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
arrays	9	53	1168	2	arrays
ars	3	76	7093	2	_ars
arts	4	96	5026	2	arts
aryl	7	59	2234	2	aryl
aryls	8	70	1581	2	aryls
as	2	110	8307	2	_a_s
ass	3	78	4406	2	_ass
ay	5	117	7389	2	_ay_
aye	6	71	5176	2	_aye
ayes	7	65	4351	2	_ayes
baas	6	68	4467	2	baas
bads	7	70	4886	2	bads
bags	7	66	4550	2	bags
bals	6	63	5404	2	bals
bams	8	70	4445	2	bams
bans	6	65	5513	2	bans
baps	8	60	4084	2	baps
bars	6	65	6409	2	bars
bas	5	86	8175	2	ba_s
bass	6	61	4678	2	bass
bats	6	69	6233	2	bats
bay	8	96	6164	2	bay_
beys	9	138	2955	2	beys
boys	9	67	3733	2	boys
brads	8	55	2829	2	brads
braes	7	57	3505	2	braes
brags	8	56	2510	2	brags
brans	7	54	3743	2	brans
bras	6	57	4645	2	bra_s
brass	7	54	2802	2	brass
brats	7	53	3601	2	brats
braws	10	64	2519	2	braws
bray	9	52	3290	2	bray_
buys	9	57	2679	2	buys
bys	8	52	2946	2	_bys
cabs	8	67	3942	2	cabs
cads	7	61	4452	2	cads
cams	8	70	4728	2	cams
cans	6	50	5084	2	cans
caps	8	71	4789	2	caps
cars	6	73	6476	2	cars
cats	6	63	5634	2	cats
caws	9	60	3610	2	caws
cay	8	71	5598	2	cay_
chays	13	53	1974	2	chays
clays	10	55	2133	2	clays
coys	9	75	3724	2	coys
crabs	9	54	2139	2	crabs
crags	8	56	2257	2	crags
crams	9	62	2915	2	crams
craps	9	53	2864	2	craps
crass	7	63	2804	2	crass
craws	10	57	2312	2	craws
dabs	7	71	3940	2	dabs
dads	6	74	4277	2	dads
dags	6	66	4259	2	dags
dahs	8	82	3181	2	dahs
dais	5	70	4070	2	dais
daks	9	71	3060	2	daks
dals	5	71	4512	2	dals
dams	7	74	4437	2	dams
dans	5	67	4814	2	dans
daps	7	72	3916	2	daps
daws	8	66	3824	2	daws
day	7	62	5411	2	day_
derays	10	55	1425	2	derays
deys	8	50	2747	2	deys
drabs	8	51	1967	2	drabs
drags	7	55	2111	2	drags
drams	8	60	2583	2	drams
drats	6	66	2837	2	drats
draws	9	51	1937	2	draws
dray	8	54	2809	2	dray_
drys	8	63	1480	2	drys
ears	4	63	5659	2	ears
easy	7	62	2449	2	easy
eats	4	70	5487	2	eats
eras	4	54	4150	2	era_s
eyas	7	64	2743	2	eyas
fabs	9	86	3586	2	fabs
fads	8	69	3987	2	fads
fags	8	69	3912	2	fags
fans	7	62	4736	2	fans
fas	6	82	6293	2	fa_s
fats	7	62	5250	2	fats
fay	9	74	5486	2	fay_
flays	11	63	2105	2	flays
forays	12	48	1300	2	forays
foys	10	56	2829	2	foys
frags	9	63	2216	2	frags
fraps	10	56	2055	2	fraps
frass	8	53	2112	2	frass
frats	8	68	2967	2	frats
fray	10	54	2890	2	fray_
gabs	7	67	4042	2	gabs
gads	6	78	4338	2	gads
gaes	5	63	4803	2	gaes
gags	6	64	4106	2	gags
gals	5	79	4650	2	gals
gams	7	66	4888	2	gams
gaps	7	60	4297	2	gaps
gars	5	57	5074	2	gars
gas	4	88	7025	2	ga_s
gats	5	67	5344	2	gats
gay	7	68	5649	2	gay_
goys	8	63	2841	2	goys
grabs	8	57	1969	2	grabs
grads	7	56	2575	2	grads
grams	8	53	2731	2	grams
grans	6	48	3254	2	grans
grass	6	61	2520	2	grass
gray	8	53	2989	2	gray_
greys	9	66	1485	2	greys
guys	8	50	1964	2	guys
haes	7	76	5102	2	haes
hags	8	67	4084	2	hags
hahs	10	83	3336	2	hahs
hams	9	64	4613	2	hams
haps	9	64	4346	2	haps
has	6	73	7265	2	ha_s
hats	7	68	5825	2	hats
haws	10	64	3944	2	haws
hay	9	73	5877	2	hay_
hoys	10	77	3393	2	hoys
jabs	13	58	3009	2	jabs
jags	12	61	3279	2	jags
jams	13	52	3107	2	jams
jars	11	73	3835	2	jars
jaws	14	50	2729	2	jaws
jay	13	62	4267	2	jay_
joys	14	66	2466	2	joys
kaas	8	65	3184	2	kaas
kabs	10	71	3084	2	kabs
kaes	8	57	3406	2	kaes
kafs	11	64	2374	2	kafs
kas	7	70	5858	2	ka_s
kats	8	59	4433	2	kats
kay	10	67	4554	2	kay_
kayo	11	64	1755	2	kayo
kayos	12	77	1470	2	kayos
keys	11	63	2216	2	keys
labs	6	71	4512	2	labs
lacs	6	69	4248	2	lacs
lads	5	65	4913	2	lads
lags	5	65	4622	2	lags
lams	6	65	5226	2	lams
laps	6	68	4887	2	laps
lars	4	69	5657	2	lars
las	3	72	8147	2	la_s
lass	4	74	4454	2	lass
lats	4	59	6270	2	lats
lavs	7	67	3415	2	lavs
laws	7	64	4168	2	laws
lay	6	88	6535	2	lay_
leys	7	64	3018	2	leys
macs	8	67	4250	2	macs
mads	7	68	4536	2	mads
maes	6	69	4839	2	maes
mags	7	54	4452	2	mags
mans	6	63	5453	2	mans
maps	8	61	4104	2	maps
mars	6	62	6186	2	mars
mas	5	81	7581	2	ma_s
mass	6	60	4493	2	mass
mats	6	54	6028	2	mats
maws	9	64	3713	2	maws
may	8	87	5762	2	may_
maya	9	58	2458	2	maya
mayas	10	59	2438	2	mayas
mayo	9	65	2429	2	mayo
mayos	10	55	2193	2	mayos
mayst	10	66	2267	2	mayst
morays	11	46	1388	2	morays
nabs	6	62	3619	2	nabs
nags	5	54	3602	2	nags
nans	4	61	3939	2	nans
naos	4	74	2973	2	naos
naps	6	62	3858	2	naps
nay	6	69	5277	2	nay_
oafs	7	64	2526	2	oafs
oaks	8	65	2790	2	oaks
oars	4	68	4603	2	oars
oats	4	65	5421	2	oats
ofays	11	48	892	2	ofays
okays	12	60	944	2	okays
orals	5	58	2648	2	orals
pacs	8	58	4218	2	pacs
pads	7	67	4295	2	pads
pals	6	69	5135	2	pals
pams	8	56	4176	2	pams
pans	6	58	5572	2	pans
paps	8	64	4345	2	paps
pars	6	75	6079	2	pars
pas	5	87	7574	2	pa_s
pass	6	52	3995	2	pass
pats	6	64	6085	2	pats
paws	9	60	3818	2	paws
pay	8	84	6118	2	pay_
plays	10	63	2077	2	plays
prams	9	61	2551	2	prams
praos	7	49	2356	2	praos
prats	7	63	3339	2	prats
praus	7	46	2175	2	praus
pray	9	63	3153	2	pray_
preys	10	57	1778	2	preys
pyas	9	62	2570	2	pyas
qats	13	53	3134	2	qats
quays	17	46	1204	2	quays
race	6	67	4626	2	race
races	7	49	4324	2	races
rack	10	62	3488	2	rack
racks	11	50	2885	2	racks
racy	9	58	2568	2	racy
rad	4	76	6200	2	ra_d
raff	10	49	3304	2	raff
raffs	11	50	1752	2	raffs
raft	7	62	4591	2	raft
rafts	8	78	2063	2	rafts
rag	4	57	6132	2	ra_g
raga	5	59	3081	2	raga
ragas	6	53	2606	2	ragas
rage	5	57	4235	2	rage
rages	6	45	3944	2	rages
ragg	6	56	2269	2	ragg
raggs	7	52	1647	2	raggs
ragi	5	60	3228	2	ragi
ragis	6	63	2560	2	ragis
rah	6	80	5240	2	ra_h
rai	3	76	5822	2	ra_i
raia	4	66	3838	2	raia
raias	5	46	3112	2	raias
raid	5	52	4307	2	raid
raids	6	58	2751	2	raids
rail	4	61	4776	2	rail
rails	5	59	3740	2	rails
rain	4	62	5173	2	rain
rains	5	51	4023	2	rains
raise	5	48	2805	2	raise
raj	10	57	4022	2	ra_j
raja	11	79	1868	2	raja
rajas	12	73	1772	2	rajas
rajes	12	50	2278	2	rajes
rake	8	48	4157	2	rake
rakes	9	44	4035	2	rakes
raki	8	71	2783	2	raki
rakis	9	53	2344	2	rakis
raku	8	54	2377	2	raku
rakus	9	44	1367	2	rakus
rale	4	50	5056	2	rale
rales	5	49	4749	2	rales
ram	5	68	6727	2	ra_m
rami	6	60	3409	2	rami
ramp	8	59	3400	2	ramp
ramps	9	62	2463	2	ramps
ramus	7	64	1828	2	ramus
ran	3	82	6661	2	ra_n
rand	5	58	3956	2	rand
rands	6	59	3045	2	rands
rang	5	69	3915	2	rang
rani	4	66	4010	2	rani
ranis	5	52	3583	2	ranis
rank	8	51	3552	2	rank
ranks	9	52	2573	2	ranks
rant	4	58	6467	2	rant
rants	5	59	3534	2	rants
rap	5	62	6196	2	ra_p
rape	6	50	4163	2	rape
rapes	7	57	4072	2	rapes
rapt	6	72	4531	2	rapt
rare	4	53	4843	2	rare
rares	5	52	4744	2	rares
rase	4	61	4998	2	rase
rases	5	54	4721	2	rases
rash	7	60	3993	2	rash
rasp	6	60	2916	2	rasp
rasps	7	43	1666	2	rasps
rat	3	78	9274	2	ra_t
rate	4	54	5876	2	rate
rates	5	53	5201	2	rates
rath	7	60	3766	2	rath
rato	4	54	3697	2	rato
ratos	5	55	2876	2	ratos
rave	7	55	4209	2	rave
raves	8	54	4197	2	raves
raw	6	72	5225	2	ra_w
rax	10	84	4572	2	ra_x
raxes	12	47	2939	2	raxes
rayah	11	60	1350	2	rayah
rayahs	12	57	919	2	rayahs
rayed	9	51	2750	2	rayed
rayon	8	38	1570	2	rayon
rayons	9	41	1334	2	rayons
raze	13	52	3543	2	raze
razes	14	50	3270	2	razes
razz	12	52	1942	2	razz
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
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reis	4	53	4323	2	reis
relays	9	43	1675	2	relays
rems	6	62	3772	2	rems
repays	11	38	1397	2	repays
reps	6	59	3795	2	reps
res	3	55	6504	2	r_es
resays	9	37	1415	2	resays
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rhos	7	63	1906	2	rhos
rhus	7	51	1405	2	rhus
rials	5	50	2667	2	rials
rias	4	55	4059	2	rias
ribs	6	58	3302	2	ribs
rids	5	65	3954	2	rids
rifs	7	49	2900	2	rifs
rigs	5	51	3759	2	rigs
rims	6	59	3630	2	rims
rins	4	61	5319	2	rins
rips	6	62	3743	2	rips
roads	6	65	2361	2	roads
roams	7	49	1961	2	roams
roans	5	49	2644	2	roans
roars	5	56	2223	2	roars
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
roms	6	70	3896	2	roms
rosy	7	60	2487	2	rosy
rots	4	64	5409	2	rots
rows	7	59	4175	2	rows
rubs	6	61	3349	2	rubs
rues	4	60	4448	2	rues
rugs	5	60	3368	2	rugs
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
rya	6	76	2201	2	r_ya
rye	6	60	3254	2	r_ye
ryes	7	55	2935	2	ryes
sabs	6	66	4374	2	sabs
sacs	6	57	3907	2	sacs
sags	5	59	4840	2	sags
sals	4	68	5167	2	sals
sans	4	51	5335	2	sans
saps	6	53	4637	2	saps
sass	4	50	3562	2	sass
saws	7	58	3948	2	saws
say	6	72	6476	2	say_
sayst	8	53	2200	2	sayst
shays	11	60	2143	2	shays
slays	8	57	2368	2	slays
soys	7	52	3393	2	soys
spays	10	55	2051	2	spays
sprays	11	59	1364	2	sprays
stays	8	60	2202	2	stays
strays	9	64	1793	2	strays
sways	11	55	1846	2	sways
tabs	6	68	4298	2	tabs
tads	5	71	4394	2	tads
tags	5	55	4523	2	tags
tams	6	72	4793	2	tams
tans	4	61	5481	2	tans
taos	4	55	4100	2	taos
taps	6	60	5067	2	taps
tars	4	67	6395	2	tars
tas	3	84	7710	2	ta_s
tass	4	56	4057	2	tass
tats	4	68	5813	2	tats
taus	4	63	4273	2	taus
tavs	7	56	3097	2	tavs
taws	7	56	4159	2	taws
toys	7	80	3634	2	toys
trams	7	53	2767	2	trams
trans	5	49	3304	2	trans
traps	7	57	2748	2	traps
trass	5	62	2647	2	trass
tray	7	76	3259	2	tray_
treys	8	50	1821	2	treys
troys	8	64	1861	2	troys
vacs	9	62	2620	2	vacs
vans	7	62	3672	2	vans
vars	7	57	4207	2	vars
vas	6	77	5577	2	va_s
vats	7	68	4174	2	vats
vaus	7	59	2892	2	vaus
vavs	10	57	2043	2	vavs
vaws	10	55	2732	2	vaws
wabs	9	73	3723	2	wabs
wads	8	73	4314	2	wads
waes	7	60	4860	2	waes
wags	8	61	4055	2	wags
wans	7	64	5226	2	wans
waps	9	66	4208	2	waps
wars	7	86	5980	2	wars
was	6	87	6756	2	wa_s
wats	7	75	5588	2	wats
waws	10	68	3490	2	waws
way	9	67	5766	2	way_
whys	13	70	1166	2	whys
wraps	10	56	1715	2	wraps
yags	8	66	3229	2	yags
yaks	11	60	2520	2	yaks
yams	9	53	3073	2	yams
yaps	9	59	3352	2	yaps
yaws	10	55	3121	2	yaws
yay	9	69	4871	2	yay_
zags	14	68	2668	2	zags
zaps	15	68	2689	2	zaps
zas	12	69	4683	2	za_s

Search took 2 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	29872	0.080	2233637.5
2	DLD Change Limit	29872	469	1.030	29001.9
3	Display Results	469	469	0.110	4263.6
	(SQL Overall)	178691	469	1.220	146468.0