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

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

326 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
ajivas	16	5	513	(None)
ajiva	15	8	680	1	ajiva_
agitas	7	3	1059	2	agitas
ajugas	14	3	526	2	ajugas
alias	5	58	3460	2	ali_as
aliyas	9	39	1180	2	aliyas
amias	7	58	3146	2	ami_as
amigas	9	59	1216	2	amigas
animas	8	44	1872	2	animas
arias	5	54	3802	2	ari_as
divas	9	54	1858	2	_divas
fajitas	17	3	425	2	fajitas
javas	15	59	1542	2	_javas
jives	15	48	2081	2	_jives
kivas	12	46	1473	2	_kivas
salivas	10	30	960	2	salivas
shivas	12	45	1241	2	shivas
vivas	11	48	1502	2	_vivas
aas	3	109	7539	3	a___as
abacas	10	44	1472	3	abacas
abakas	12	39	1174	3	abakas
abas	6	86	4208	3	a__bas
abayas	11	40	1170	3	abayas
abbas	9	59	1864	3	a_bbas
abides	9	47	1989	3	abides
abomas	10	11	1358	3	abomas
aboves	11	45	1284	3	aboves
acids	8	71	2100	3	aci_ds
acinar	8	3	1048	3	acinar
acinus	8	3	1125	3	acinus
actives	12	3	1152	3	actives
adieus	7	3	963	3	adieus
adios	6	58	2286	3	adi_os
adits	6	65	2371	3	adi_ts
agamas	9	74	1344	3	agamas
agas	5	59	3884	3	a__gas
agaves	10	46	1151	3	agaves
aghas	9	70	1487	3	a_ghas
agings	8	63	1267	3	agings
agios	6	59	1986	3	agi_os
agisms	9	39	939	3	agisms
agists	7	57	1317	3	agists
agita	6	3	1542	3	agita_
agmas	8	59	1987	3	a_gmas
agoras	7	6	1334	3	agoras
agrias	7	43	1539	3	agrias
ahimsa	11	3	478	3	ahimsa
ahimsas	12	3	478	3	ahimsas
ahis	7	61	3538	3	ahi__s
aides	6	53	3660	3	a_ides
aids	5	78	4635	3	a_i_ds
ails	4	56	5471	3	a_i_ls
aims	6	77	3818	3	a_i_ms
ains	4	61	5888	3	a_i_ns
airns	5	55	2103	3	a_irns
airs	4	64	4742	3	a_i_rs
airts	5	56	2634	3	a_irts
ais	3	90	8357	3	a_i__s
aits	4	63	5553	3	a_i_ts
aiver	8	57	2516	3	a_iver
aivers	9	48	2232	3	a_ivers
ajar	11	62	1770	3	aj__ar
ajowan	16	3	489	3	ajowan
ajowans	17	3	400	3	ajowans
ajuga	13	3	588	3	ajuga_
akelas	10	3	1119	3	akelas
alas	4	63	5812	3	a__las
albas	7	59	2539	3	a_lbas
alfas	8	72	1904	3	a_lfas
algas	6	56	2493	3	a_lgas
alibis	8	3	1107	3	alibis
alidad	8	3	887	3	alidad
alidads	9	3	629	3	alidads
aliens	6	56	1921	3	aliens
alifs	8	61	2126	3	ali_fs
aligns	7	53	1295	3	aligns
alines	6	57	3522	3	alines
alive	8	57	2251	3	aliv_e
aliya	8	37	1348	3	aliya_
aliyah	12	39	749	3	aliyah
aliyahs	13	39	532	3	aliyahs
aliyos	9	34	953	3	aliyos
almas	7	66	2977	3	a_lmas
alohas	9	4	1170	3	alohas
alphas	11	3	951	3	alphas
amas	6	77	4629	3	a__mas
amebas	10	3	1145	3	amebas
amia	6	68	3689	3	ami_a_
amices	10	50	1801	3	amices
amicus	10	38	999	3	amicus
amidase	10	3	672	3	amidase
amides	9	57	2266	3	amides
amids	8	56	2750	3	ami_ds
amies	7	68	3768	3	ami_es
amiga	8	55	1479	3	amiga_
amigos	9	45	1120	3	amigos
amines	8	47	2798	3	amines
amins	7	55	3431	3	ami_ns
amirs	7	59	2491	3	ami_rs
amis	6	64	4531	3	ami__s
amiss	7	58	2306	3	ami_ss
amritas	9	3	909	3	amritas
anabas	8	3	1408	3	anabas
anas	4	66	4986	3	a__nas
angas	6	58	2798	3	a_ngas
anginas	8	3	1095	3	anginas
anils	5	63	2672	3	ani_ls
anima	7	46	2007	3	anima_
animal	8	50	1625	3	animal
animals	9	41	1170	3	animals
animes	8	47	1959	3	animes
animis	8	46	1594	3	animis
animus	8	42	1161	3	animus
anions	6	41	2303	3	anions
anis	4	57	4646	3	ani__s
anises	6	48	2669	3	anises
anlas	5	56	2693	3	a_nlas
annas	5	58	2488	3	a_nnas
anoas	5	72	2649	3	a_noas
antas	5	54	3203	3	a_ntas
anvils	9	21	971	3	anvils
aortas	6	54	1778	3	aortas
apian	7	50	1833	3	api_an
apical	10	9	1390	3	apical
apicals	11	5	992	3	apicals
apices	10	49	1626	3	apices
apneas	8	32	1138	3	apneas
aquas	14	24	1261	3	a_quas
areas	5	59	3577	3	a_reas
arecas	8	48	1744	3	arecas
arenas	6	50	2199	3	arenas
arepas	8	55	1570	3	arepas
aria	4	62	4542	3	ari_a_
ariels	6	51	1937	3	ariels
arils	5	87	3220	3	ari_ls
arises	6	52	3380	3	arises
aristas	7	4	1352	3	aristas
arnicas	9	3	954	3	arnicas
aromas	8	10	1861	3	aromas
arras	5	56	2613	3	a_rras
arrival	10	3	756	3	arrival
arrivals	11	4	593	3	arrivals
arrives	10	13	1151	3	arrives
arval	8	60	1701	3	a_rval
arvos	8	60	1566	3	a_rvos
asanas	6	5	1411	3	asanas
asides	7	51	1887	3	asides
atlas	5	58	2158	3	a_tlas
atmas	7	57	2101	3	a_tmas
auras	5	59	3255	3	a_uras
ava	6	101	3932	3	a__va_
avast	8	55	1936	3	a__vast
aves	7	61	4260	3	a__ves
avgas	9	69	1213	3	a_vgas
avian	8	46	1605	3	avi_an
avians	9	37	1156	3	avians
avions	9	41	1439	3	avions
avisos	9	54	1048	3	avisos
avos	7	72	2701	3	a__vos
axial	12	45	1519	3	axi_al
axillas	14	27	896	3	axillas
axils	12	72	1750	3	axi_ls
axioms	15	40	805	3	axioms
axions	13	47	1348	3	axions
axis	11	61	2791	3	axi__s
axises	13	44	1399	3	axises
axites	13	49	1383	3	axites
ayins	8	53	2161	3	ayi_ns
azides	16	51	1380	3	azides
azines	15	55	1707	3	azines
baizas	17	38	1082	3	baizas
bias	6	47	3815	3	_bi_as
bimas	9	55	2174	3	_bimas
bravas	11	49	1332	3	bravas
camisas	11	34	1192	3	camisas
canvas	11	38	1333	3	canvas
capias	10	3	1835	3	capi_as
carinas	9	36	2238	3	carinas
caritas	9	33	1694	3	caritas
casavas	12	3	781	3	casavas
casitas	9	33	1204	3	casitas
ceibas	10	3	850	3	ceibas
chias	10	46	2551	3	chi_as
chicas	13	59	1646	3	chicas
chinas	11	51	1938	3	chinas
chives	14	43	1759	3	chives
clivias	12	6	669	3	clivias
datival	11	3	558	3	datival
datives	11	3	1007	3	datives
devas	9	62	1888	3	_devas
ditas	6	59	2367	3	_ditas
diva	8	59	2088	3	_diva_
divan	9	61	1484	3	_divan
divans	10	46	1239	3	_divans
dives	9	58	3240	3	_dives
djinns	14	4	313	3	djinns
djins	13	6	845	3	dji_ns
drives	10	51	1711	3	drives
ericas	8	3	1546	3	ericas
facias	11	34	1580	3	faci_as
fajita	16	3	592	3	fajita_
farinas	10	32	1523	3	farinas
favas	11	56	1859	3	_favas
fives	11	60	2736	3	_fives
gigas	7	54	1558	3	_gigas
gives	9	53	2487	3	_gives
glias	6	46	1849	3	gli_as
guavas	10	3	715	3	guavas
hajis	15	67	1627	3	haji__s
halvas	12	47	1417	3	halvas
hejiras	17	4	423	3	hejiras
hijras	16	3	577	3	hijras
hives	11	69	2551	3	_hives
ixias	12	48	836	3	ixi_as
jagras	14	3	846	3	jagras
jails	12	54	2294	3	jai_ls
jarinas	14	37	1218	3	jarinas
java	14	73	1664	3	_java_
jiao	11	50	1784	3	_ji_ao
jibbs	16	60	973	3	_jibbs
jibes	14	55	2032	3	_jibes
jibs	13	67	2407	3	_ji_bs
jiffs	18	57	1031	3	_jiffs
jigs	12	65	2476	3	_ji_gs
jihad	16	3	591	3	_jihad
jihads	17	3	448	3	_jihads
jills	12	51	2282	3	_jills
jilts	12	47	1741	3	_jilts
jinks	16	50	1933	3	_jinks
jinns	12	60	1384	3	_jinns
jins	11	56	3501	3	_ji_ns
jisms	14	45	800	3	_jisms
jive	14	61	2359	3	_jiv_e
jiveass	17	9	216	3	_jiveass
jived	16	51	1504	3	_jived
jiver	15	51	1905	3	_jiver
jivers	16	45	1564	3	_jivers
jivey	18	51	1187	3	_jivey
jivy	17	62	1311	3	_jiv_y
jotas	12	57	1744	3	_jotas
jubas	14	46	1422	3	_jubas
judas	13	49	1188	3	_judas
kavas	12	59	1995	3	_kavas
kinas	9	56	2691	3	_kinas
kiva	11	65	1640	3	_kiva_
knives	13	45	855	3	knives
kvas	11	70	1594	3	__kvas
lamias	8	50	2061	3	lami_as
laminas	9	36	1587	3	laminas
larvas	9	3	1023	3	larvas
latinas	7	44	1646	3	latinas
lavas	8	54	2222	3	_lavas
limas	7	56	2763	3	_limas
liras	5	60	2198	3	_liras
litas	5	49	2377	3	_litas
lives	8	61	3319	3	_lives
mafias	11	39	1357	3	mafi_as
manias	8	40	2903	3	mani_as
manilas	9	39	1587	3	manilas
marinas	9	35	1937	3	marinas
mbiras	10	7	714	3	mbiras
micas	9	68	2305	3	_micas
minas	7	54	3411	3	_minas
nairas	6	3	1277	3	nairas
naives	9	49	1422	3	naives
natives	10	3	1082	3	natives
nipas	7	71	1667	3	_nipas
nival	8	49	1577	3	_nival
novas	8	52	1536	3	_novas
obias	7	61	1685	3	obi_as
ogival	10	3	587	3	ogival
ogives	10	36	791	3	ogives
ohias	8	44	1556	3	ohi_as
olives	9	43	1395	3	olives
paisas	8	43	1749	3	paisas
pajamas	18	27	815	3	pajamas
patinas	9	63	1852	3	patinas
pias	6	65	4255	3	_pi_as
picas	9	46	2652	3	_picas
pikas	11	42	1809	3	_pikas
pimas	9	47	2510	3	_pimas
pinas	7	54	3445	3	_pinas
pitas	7	74	2767	3	_pitas
primas	10	44	1810	3	primas
raias	5	46	3112	3	rai_as
raitas	6	44	1767	3	raitas
rajas	12	73	1772	3	raj__as
reives	9	57	2304	3	reives
rias	4	55	4059	3	_ri_as
rival	8	52	1650	3	_rival
rivals	9	42	1318	3	_rivals
rives	8	53	3600	3	_rives
saigas	7	41	1429	3	saigas
salinas	7	31	1609	3	salinas
saliva	9	31	1074	3	saliva_
salvias	10	27	993	3	salvias
selvas	9	38	1291	3	selvas
shiva	11	59	1500	3	shiva_
shivah	15	48	853	3	shivah
shivahs	16	37	572	3	shivahs
shives	12	49	2141	3	shives
shivs	11	50	1880	3	shiv_s
sikas	9	46	1702	3	_sikas
silvas	9	29	1218	3	silvas
simas	7	57	2755	3	_simas
skives	13	41	1394	3	skives
spicas	10	47	1582	3	spicas
spivs	10	51	1424	3	spiv_s
swives	12	39	1518	3	swives
sylvas	12	28	817	3	sylvas
tafias	9	31	1196	3	tafi_as
taigas	7	37	1255	3	taigas
ulvas	8	45	1150	3	_ulvas
vaginas	11	29	881	3	vaginas
varias	9	50	1990	3	vari_as
vas	6	77	5577	3	___vas
vigas	9	48	1788	3	_vigas
vinas	8	51	2634	3	_vinas
visas	8	43	1765	3	_visas
viva	10	61	1909	3	_viva_
volvas	12	44	799	3	volvas
vulvas	12	38	884	3	vulvas
waives	12	37	1418	3	waives
wives	11	53	2892	3	_wives
zamias	17	42	1292	3	zami_as
zaribas	18	3	604	3	zaribas

Search took 8 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.283	631417.0
2	DLD Change Limit	112716	326	7.360	15314.7
3	Display Results	326	326	0.106	3075.5
	(SQL Overall)	178691	326	7.749	23059.9