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

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

451 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
rioja	12	3	630	(None)
riojas	13	3	581	1	riojas
biota	7	45	1682	2	biota
iota	4	51	2783	2	_iota
ninja	12	5	809	2	ninja
raja	11	79	1868	2	r_aja
ria	3	67	4550	2	ri__a
riata	5	46	1802	2	riata
riot	4	59	4721	2	rio_t
riots	5	49	2201	2	riots
rota	4	58	3434	2	r_ota
soja	11	56	1951	2	_soja
viola	8	59	1554	2	viola
aboma	9	11	1460	3	aboma
agora	6	9	1433	3	agora
aioli	5	3	1831	3	aioli
aloha	8	5	1362	3	aloha
anoa	4	56	3447	3	ano_a
areola	6	8	1367	3	areola
aria	4	62	4542	3	ari__a
ariose	6	48	1872	3	ariose
ariosi	6	43	1303	3	ariosi
arioso	6	43	1240	3	arioso
arista	6	4	1529	3	arista
aroma	7	12	2014	3	aroma
arroba	8	9	866	3	arroba
bijou	14	5	879	3	bijou
bima	8	67	2383	3	bi_ma
bio	5	78	4608	3	bio__
biog	7	61	2232	3	bio_g
biogas	9	43	1091	3	biogas
biogs	8	50	1611	3	biogs
biome	9	49	1699	3	biome
biont	7	7	2716	3	biont
bios	6	63	3532	3	bio_s
biotas	8	43	1392	3	biotas
boa	5	69	5403	3	_bo_a
bola	6	60	3556	3	_bola
bora	6	61	4163	3	_bora
bota	6	62	3650	3	_bota
brio	6	54	3249	3	brio__
briony	11	4	904	3	briony
brios	7	47	2572	3	brio_s
carioca	11	3	968	3	carioca
chola	10	47	1803	3	chola
cilia	7	30	1676	3	cilia
cion	6	133	3091	3	cio_n
cions	7	52	2285	3	cions
circa	9	3	1140	3	circa
citola	8	3	839	3	citola
coca	8	80	3064	3	_coca
coda	7	70	2934	3	_coda
cola	6	65	4139	3	_cola
coma	8	71	3485	3	_coma
coxa	13	69	2296	3	_coxa
crissa	8	3	762	3	crissa
crista	8	3	1180	3	crista
curiosa	9	34	664	3	curiosa
dicta	8	49	1563	3	dicta
diode	7	47	1611	3	diode
diol	5	73	2913	3	dio_l
diols	6	55	2101	3	diols
dioxan	14	6	577	3	dioxan
dita	5	60	3252	3	di_ta
diva	8	59	2088	3	di_va
dojo	12	60	1614	3	_dojo
dona	5	55	2963	3	_dona
dopa	7	72	2090	3	_dopa
eidola	7	3	768	3	eidola
erica	7	3	1654	3	eri_ca
feijoa	16	4	222	3	feijoa
fila	7	47	2913	3	fi_la
finca	10	47	1450	3	finca
fiord	9	43	1334	3	fiord
flora	8	53	1710	3	flora
flota	8	53	1564	3	flota
fora	7	59	3739	3	_fora
frijol	16	3	412	3	frijol
ganja	13	14	1000	3	ganja
giga	6	67	2094	3	gi_ga
glioma	9	3	595	3	glioma
goa	4	73	4380	3	_go_a
gringa	8	3	855	3	gringa
griot	6	53	2841	3	grio_t
griots	7	47	1364	3	griots
gyoza	18	3	611	3	gyoza
hijab	17	3	680	3	hi_jab
hijra	15	3	564	3	hijra
hila	7	62	2835	3	hi_la
hooka	12	55	1390	3	hooka
hora	7	61	3656	3	_hora
hoya	10	74	1837	3	_hoya
idea	5	91	2277	3	_idea
ilea	4	59	3146	3	_ilea
ilia	4	60	2682	3	_ilia
ilka	8	72	1515	3	_ilka
inia	4	50	2470	3	_inia
ion	3	60	5102	3	_io_n
ions	4	67	3785	3	_ions
iotas	5	48	2111	3	_iotas
iroko	9	3	966	3	iroko
iron	4	67	2846	3	iro_n
irone	5	51	2636	3	irone
irons	5	53	2413	3	irons
irony	8	50	1590	3	irony
isba	6	13	1088	3	_isba
ixia	11	57	1321	3	_ixia
ixora	12	3	691	3	ixora
jota	11	64	2362	3	_jota
kibla	11	3	983	3	kibla
kina	8	56	3200	3	ki_na
kiosk	8	3	623	3	kiosk
kiva	11	65	1641	3	ki_va
koa	7	67	3777	3	_ko_a
koji	15	56	1112	3	_koji
kola	8	51	2496	3	_kola
kora	8	64	3155	3	_kora
krona	9	36	1179	3	krona
liana	5	39	1589	3	liana
libra	7	47	1242	3	libra
lima	6	57	3413	3	li_ma
limba	9	54	1498	3	limba
limpa	9	70	1446	3	limpa
linga	6	68	2082	3	linga
lion	4	63	3444	3	lio_n
lions	5	59	2321	3	lions
lipa	6	84	2592	3	li_pa
lipoma	10	4	675	3	lipoma
lira	4	69	2868	3	li_ra
loca	6	55	2768	3	_loca
loofa	8	59	1281	3	loofa
lota	4	72	3350	3	_lota
mica	8	64	2825	3	mi_ca
micra	9	62	1497	3	micra
mikra	11	46	1031	3	mikra
milia	7	27	1957	3	milia
milpa	9	21	1140	3	milpa
mimosa	10	3	636	3	mimosa
mina	6	51	3692	3	mi_na
mirza	16	4	1044	3	mirza
moa	5	72	4918	3	_mo_a
moira	7	10	1202	3	moira
mojo	13	69	1722	3	_mojo
mola	6	60	3563	3	_mola
moola	7	51	1703	3	moola
mora	6	66	4127	3	_mora
moxa	13	69	1774	3	_moxa
myoma	12	3	927	3	myoma
ninjas	13	8	630	3	ninjas
nipa	6	94	2163	3	ni_pa
noma	6	75	2946	3	_noma
nona	4	69	2906	3	_nona
nota	4	68	3077	3	_nota
nova	7	65	1895	3	_nova
oba	5	75	3155	3	__oba
oca	5	67	3173	3	__oca
oda	4	81	3304	3	__oda
oidia	6	3	1495	3	oidia
oka	7	69	2680	3	__oka
ora	3	72	5083	3	__ora
oriole	6	8	1429	3	oriole
orisha	9	3	677	3	orisha
ova	6	68	2379	3	__ova
pia	5	68	4803	3	pi__a
pica	8	58	3149	3	pi_ca
pieta	7	54	2175	3	pieta
pika	10	63	2295	3	pi_ka
pilea	7	51	2395	3	pilea
pima	8	54	2865	3	pi_ma
pina	6	58	4263	3	pi_na
pinna	7	53	2018	3	pinna
pinta	7	57	2705	3	pinta
pion	6	72	3529	3	pio_n
pions	7	58	2639	3	pions
pious	7	46	2127	3	pious
pita	6	54	3643	3	pi_ta
pitta	7	50	1869	3	pitta
pizza	15	3	818	3	pizza
prima	9	50	1934	3	pri_ma
prion	7	51	1999	3	prio_n
prions	8	43	1778	3	prions
prior	7	43	1617	3	prio_r
priors	8	39	1448	3	priors
priory	11	41	1026	3	priory
proa	6	62	2996	3	pro_a
puja	13	57	1492	3	_puja
quota	14	51	1196	3	quota
raga	5	59	3081	3	r_aga
raia	4	66	3838	3	r_aia
raita	5	46	2307	3	raita
raj	10	57	4022	3	r_aj_
rajah	15	57	1142	3	r_ajah
rajas	12	73	1772	3	r_ajas
ramona	8	4	1241	3	ramona
raya	7	52	2482	3	r_aya
reata	5	42	2539	3	reata
recta	7	42	2026	3	recta
redia	6	55	2448	3	redia
redowa	10	3	845	3	redowa
regma	8	46	1233	3	regma
regna	6	46	1481	3	regna
remora	8	4	1459	3	remora
reoil	5	53	2118	3	reoil
retia	5	53	2611	3	retia
rhea	7	50	1743	3	r_hea
rhizoma	21	4	328	3	rhizoma
rho	6	59	2483	3	rho__
rhomb	12	39	980	3	rhomb
rhos	7	63	1906	3	rho_s
rhyta	11	3	508	3	rhyta
rial	4	59	3809	3	ri_al
rials	5	50	2667	3	rials
riant	5	58	3315	3	riant
rias	4	55	4059	3	ri_as
riatas	6	39	1509	3	riatas
rib	5	68	4803	3	ri__b
ribby	12	41	968	3	ribby
ribes	7	55	3017	3	ribes
ribose	8	3	989	3	ribose
ribs	6	58	3302	3	ri_bs
rice	6	49	4291	3	ri_ce
riced	8	58	2554	3	riced
ricer	7	47	2661	3	ricer
rices	7	55	3615	3	rices
rich	9	70	2554	3	ri_ch
ricin	7	46	2021	3	ricin
rick	10	73	3465	3	ri_ck
ricks	11	51	2613	3	ricks
ricotta	9	5	543	3	ricotta
ricrac	10	3	701	3	ricrac
rictal	8	31	1319	3	rictal
rid	4	67	5463	3	ri__d
ride	5	59	4513	3	ri_de
rider	6	52	3130	3	rider
rides	6	61	4081	3	rides
ridge	7	50	1867	3	ridge
ridgy	10	41	1064	3	ridgy
rids	5	65	3955	3	ri_ds
riel	4	64	3238	3	ri_el
riels	5	51	2133	3	riels
rif	6	59	5156	3	ri__f
rife	7	46	3232	3	ri_fe
rifer	8	47	2198	3	rifer
riff	10	44	3010	3	ri_ff
riffs	11	51	1461	3	riffs
rifle	8	55	1833	3	rifle
rifs	7	49	2900	3	ri_fs
rift	7	56	4233	3	ri_ft
rifts	8	57	1864	3	rifts
rig	4	67	4812	3	ri__g
right	9	44	3050	3	right
rigid	7	9	1389	3	rigid
rigor	6	27	1405	3	rigor
rigors	7	28	1371	3	rigors
rigour	7	25	802	3	rigour
rigs	5	51	3759	3	ri_gs
rile	4	56	5053	3	ri_le
riled	6	58	3325	3	riled
riles	5	53	4364	3	riles
riley	8	44	2058	3	riley
rill	4	51	4090	3	ri_ll
rille	5	57	2873	3	rille
rills	5	50	3271	3	rills
rim	5	60	5227	3	ri__m
rime	6	51	3888	3	ri_me
rimed	8	48	2637	3	rimed
rimer	7	54	2924	3	rimer
rimes	7	56	3454	3	rimes
rimose	8	3	1059	3	rimose
rimous	8	3	1191	3	rimous
rims	6	59	3630	3	ri_ms
rimy	9	66	2128	3	ri_my
rin	3	66	6318	3	ri__n
rind	5	65	3560	3	ri_nd
rinds	6	48	2614	3	rinds
rindy	9	57	1739	3	rindy
ring	5	65	4115	3	ri_ng
rings	6	50	2917	3	rings
rink	8	77	3699	3	ri_nk
rinks	9	48	2710	3	rinks
rins	4	61	5319	3	ri_ns
rinse	5	48	2097	3	rinse
rioted	7	34	1637	3	rioted
rioter	6	48	1728	3	rioter
rip	5	68	5130	3	ri__p
ripe	6	60	3892	3	ri_pe
riped	8	52	2643	3	riped
ripen	7	56	1926	3	ripen
riper	7	43	2840	3	riper
ripes	7	54	3577	3	ripes
ripoff	14	3	643	3	ripoff
ripost	8	36	1500	3	ripost
riprap	10	5	551	3	riprap
rips	6	62	3743	3	ri_ps
ripsaw	11	3	428	3	ripsaw
rise	4	59	4523	3	ri_se
risen	5	46	2188	3	risen
riser	5	54	3105	3	riser
rises	5	52	4404	3	rises
rishi	8	3	1125	3	rishi
risk	8	57	2410	3	ri_sk
risks	9	49	1706	3	risks
risky	12	63	1152	3	risky
ristra	6	3	1071	3	ristra
risus	5	42	1639	3	risus
rite	4	58	4945	3	ri_te
rites	5	44	4255	3	rites
ritual	6	3	1062	3	ritual
ritz	13	51	2998	3	ri_tz
ritzy	17	56	1116	3	ritzy
rival	8	52	1650	3	rival
rive	7	55	3772	3	ri_ve
rived	9	48	2561	3	rived
riven	8	51	2162	3	riven
river	8	57	3169	3	river
rives	8	53	3600	3	rives
rivet	8	56	3636	3	rivet
riyal	8	44	1343	3	riyal
road	5	63	3211	3	r_oad
roam	6	71	3241	3	r_oam
roan	4	72	3420	3	r_oan
roar	4	63	2857	3	r_oar
rob	5	67	5430	3	r_o_b
robe	6	53	3564	3	r_obe
robs	6	58	3787	3	r_obs
roc	5	202	4325	3	r_o_c
rock	10	57	3518	3	r_ock
rocs	6	55	3366	3	r_ocs
rod	4	79	5389	3	r_o_d
rode	5	58	4430	3	r_ode
rods	5	64	4206	3	r_ods
roe	3	68	6108	3	r_o_e
roes	4	59	5414	3	r_oes
roil	4	62	3529	3	r_oil
roils	5	48	2679	3	roils
roily	8	61	2111	3	roily
role	4	58	5182	3	r_ole
rolf	7	51	3487	3	r_olf
roll	4	63	3165	3	r_oll
rom	5	98	5563	3	r_o_m
roman	7	54	2482	3	r_oman
romp	8	59	2657	3	r_omp
roms	6	70	3896	3	r_oms
rood	5	67	3300	3	r_ood
roods	6	51	2528	3	roods
roof	7	57	3883	3	r_oof
roofs	8	53	2115	3	roofs
rook	8	55	3203	3	r_ook
rooks	9	53	2504	3	rooks
rooky	12	61	1762	3	rooky
room	6	62	3508	3	r_oom
rooms	7	53	2468	3	rooms
roomy	10	71	1806	3	roomy
roose	5	61	2709	3	roose
roost	5	57	3093	3	roost
root	4	56	5592	3	r_oot
roots	5	59	3367	3	roots
rooty	8	64	2302	3	rooty
rope	6	55	4291	3	r_ope
ropy	9	63	2341	3	r_opy
rose	4	61	4890	3	r_ose
rosy	7	60	2487	3	r_osy
rot	3	72	8295	3	r_o_t
rotas	5	48	2772	3	r_otas
rote	4	62	4902	3	r_ote
roti	4	63	3293	3	r_oti
rotl	4	50	2968	3	r_otl
roto	4	59	3505	3	r_oto
rots	4	64	5409	3	r_ots
roue	4	59	4174	3	r_oue
roup	6	66	2769	3	r_oup
rout	4	61	5328	3	r_out
roux	11	74	1936	3	r_oux
rove	7	51	3698	3	r_ove
row	6	74	5367	3	r_o_w
rowan	8	54	1873	3	r_owan
rows	7	59	4175	3	r_ows
royal	8	50	1470	3	r_oyal
ruana	5	3	1242	3	ruana
ruga	5	61	2123	3	r_uga
rugola	7	3	629	3	rugola
rugosa	7	3	456	3	rugosa
rumba	9	36	1251	3	rumba
rya	6	76	2201	3	r__ya
ryokan	13	5	375	3	ryokan
ryot	7	55	2856	3	ryo_t
ryots	8	53	1378	3	ryots
shoji	15	41	996	3	shoji
sigla	6	45	1520	3	sigla
sigma	8	45	1383	3	sigma
signa	6	61	1470	3	signa
sika	8	60	2132	3	si_ka
silva	8	27	1402	3	silva
sima	6	47	3078	3	si_ma
sirra	5	44	1632	3	sirra
slojd	13	37	884	3	slojd
soba	6	49	2792	3	_soba
soca	6	63	3005	3	_soca
soda	5	63	2938	3	_soda
sofa	7	56	2560	3	_sofa
sojas	12	47	1639	3	_sojas
sola	4	55	4186	3	_sola
soma	6	56	3529	3	_soma
sora	4	57	4691	3	_sora
soya	7	57	2443	3	_soya
stoa	4	54	2591	3	sto_a
stoma	7	59	1827	3	stoma
thuja	15	3	521	3	thuja
tiara	5	3	1591	3	tiara
tibia	7	3	1240	3	tibia
tikka	8	3	557	3	tikka
tinea	5	49	2316	3	tinea
toea	4	67	3233	3	_toea
toga	5	70	2741	3	_toga
tola	4	52	3633	3	_tola
tora	4	75	4599	3	_tora
trio	4	52	3334	3	trio__
triode	7	53	1189	3	triode
triol	5	55	2136	3	trio_l
triols	6	61	1780	3	triols
trios	5	55	2809	3	trio_s
triose	6	47	1538	3	triose
tritoma	9	4	805	3	tritoma
trivia	9	3	850	3	trivia
troika	10	3	549	3	troika
trona	5	41	1895	3	trona
variola	10	6	889	3	variola
via	6	56	3624	3	vi__a
viga	8	56	2296	3	vi_ga
vigia	9	48	1327	3	vigia
villa	8	53	2123	3	villa
vina	7	63	3180	3	vi_na
vinca	10	53	1516	3	vinca
viol	7	65	2359	3	vio_l
violas	9	37	1352	3	violas
viols	8	61	1810	3	viols
virga	9	3	1025	3	virga
visa	7	63	2387	3	vi_sa
vista	8	54	1660	3	vista
vita	7	58	2852	3	vi_ta
vitta	8	50	1517	3	vitta
viva	10	61	1909	3	vi_va
voila	8	48	1394	3	voila
whoa	10	66	1520	3	who_a
wicca	12	4	725	3	wicca
wirra	8	32	1082	3	wirra
wisha	11	49	1085	3	wisha
yoga	8	74	1805	3	_yoga
zoa	12	85	2999	3	_zo_a
zoea	13	71	1842	3	_zoea
zona	13	63	2196	3	_zona

Search took 5 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	83667	0.356	501941.0
2	DLD Change Limit	83667	451	3.546	23594.8
3	Display Results	451	451	0.126	3579.4
	(SQL Overall)	178691	451	4.028	44362.2