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

Here are the results of your fuzzy-string dictionary search for “riojas” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

347 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
riojas	13	3	581	(None)
rioja	12	3	630	1	rioja_
biogas	9	43	1091	2	biogas
biotas	8	43	1392	2	biotas
iotas	5	48	2111	2	_iotas
ninjas	13	8	630	2	ninjas
rajas	12	73	1772	2	r_ajas
rias	4	55	4059	2	ri__as
riatas	6	39	1509	2	riatas
riots	5	49	2201	2	rio_ts
rotas	5	48	2772	2	r_otas
sojas	12	47	1639	2	_sojas
violas	9	37	1352	2	violas
abomas	10	11	1358	3	abomas
agoras	7	6	1334	3	agoras
aiolis	6	3	1684	3	aiolis
alohas	9	4	1170	3	alohas
anoas	5	72	2649	3	ano_as
areolas	7	10	1386	3	areolas
arias	5	54	3802	3	ari__as
ariosos	7	40	985	3	ariosos
aristas	7	4	1352	3	aristas
aromas	8	10	1861	3	aromas
arrobas	9	6	921	3	arrobas
bias	6	47	3816	3	bi__as
bijous	15	4	804	3	bijous
bimas	9	55	2174	3	bi_mas
biogs	8	50	1611	3	bio_gs
biomass	11	5	599	3	biomass
biomes	10	38	1525	3	biomes
bionts	8	6	1239	3	bionts
bios	6	63	3532	3	bio__s
biota	7	45	1682	3	biota_
boas	6	61	5083	3	_bo_as
bolas	7	47	3376	3	_bolas
boras	7	59	3830	3	_boras
botas	7	53	2878	3	_botas
brios	7	47	2572	3	brio__s
cariocas	12	3	966	3	cariocas
cholas	11	48	1800	3	cholas
cions	7	52	2285	3	cio_ns
citolas	9	3	936	3	citolas
cocas	9	59	2657	3	_cocas
codas	8	47	2424	3	_codas
colas	7	54	3677	3	_colas
comas	9	58	3300	3	_comas
diodes	8	39	1578	3	diodes
diols	6	55	2101	3	dio_ls
dioxan	14	6	577	3	dioxan
dioxans	15	5	531	3	dioxans
dipsas	9	35	989	3	dipsas
ditas	6	59	2367	3	di_tas
divas	9	54	1858	3	di_vas
dojos	13	51	1179	3	_dojos
donas	6	59	2647	3	_donas
dopas	8	50	1906	3	_dopas
ericas	8	3	1546	3	eri_cas
feijoas	17	4	232	3	feijoas
fincas	11	35	1207	3	fincas
fiords	10	49	862	3	fiords
floras	9	47	1569	3	floras
flotas	9	40	1300	3	flotas
ganjas	14	14	911	3	ganjas
gigas	7	54	1558	3	gi_gas
gliomas	10	3	533	3	gliomas
goas	5	52	3994	3	_go_as
gringas	9	3	804	3	gringas
griots	7	47	1364	3	grio_ts
gyozas	19	3	361	3	gyozas
hijab	17	3	680	3	hi_jab
hijabs	18	3	308	3	hi_jabs
hijras	16	3	577	3	hijras
hookas	13	53	1249	3	hookas
horas	8	63	3309	3	_horas
hoyas	11	50	1616	3	_hoyas
ideas	6	59	1901	3	_ideas
ions	4	67	3785	3	_io_ns
iota	4	51	2783	3	_iota_
irokos	10	3	723	3	irokos
irones	6	47	2401	3	irones
irons	5	53	2413	3	iro_ns
isbas	7	10	1040	3	_isbas
ixias	12	48	837	3	_ixias
ixoras	13	3	719	3	ixoras
jimjams	17	4	207	3	jimjams
jotas	12	57	1744	3	_jotas
kiblas	12	3	932	3	kiblas
kinas	9	56	2691	3	ki_nas
kiosks	9	3	438	3	kiosks
kivas	12	46	1473	3	ki_vas
koas	8	56	3509	3	_ko_as
kojis	16	46	843	3	_kojis
kolas	9	48	2223	3	_kolas
koras	9	59	2711	3	_koras
lianas	6	37	1338	3	lianas
libras	8	37	1170	3	libras
limas	7	56	2763	3	li_mas
limbas	10	53	1320	3	limbas
limpas	10	55	1308	3	limpas
lingas	7	51	1657	3	lingas
lions	5	59	2321	3	lio_ns
lipomas	11	5	644	3	lipomas
liras	5	60	2198	3	li_ras
litas	5	49	2377	3	li_tas
loofas	9	42	983	3	loofas
lotas	5	59	2630	3	_lotas
micas	9	68	2305	3	mi_cas
milpas	10	17	1027	3	milpas
mimosas	11	3	675	3	mimosas
minas	7	54	3411	3	mi_nas
mioses	8	43	1885	3	mioses
miosis	8	36	1516	3	miosis
mirzas	17	3	818	3	mirzas
moas	6	55	4534	3	_mo_as
mojos	14	53	1446	3	_mojos
molas	7	51	3209	3	_molas
monas	7	47	3215	3	_monas
moolas	8	36	1559	3	moolas
moras	7	64	3877	3	_moras
moxas	14	50	1439	3	_moxas
myomas	13	3	830	3	myomas
ninja	12	5	809	3	ninja_
nipas	7	71	1667	3	ni_pas
nomas	7	47	2641	3	_nomas
nonas	5	51	2665	3	_nonas
novas	8	52	1536	3	_novas
obas	6	57	3093	3	__obas
ocas	6	67	2963	3	__ocas
odas	5	72	3026	3	__odas
okas	8	52	2539	3	__okas
orioles	7	4	1299	3	orioles
orishas	10	3	647	3	orishas
pias	6	65	4255	3	pi__as
picas	9	46	2652	3	pi_cas
pietas	8	45	1650	3	pietas
pikas	11	42	1809	3	pi_kas
pimas	9	47	2510	3	pi_mas
pinas	7	54	3445	3	pi_nas
pinnas	8	53	1551	3	pinnas
pintas	8	50	2139	3	pintas
pions	7	58	2639	3	pio_ns
pious	7	46	2127	3	pio_us
pitas	7	74	2767	3	pi_tas
pittas	8	60	1452	3	pittas
pizzas	16	4	698	3	pizzas
primas	10	44	1810	3	pri_mas
prions	8	43	1778	3	prio_ns
priors	8	39	1448	3	prio_rs
proas	7	50	2880	3	pro_as
psoas	7	50	1298	3	pso_as
pujas	14	55	1332	3	_pujas
quotas	15	33	943	3	quotas
ragas	6	53	2606	3	r_agas
raias	5	46	3112	3	r_aias
raitas	6	44	1767	3	raitas
raja	11	79	1868	3	r_aja_
rajah	15	57	1142	3	r_ajah
rajahs	16	49	766	3	r_ajahs
rajes	12	50	2278	3	r_ajes
ramonas	9	3	1109	3	ramonas
ras	3	75	7539	3	r___as
rayas	8	59	2205	3	r_ayas
reatas	6	40	2101	3	reatas
redias	7	45	2360	3	redias
redowas	11	3	839	3	redowas
remoras	9	3	1407	3	remoras
reoils	6	45	1687	3	reoils
rheas	8	48	1695	3	r_heas
rhombs	13	33	649	3	rhombs
rhos	7	63	1906	3	rho__s
ria	3	67	4550	3	ri__a_
rial	4	59	3809	3	ri__al
rials	5	50	2667	3	ri_als
riata	5	46	1802	3	riata_
ribes	7	55	3017	3	ri_bes
riboses	9	3	1044	3	riboses
ribs	6	58	3302	3	ri__bs
ricers	8	41	2099	3	ricers
rices	7	55	3615	3	ri_ces
riches	11	50	2208	3	riches
ricins	8	36	1870	3	ricins
ricks	11	51	2613	3	ri_cks
ricottas	10	4	446	3	ricottas
ricrac	10	3	701	3	ricrac
ricracs	11	3	636	3	ricracs
rictal	8	31	1318	3	rictal
rictus	8	37	919	3	rictus
riders	7	41	2390	3	riders
rides	6	61	4081	3	ri_des
ridges	8	58	1700	3	ridges
rids	5	65	3954	3	ri__ds
riels	5	51	2133	3	ri_els
riffs	11	51	1461	3	ri_ffs
rifles	9	42	1770	3	rifles
rifs	7	49	2900	3	ri__fs
rifts	8	57	1864	3	ri_fts
rights	10	40	1933	3	rights
rigors	7	28	1371	3	rigors
rigours	8	20	700	3	rigours
rigs	5	51	3759	3	ri__gs
riles	5	53	4364	3	ri_les
rilles	6	47	2550	3	rilles
rills	5	50	3271	3	ri_lls
rimers	8	45	2255	3	rimers
rimes	7	56	3454	3	ri_mes
rimous	8	3	1191	3	rimous
rims	6	59	3630	3	ri__ms
rinds	6	48	2614	3	ri_nds
rings	6	50	2917	3	ri_ngs
rinks	9	48	2710	3	ri_nks
rins	4	61	5319	3	ri__ns
rinses	6	47	2038	3	rinses
riot	4	59	4721	3	rio__t
rioted	7	34	1637	3	rioted
rioter	6	48	1728	3	rioter
rioters	7	36	1551	3	rioters
riotous	7	3	986	3	riotous
ripens	8	50	1217	3	ripens
ripes	7	54	3577	3	ri_pes
ripoffs	15	4	338	3	ripoffs
riposts	9	27	940	3	riposts
riprap	10	5	551	3	riprap
ripraps	11	3	494	3	ripraps
rips	6	62	3743	3	ri__ps
ripsaw	11	3	428	3	ripsaw
ripsaws	12	4	382	3	ripsaws
risers	6	46	2478	3	risers
rises	5	52	4404	3	ri_ses
rishis	9	3	1245	3	rishis
risks	9	49	1706	3	ri_sks
ristras	7	3	1156	3	ristras
risus	5	42	1639	3	ri_sus
rites	5	44	4255	3	ri_tes
ritual	6	3	1062	3	ritual
rituals	7	3	835	3	rituals
ritzes	15	48	1294	3	ritzes
rival	8	52	1650	3	ri_val
rivals	9	42	1318	3	rivals
rivers	9	46	2654	3	rivers
rives	8	53	3600	3	ri_ves
rivets	9	44	1711	3	rivets
riyal	8	44	1343	3	ri_yal
riyals	9	41	1108	3	riyals
road	5	63	3211	3	r_o_ad
roads	6	65	2362	3	r_oads
roam	6	71	3241	3	r_o_am
roams	7	49	1961	3	r_oams
roan	4	72	3420	3	r_o_an
roans	5	49	2644	3	r_oans
roar	4	63	2857	3	r_o_ar
roars	5	56	2224	3	r_oars
roast	5	62	3014	3	r_o_ast
robes	7	51	3330	3	r_obes
robs	6	58	3787	3	r_o_bs
rocks	11	46	2641	3	r_ocks
rocs	6	55	3366	3	r_o_cs
rodes	6	140	3908	3	r_odes
rods	5	64	4206	3	r_o_ds
roes	4	59	5413	3	r_o_es
roils	5	48	2679	3	r_oils
roles	5	67	4798	3	r_oles
rolfs	8	48	1712	3	r_olfs
rolls	5	53	2623	3	r_olls
roman	7	54	2482	3	r_oman
romans	8	46	2024	3	r_omans
romps	9	46	1754	3	r_omps
roms	6	70	3896	3	r_o_ms
roods	6	51	2528	3	r_oods
roofs	8	53	2115	3	r_oofs
rooks	9	53	2504	3	r_ooks
rooms	7	53	2468	3	r_ooms
rooses	6	55	2623	3	rooses
roosts	6	49	1632	3	roosts
roots	5	59	3367	3	r_oots
ropes	7	59	4006	3	r_opes
roses	5	64	4577	3	r_oses
rota	4	58	3434	3	r_ota_
rotes	5	61	4390	3	r_otes
rotis	5	63	2705	3	r_otis
rotls	5	56	2016	3	r_otls
rotos	5	60	2788	3	r_otos
rots	4	64	5409	3	r_o_ts
roues	5	60	3935	3	r_oues
roups	7	51	1890	3	r_oups
routs	5	71	3341	3	r_outs
roves	8	48	3448	3	r_oves
rowan	8	54	1873	3	r_owan
rowans	9	57	1534	3	r_owans
rows	7	59	4175	3	r_o_ws
royal	8	50	1470	3	r_oyal
royals	9	37	1126	3	r_oyals
ruanas	6	3	1126	3	ruanas
rugolas	8	3	637	3	rugolas
rugosas	8	4	497	3	rugosas
rumbas	10	25	1201	3	rumbas
ryas	7	72	2461	3	r__yas
ryokan	13	5	375	3	ryokan
ryokans	14	4	329	3	ryokans
ryots	8	53	1378	3	ryo_ts
shojis	16	34	848	3	shojis
sigmas	9	41	1136	3	sigmas
sikas	9	46	1702	3	si_kas
silvas	9	29	1218	3	silvas
simas	7	57	2755	3	si_mas
sirras	6	38	1486	3	sirras
slojds	14	34	547	3	slojds
sobas	7	44	2425	3	_sobas
socas	7	40	2618	3	_socas
sodas	6	41	2354	3	_sodas
sofas	8	53	2071	3	_sofas
soja	11	56	1951	3	_soja_
somas	7	60	3037	3	_somas
soras	5	50	4101	3	_soras
soyas	8	45	2091	3	_soyas
stoas	5	51	2602	3	sto_as
stomas	8	48	1632	3	stomas
thujas	16	3	443	3	thujas
tiaras	6	3	1455	3	tiaras
tibias	8	3	995	3	tibias
tikkas	9	3	452	3	tikkas
tineas	6	46	1648	3	tineas
toeas	5	57	2642	3	_toeas
togas	6	78	2300	3	_togas
tolas	5	45	3277	3	_tolas
toras	5	55	4037	3	_toras
triodes	8	40	1250	3	triodes
triols	6	61	1780	3	trio_ls
trios	5	55	2809	3	trio__s
trioses	7	50	1565	3	trioses
tritomas	10	4	803	3	tritomas
troikas	11	3	503	3	troikas
tronas	6	38	1690	3	tronas
variolas	11	6	853	3	variolas
vigas	9	48	1788	3	vi_gas
vigias	10	41	1089	3	vigias
villas	9	61	1726	3	villas
vinas	8	51	2634	3	vi_nas
vincas	11	39	1245	3	vincas
viola	8	59	1554	3	viola_
viols	8	61	1810	3	vio_ls
virgas	10	4	888	3	virgas
visas	8	43	1765	3	vi_sas
vistas	9	45	1327	3	vistas
vivas	11	48	1502	3	vi_vas
wiccas	13	3	654	3	wiccas
yogas	9	66	1560	3	_yogas
zoeas	14	58	1561	3	_zoeas

Search took 7 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	112716	0.140	1276364.3
2	DLD Change Limit	112716	347	5.813	19390.3
3	Display Results	347	347	0.110	3154.5
	(SQL Overall)	178691	347	6.063	29472.4