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

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

310 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
arnica	8	3	1044	(None)
arnicas	9	3	954	1	arnicas
alnico	8	7	794	2	alnico
amnia	7	59	1864	2	amni_a
amnic	9	55	1624	2	amnic_
anima	7	46	2007	2	a_nima
arabica	11	4	728	2	arabica
areca	7	56	1863	2	ar_eca
areic	7	32	1939	2	areic_
aria	4	62	4542	2	ar_i_a
armonica	12	7	686	2	armonica
arriba	8	6	768	2	arriba
erica	7	3	1654	2	er_ica
tunica	8	37	981	2	tunica
abaca	9	51	1804	3	a_baca
acacia	10	3	1135	3	acacia
acinic	10	47	1354	3	acinic_
acmic	11	3	1233	3	acmic_
acronic	11	28	1469	3	acronic_
acronical	13	4	783	3	acronical
addict	10	7	1120	3	addict
adnexa	14	3	367	3	adnexa
advice	12	10	788	3	advice
aecia	7	38	1928	3	aeci_a
aeonic	8	35	1704	3	aeonic_
agita	6	3	1542	3	a_gita
agnize	16	32	956	3	agnize
agonic	9	35	1514	3	agonic_
agria	6	55	1714	3	agri_a
airsick	13	9	533	3	airsick
ajiva	15	8	680	3	a_jiva
aliya	8	37	1348	3	a_liya
alnicos	9	8	553	3	alnicos
alpaca	10	4	738	3	alpaca
amanita	9	3	1045	3	amanita
amia	6	68	3690	3	a_mi_a
amice	9	61	2287	3	a_mice
amici	9	42	1739	3	a_mici
amiga	8	55	1481	3	a_miga
aminic	10	44	1351	3	aminic_
amnio	7	52	1805	3	amni_o
amnion	8	48	1205	3	amnion
amnios	8	49	1252	3	amnios
amrita	8	4	1113	3	amrita
ana	3	95	5983	3	a_n__a
anga	5	68	3135	3	a_n_ga
angina	7	4	1313	3	angina
ani	3	77	5118	3	a_ni__
anil	4	64	3743	3	a_ni_l
anile	5	46	3446	3	a_nile
anils	5	63	2672	3	a_nils
animal	8	50	1625	3	a_nimal
animas	8	44	1872	3	a_nimas
anime	7	54	2320	3	a_nime
animi	7	40	1666	3	a_nimi
anion	5	50	2881	3	a_nion
anis	4	57	4646	3	a_ni_s
anise	5	51	2970	3	a_nise
anna	4	55	2901	3	a_n_na
annona	6	4	887	3	annona
anoa	4	56	3447	3	a_n_oa
ansa	4	59	2777	3	a_n_sa
anta	4	68	3958	3	a_n_ta
antic	7	57	2886	3	antic_
anticar	9	3	1266	3	anticar
antick	12	48	1458	3	antick
antics	8	46	2145	3	antics
antra	5	65	2192	3	a_ntra
aortic	8	3	1661	3	aortic_
apical	10	9	1390	3	a_pical
apnea	7	34	1341	3	apn_ea
apneic	10	7	862	3	apneic_
apnoea	8	6	709	3	apnoea
arabic	10	3	1273	3	arabic_
arabicas	12	4	719	3	arabicas
arc	5	102	5090	3	ar__c_
arcana	8	9	1258	3	arcana
arch	9	86	2844	3	ar__ch
arcing	9	58	1964	3	arcing
arco	6	83	3154	3	ar__co
arcs	6	78	3478	3	ar__cs
arctic	10	3	1351	3	arctic_
arctics	11	3	895	3	arctics
area	4	58	4339	3	ar__ea
arecas	8	48	1744	3	ar_ecas
arena	5	53	2381	3	ar_ena
arenite	7	10	1771	3	arenite
areola	6	8	1367	3	areola
arepa	7	56	1556	3	ar_epa
argala	7	47	1267	3	argala
argil	6	51	1688	3	argi_l
argils	7	52	1362	3	argils
arias	5	54	3802	3	ar_ias
arid	5	76	4271	3	ar_i_d
ariel	5	52	2897	3	ar_iel
aril	4	58	4302	3	ar_i_l
arils	5	87	3220	3	ar_ils
arise	5	64	3643	3	ar_ise
arista	6	4	1529	3	arista
armada	9	3	878	3	armada
armies	8	51	2369	3	armies
armilla	9	3	699	3	armilla
arming	9	47	1980	3	arming
armonicas	13	10	612	3	armonicas
aroid	6	54	2834	3	aroi_d
aroids	7	51	1822	3	aroids
aroint	6	3	2815	3	aroint
aroma	7	12	2014	3	ar_oma
arrack	12	11	1025	3	arrack
arris	5	68	2468	3	arri_s
arrival	10	3	756	3	arrival
arrive	9	13	1179	3	arrive
arroba	8	9	866	3	arroba
arsenic	9	3	932	3	arsenic_
arsenical	11	4	557	3	arsenical
arsenics	10	5	676	3	arsenics
arsine	6	40	2104	3	arsine
arsino	6	41	1351	3	arsino
arsis	5	57	2242	3	arsi_s
article	9	3	1092	3	article
artier	6	34	1973	3	artier
artily	9	28	1471	3	artily
artisan	7	5	946	3	artisan
artist	6	41	2554	3	artist
asdic	8	38	1409	3	asdic_
asdics	9	43	986	3	asdics
aspic	9	51	1473	3	aspic_
aspics	10	42	1156	3	aspics
atonia	6	38	1651	3	atoni_a
atonic	8	34	2047	3	atonic_
atonics	9	36	1371	3	atonics
atria	5	60	2234	3	atri_a
attic	7	56	1835	3	attic_
attics	8	44	1328	3	attics
aulic	7	44	2024	3	aulic_
auric	7	45	2173	3	auric_
awning	10	50	1339	3	awning
axenic	15	42	1000	3	axenic_
axonic	15	43	1272	3	axonic_
azoic	16	29	1206	3	azoic_
azonic	17	55	1315	3	azonic_
barbican	14	4	534	3	barbican
barca	9	13	1943	3	bar__ca
bardic	11	3	1292	3	bardic_
baric	9	61	2569	3	bar_ic_
barnier	9	32	1367	3	barnier
barning	10	43	2035	3	barning
bonita	8	3	1294	3	bonita
brick	13	46	1815	3	br_ick
cardia	9	9	1637	3	cardi_a
cardiac	12	7	881	3	cardiac
carina	8	43	2532	3	car_ina
carioca	11	3	968	3	carioca
carnie	8	44	2109	3	carni_e
carnies	9	41	2396	3	carnies
carnify	15	5	588	3	carnify
carnival	13	4	561	3	carnival
carsick	15	3	634	3	carsick
chica	12	58	1826	3	_chica
cnida	8	7	895	3	_cnida
conic	9	53	2979	3	conic_
conical	11	3	1620	3	conical
conics	10	39	2059	3	conics
cornice	11	6	1293	3	cornice
crania	8	24	1843	3	crani_a
crick	13	51	1875	3	cr_ick
cynic	12	47	1242	3	cynic_
cynical	14	3	787	3	cynical
cynics	13	37	736	3	cynics
daric	8	56	2311	3	dar_ic_
darics	9	43	1411	3	dar_ics
darning	9	38	1733	3	darning
dornick	14	3	527	3	dornick
dreich	12	37	772	3	dreich
earning	8	34	1821	3	earning
enrich	11	3	894	3	enrich
ericas	8	3	1546	3	er_icas
erotica	9	28	1151	3	erotica
farcical	15	4	695	3	farcical
farina	9	46	1823	3	far_ina
farinha	13	35	706	3	farinha
finca	10	47	1450	3	fin_ca
finical	12	3	969	3	finical
formica	14	3	644	3	formica
fornical	13	4	779	3	fornical
gallica	10	4	746	3	gallica
garlic	9	3	1004	3	garlic_
garlics	10	3	801	3	garlics
garni	6	3	1570	3	garni__
garnish	11	16	1084	3	garnish
genic	8	51	1939	3	genic_
gonia	6	41	1753	3	goni_a
granita	8	21	1130	3	granita
grinch	12	3	848	3	grinch
gringa	8	3	855	3	gringa
haniwa	12	3	674	3	haniwa
harmonica	16	10	575	3	harmonica
hernia	9	3	1229	3	herni_a
inia	4	50	2470	3	_ini_a
ionic	7	46	2266	3	ionic_
ionics	8	42	1448	3	ionics
irenic	8	3	1110	3	irenic_
irenical	10	4	855	3	irenical
irenics	9	3	783	3	irenics
ironic	8	3	1377	3	ironic_
ironical	10	4	996	3	ironical
japonica	19	11	403	3	japonica
jarina	13	40	1406	3	jar_ina
kaonic	12	3	876	3	kaonic_
karmic	14	3	811	3	karmic_
lexica	15	3	610	3	lexica
lorica	8	3	1044	3	lorica
mania	7	56	3415	3	mani_a
maniac	10	39	1797	3	maniac
manic	9	46	2944	3	manic_
manics	10	39	1993	3	manics
manila	8	45	1830	3	manila
manioca	11	35	894	3	manioca
maraca	10	3	1415	3	mar_aca
marasca	11	3	682	3	marasca
maria	7	50	3288	3	mar_i_a
marina	8	46	2341	3	mar_ina
mica	8	64	2825	3	__mica
minicab	13	17	717	3	minicab
minicam	13	11	1006	3	minicam
minicar	11	10	932	3	minicar
minima	10	55	1265	3	minima
modica	11	3	1006	3	modica
myrica	13	3	683	3	myrica
naric	7	68	2417	3	nar_ic_
nicad	8	3	1261	3	__nicad
nice	6	55	3471	3	__nice
nick	10	66	2760	3	__nick
nipa	6	94	2163	3	__nipa
orca	6	55	2277	3	or__ca
orgiac	9	3	499	3	orgiac
orgic	8	3	1182	3	orgic_
ornis	5	46	1677	3	orni_s
orrice	8	14	1016	3	orrice
panic	9	39	2390	3	panic_
panics	10	38	1536	3	panics
paprica	13	3	700	3	paprica
pareira	9	3	753	3	pareira
partita	9	3	1086	3	partita
pica	8	58	3149	3	__pica
plica	9	6	1337	3	_plica
price	9	37	2541	3	pr_ice
prick	13	43	1750	3	pr_ick
pricy	12	48	1456	3	pr_icy
prima	9	50	1934	3	pr_ima
prince	10	41	1476	3	prince
rabic	9	38	1740	3	rabic_
radical	10	33	1279	3	radical
raia	4	66	3838	3	_rai_a
raita	5	46	2307	3	_raita
rance	7	50	2851	3	ran_ce
ranch	10	50	1979	3	ran_ch
rancid	9	5	1386	3	rancid
rani	4	66	4011	3	rani__
ranid	6	64	2933	3	rani_d
ranids	7	51	1870	3	ranids
ranis	5	52	3583	3	rani_s
ranula	6	3	1181	3	ranula
ria	3	67	4550	3	_r_i_a
rice	6	49	4291	3	_r_ice
rich	9	70	2554	3	_r_ich
rick	10	73	3465	3	_r_ick
runic	7	36	1577	3	runic_
sarcina	9	3	1073	3	sarcina
seneca	8	3	979	3	seneca
silica	8	3	1124	3	silica
snick	11	44	1601	3	_snick
sonic	7	52	2529	3	sonic_
sonics	8	43	1563	3	sonics
spica	9	47	1794	3	_spica
taenia	6	3	1319	3	taeni_a
tannic	8	28	1147	3	tannic_
tarnish	10	16	1187	3	tarnish
tarsia	6	55	1427	3	tarsi_a
tenia	5	53	2448	3	teni_a
tonic	7	47	2765	3	tonic_
tonics	8	36	1786	3	tonics
triac	7	41	1637	3	tr_iac
trice	7	51	2749	3	tr_ice
trick	11	54	2069	3	tr_ick
troika	10	3	549	3	troika
tunic	7	40	1822	3	tunic_
tunicae	9	32	814	3	tunicae
tunics	8	38	1126	3	tunics
uncia	7	50	1516	3	_uncia
urania	6	25	1612	3	urani_a
uranic	8	23	1518	3	uranic_
urbia	7	3	1114	3	urbi_a
ureic	7	45	1446	3	ureic_
uric	6	36	2494	3	ur_ic_
varia	8	58	2420	3	var_i_a
varna	8	45	1617	3	varn__a
varnish	13	16	953	3	varnish
veronica	13	4	673	3	veronica
vesica	11	15	791	3	vesica
vinca	10	53	1516	3	vin_ca
vinic	10	3	1497	3	vinic_
vomica	13	3	638	3	vomica
warning	11	37	1709	3	warning
wrick	14	40	1339	3	wr_ick
xenia	12	48	1477	3	xeni_a
xenic	14	41	1464	3	xenic_
yarning	11	35	1295	3	yarning
yonic	10	59	2084	3	yonic_
zariba	17	3	698	3	zar_iba

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.373	479064.3
2	DLD Change Limit	112716	310	5.783	19490.9
3	Display Results	310	310	0.093	3333.3
	(SQL Overall)	178691	310	6.249	28595.1