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

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

457 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
rias	4	55	4059	(None)
arias	5	54	3802	1	arias
bias	6	47	3815	1	bias
pias	6	65	4255	1	pias
raias	5	46	3112	1	raias
rais	4	52	5262	1	rais
ras	3	75	7539	1	r_as
ria	3	67	4550	1	ria_
rial	4	59	3809	1	rial
rials	5	50	2667	1	rials
ribs	6	58	3301	1	ribs
rids	5	65	3954	1	rids
rifs	7	49	2900	1	rifs
rigs	5	51	3759	1	rigs
rims	6	59	3630	1	rims
rins	4	61	5319	1	rins
rips	6	62	3743	1	rips
ryas	7	72	2461	1	ryas
aas	3	109	7539	2	_aas
abas	6	86	4208	2	abas
agas	5	59	3884	2	agas
agrias	7	43	1539	2	agrias
aids	5	78	4635	2	aids
ails	4	56	5471	2	ails
aims	6	77	3818	2	aims
ains	4	61	5888	2	ains
airs	4	64	4742	2	airs
ais	3	90	8357	2	ai_s
aits	4	63	5553	2	aits
alas	4	63	5812	2	alas
alias	5	58	3460	2	alias
amas	6	77	4629	2	amas
amias	7	58	3146	2	amias
anas	4	66	4986	2	anas
areas	5	59	3577	2	areas
aria	4	62	4542	2	aria_
arils	5	87	3220	2	arils
arras	5	56	2613	2	arras
as	2	110	8307	2	__as
baas	6	68	4467	2	baas
bas	5	86	8175	2	_bas
bibs	8	48	3097	2	bibs
bids	7	58	3842	2	bids
bigs	7	62	3501	2	bigs
bimas	9	55	2174	2	bimas
bins	6	65	4824	2	bins
bios	6	63	3531	2	bios
bis	5	68	6065	2	bi_s
bits	6	61	4815	2	bits
boas	6	61	5083	2	boas
bras	6	57	4645	2	bras
briar	7	57	1815	2	briar
briars	8	48	1482	2	briars
bries	7	49	4215	2	bries
brigs	8	58	2322	2	brigs
brims	9	47	2162	2	brims
brins	7	55	3397	2	brins
brios	7	47	2572	2	brios
bris	6	55	3961	2	bri_s
briss	7	58	2427	2	briss
brits	7	64	3308	2	brits
cerias	8	33	2197	2	cerias
chias	10	46	2551	2	chias
ciao	6	49	2418	2	ciao
cigs	7	56	2510	2	cigs
cis	5	77	4803	2	ci_s
cribs	9	45	1674	2	cribs
cries	7	54	3840	2	cries
cris	6	62	3343	2	cri_s
crits	7	55	2757	2	crits
dais	5	70	4070	2	dais
dial	5	59	3506	2	dial
dials	6	49	2534	2	dials
dibs	7	62	3367	2	dibs
dies	5	56	5352	2	dies
difs	8	60	2732	2	difs
digs	6	60	3605	2	digs
dims	7	54	3502	2	dims
dins	5	66	5204	2	dins
dips	7	55	3691	2	dips
dis	4	64	5989	2	di_s
diss	5	64	3448	2	diss
ditas	6	59	2367	2	ditas
dits	5	64	5052	2	dits
divas	9	54	1858	2	divas
dribs	8	51	1505	2	dribs
dries	6	47	3367	2	dries
drips	8	54	1723	2	drips
eras	4	54	4150	2	eras
ericas	8	3	1546	2	ericas
etas	4	64	3227	2	etas
eyas	7	64	2743	2	eyas
fas	6	82	6293	2	_fas
ferias	9	50	2039	2	ferias
fiar	7	64	2733	2	fiar
fiars	8	67	2083	2	fiars
fiat	7	66	4664	2	fiat
fiats	8	53	2448	2	fiats
fibs	9	63	2949	2	fibs
fids	8	70	3473	2	fids
figs	8	53	3264	2	figs
fils	7	58	3869	2	fils
fins	7	58	4909	2	fins
firs	7	66	3771	2	firs
fits	7	60	4346	2	fits
friar	8	54	1427	2	friar
friars	9	38	1209	2	friars
fries	8	55	3560	2	fries
frigs	9	60	1927	2	frigs
frits	8	61	2910	2	frits
gas	4	88	7025	2	_gas
gibs	7	55	2926	2	gibs
gids	6	59	3373	2	gids
gies	5	56	4142	2	gies
gigas	7	54	1558	2	gigas
gigs	6	66	3118	2	gigs
gins	5	55	4395	2	gins
gips	7	56	3292	2	gips
gits	5	57	4459	2	gits
glias	6	46	1849	2	glias
goas	5	52	3994	2	goas
grids	7	53	2139	2	grids
grigs	7	53	1819	2	grigs
grins	6	54	2722	2	grins
grips	8	55	2013	2	grips
grits	6	55	2958	2	grits
has	6	73	7265	2	_has
hies	7	48	4283	2	hies
hims	9	52	3097	2	hims
hins	7	64	4799	2	hins
hips	9	64	3370	2	hips
his	6	63	5950	2	hi_s
hiss	7	56	2921	2	hiss
hits	7	55	4513	2	hits
ids	4	75	3546	2	_ids
ifs	6	71	2424	2	_ifs
ins	3	59	4560	2	_ins
ires	4	56	3928	2	ires
irids	6	64	1776	2	irids
iris	4	57	3254	2	iris
irks	8	62	2013	2	irks
is	2	70	4821	2	_i_s
its	3	55	3883	2	_its
ixias	12	48	836	2	ixias
jiao	11	50	1784	2	jiao
jibs	13	67	2407	2	jibs
jigs	12	65	2476	2	jigs
jins	11	56	3501	2	jins
kaas	8	65	3184	2	kaas
kas	7	70	5858	2	_kas
keas	8	63	3709	2	keas
kids	9	60	2963	2	kids
kifs	11	60	2350	2	kifs
kinas	9	56	2691	2	kinas
kins	8	57	4790	2	kins
kips	10	64	3051	2	kips
kirs	8	58	3173	2	kirs
kis	7	80	5147	2	ki_s
kiss	8	52	2739	2	kiss
kits	8	64	4176	2	kits
kivas	12	46	1473	2	kivas
koas	8	56	3509	2	koas
kris	8	64	2360	2	kri_s
kvas	11	70	1594	2	kvas
las	3	72	8147	2	_las
leas	4	59	5418	2	leas
liar	4	72	2968	2	liar
liars	5	47	2316	2	liars
libs	6	67	3275	2	libs
lids	5	63	3645	2	lids
lies	4	64	5419	2	lies
limas	7	56	2763	2	limas
lins	4	70	5905	2	lins
lips	6	71	4144	2	lips
liras	5	60	2198	2	liras
lis	3	71	6227	2	li_s
litas	5	49	2377	2	litas
lits	4	62	5249	2	lits
mas	5	81	7581	2	_mas
miasm	9	12	1109	2	miasm
mibs	8	53	3046	2	mibs
micas	9	68	2305	2	micas
mics	8	74	3514	2	mics
mids	7	65	4177	2	mids
migs	7	69	3531	2	migs
mils	6	60	4532	2	mils
minas	7	54	3411	2	minas
mips	8	55	3407	2	mips
mirs	6	69	4056	2	mirs
mis	5	81	6261	2	mi_s
miss	6	53	3941	2	miss
moas	6	55	4534	2	moas
nibs	6	50	2830	2	nibs
nils	4	61	3245	2	nils
nims	6	62	2688	2	nims
nipas	7	71	1667	2	nipas
nips	6	58	3092	2	nips
nits	4	57	4164	2	nits
norias	6	55	1818	2	norias
obas	6	57	3093	2	obas
obias	7	61	1685	2	obias
ocas	6	67	2963	2	ocas
odas	5	72	3026	2	odas
ohias	8	44	1556	2	ohias
oils	4	63	3797	2	oils
okas	8	52	2539	2	okas
orcas	7	59	1862	2	orcas
pas	5	87	7574	2	_pas
peas	6	57	5506	2	peas
pia	5	68	4803	2	pia_
pial	6	56	3670	2	pial
pian	6	61	3609	2	pian
pians	7	51	2696	2	pians
picas	9	46	2652	2	picas
pics	8	56	3391	2	pics
pies	6	69	4960	2	pies
pigs	7	66	3422	2	pigs
pikas	11	42	1809	2	pikas
pimas	9	47	2510	2	pimas
pinas	7	54	3445	2	pinas
pins	6	55	5845	2	pins
pips	8	58	3713	2	pips
pis	5	63	6203	2	pi_s
piss	6	50	3333	2	piss
pitas	7	74	2767	2	pitas
pits	6	63	4874	2	pits
pries	7	43	3953	2	pries
prigs	8	52	1970	2	prigs
primas	10	44	1810	2	primas
prims	9	54	2593	2	prims
priss	7	46	2389	2	priss
proas	7	50	2880	2	proas
pyas	9	62	2570	2	pyas
qis	12	69	3438	2	qi_s
rad	4	76	6200	2	r_ad
rads	5	60	4660	2	rads
rag	4	57	6132	2	r_ag
ragas	6	53	2606	2	ragas
rags	5	54	4837	2	rags
rah	6	80	5240	2	r_ah
rai	3	76	5822	2	r_ai
raia	4	66	3838	2	raia
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
raitas	6	44	1767	2	raitas
raj	10	57	4022	2	r_aj
rajas	12	73	1772	2	rajas
ram	5	68	6727	2	r_am
rams	6	59	5077	2	rams
ran	3	82	6661	2	r_an
rap	5	62	6196	2	r_ap
raps	6	62	4773	2	raps
rase	4	61	4998	2	r_ase
rash	7	60	3993	2	r_ash
rasp	6	60	2916	2	r_asp
rat	3	78	9274	2	r_at
rats	4	62	6037	2	rats
raw	6	72	5225	2	r_aw
raws	7	52	3821	2	raws
rax	10	84	4572	2	r_ax
ray	6	63	6199	2	r_ay
rayas	8	59	2205	2	rayas
rays	7	76	4235	2	rays
read	5	59	4253	2	read
reads	6	48	3527	2	reads
real	4	57	5029	2	real
reals	5	50	3865	2	reals
ream	6	58	4161	2	ream
reams	7	57	2962	2	reams
reap	6	59	3474	2	reap
reaps	7	56	2619	2	reaps
rear	4	56	4455	2	rear
rears	5	47	3965	2	rears
rebs	6	57	3356	2	rebs
recs	6	57	3418	2	recs
redias	7	45	2360	2	redias
reds	5	60	4286	2	reds
rees	4	53	6419	2	rees
refs	7	57	3224	2	refs
regs	5	54	3657	2	regs
reifs	8	48	1909	2	reifs
reins	5	62	3456	2	reins
reis	4	53	4323	2	reis
rems	6	62	3772	2	rems
reps	6	59	3795	2	reps
res	3	55	6504	2	r_es
rets	4	53	5256	2	rets
revs	7	50	2705	2	revs
rheas	8	48	1695	2	rheas
rhos	7	63	1906	2	rhos
rhus	7	51	1405	2	rhus
riant	5	58	3315	2	riant
riata	5	46	1802	2	riata
riatas	6	39	1508	2	riatas
rib	5	68	4802	2	ri_b
ribes	7	55	3017	2	ribes
rice	6	49	4291	2	rice
rices	7	55	3615	2	rices
rich	9	70	2554	2	rich
rick	10	73	3465	2	rick
ricks	11	51	2613	2	ricks
rid	4	67	5462	2	ri_d
ride	5	59	4512	2	ride
rides	6	61	4081	2	rides
riel	4	64	3238	2	riel
riels	5	51	2133	2	riels
rif	6	59	5155	2	ri_f
rife	7	46	3232	2	rife
riff	10	44	3009	2	riff
riffs	11	51	1461	2	riffs
rift	7	56	4233	2	rift
rifts	8	57	1864	2	rifts
rig	4	67	4812	2	ri_g
rile	4	56	5053	2	rile
riles	5	53	4364	2	riles
rill	4	51	4090	2	rill
rills	5	50	3271	2	rills
rim	5	60	5227	2	ri_m
rime	6	51	3888	2	rime
rimes	7	56	3454	2	rimes
rimy	9	66	2128	2	rimy
rin	3	66	6318	2	ri_n
rind	5	65	3560	2	rind
rinds	6	48	2614	2	rinds
ring	5	65	4115	2	ring
rings	6	50	2917	2	rings
rink	8	77	3699	2	rink
rinks	9	48	2710	2	rinks
rinse	5	48	2097	2	rinse
riojas	13	3	581	2	riojas
riot	4	59	4721	2	riot
riots	5	49	2201	2	riots
rip	5	68	5130	2	ri_p
ripe	6	60	3892	2	ripe
ripes	7	54	3577	2	ripes
rise	4	59	4523	2	rise
rises	5	52	4404	2	rises
risk	8	57	2410	2	risk
risks	9	49	1706	2	risks
risus	5	42	1639	2	risus
rite	4	58	4945	2	rite
rites	5	44	4255	2	rites
ritz	13	51	2998	2	ritz
rival	8	52	1650	2	rival
rivals	9	42	1318	2	rivals
rive	7	55	3772	2	rive
rives	8	53	3600	2	rives
riyal	8	44	1343	2	riyal
riyals	9	41	1108	2	riyals
road	5	63	3211	2	road
roads	6	65	2361	2	roads
roam	6	71	3241	2	roam
roams	7	49	1961	2	roams
roan	4	72	3420	2	roan
roans	5	49	2644	2	roans
roar	4	63	2857	2	roar
roars	5	56	2223	2	roars
roast	5	62	3014	2	roast
robs	6	58	3787	2	robs
rocs	6	55	3366	2	rocs
rods	5	64	4206	2	rods
roes	4	59	5413	2	roes
roils	5	48	2679	2	roils
roms	6	70	3896	2	roms
rotas	5	48	2772	2	rotas
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
ruins	5	58	2203	2	ruins
rums	6	48	3347	2	rums
runs	4	64	3807	2	runs
ruts	4	45	4149	2	ruts
rya	6	76	2201	2	rya_
ryes	7	55	2935	2	ryes
seas	4	57	5527	2	seas
sial	4	59	3883	2	sial
sials	5	42	2724	2	sials
sibs	6	59	3353	2	sibs
sics	6	52	3409	2	sics
sikas	9	46	1702	2	sikas
simas	7	57	2755	2	simas
sims	6	57	3717	2	sims
sins	4	67	5527	2	sins
sips	6	57	4010	2	sips
sirs	4	43	3833	2	sirs
sis	3	73	6054	2	si_s
sits	4	50	5020	2	sits
skas	8	53	2571	2	skas
spas	6	70	3672	2	spas
sris	4	54	3415	2	sri_s
tas	3	84	7710	2	_tas
teas	4	58	5149	2	teas
tics	6	57	2963	2	tics
ties	4	52	4831	2	ties
tils	4	57	3961	2	tils
tins	4	52	5130	2	tins
tips	6	64	3676	2	tips
tis	3	70	5664	2	ti_s
tits	4	61	4503	2	tits
triac	7	41	1637	2	triac
triacs	8	39	1322	2	triacs
triad	6	52	1772	2	triad
triads	7	45	1352	2	triads
trial	5	49	2635	2	trial
trials	6	43	1988	2	trials
tries	5	57	4281	2	tries
trigs	6	54	2306	2	trigs
trims	7	50	2147	2	trims
trios	5	55	2809	2	trios
trips	7	49	2336	2	trips
twas	7	68	2408	2	twas
upas	6	83	2238	2	upas
urbias	8	3	908	2	urbias
ureas	5	58	2601	2	ureas
urial	5	48	2302	2	urial
urials	6	44	1519	2	urials
utas	4	59	2495	2	utas
varias	9	50	1990	2	varias
vas	6	77	5577	2	_vas
via	6	56	3624	2	via_
vial	7	67	3109	2	vial
vials	8	58	2238	2	vials
vids	8	56	2753	2	vids
vies	7	52	3862	2	vies
vigas	9	48	1788	2	vigas
vigs	8	54	2727	2	vigs
vims	9	54	2331	2	vims
vinas	8	51	2634	2	vinas
vis	6	67	4761	2	vi_s
visa	7	63	2387	2	visa
visas	8	43	1765	2	visas
vivas	11	48	1502	2	vivas
was	6	87	6756	2	_was
wigs	8	49	3125	2	wigs
wins	7	59	4917	2	wins
wis	6	65	5233	2	wi_s
wiss	7	56	3054	2	wiss
wits	7	60	4487	2	wits
wries	8	58	2774	2	wries
writs	8	66	2438	2	writs
xis	10	69	3533	2	xi_s
yeas	7	86	3842	2	yeas
yids	8	52	2495	2	yids
yins	7	53	3512	2	yins
yips	9	52	2669	2	yips
zas	12	69	4683	2	_zas
zigs	14	54	2279	2	zigs
zins	13	57	3500	2	zins
zips	15	57	2379	2	zips
zits	13	60	3029	2	zits

Search took 4 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.283	631417.0
2	DLD Change Limit	29872	457	2.546	11732.9
3	Display Results	457	457	0.220	2077.3
	(SQL Overall)	178691	457	3.049	58606.4