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

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

371 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
nectar	8	3	885	(None)
nectars	9	3	846	1	nectars
nectary	12	4	622	1	nectary
hectare	12	3	846	2	hectare
hector	11	33	1265	2	hector
lector	8	35	1498	2	lector
near	4	52	3650	2	ne__ar
neater	6	44	2431	2	neater
necker	12	40	1279	2	necker
nester	6	41	2418	2	nester
nestor	6	37	1341	2	nestor
netter	6	37	2202	2	netter
neuter	6	37	1379	2	neuter
recta	7	42	2026	2	recta_
rectal	8	44	1813	2	rectal
rector	8	40	1974	2	rector
secpar	10	3	792	2	secpar
sectary	12	3	827	2	sectary
sector	8	34	1592	2	sector
tecta	7	42	1552	2	tecta_
tectal	8	37	1325	2	tectal
vector	11	32	1206	2	vector
aceta	7	40	1735	3	aceta_
acetal	8	43	1490	3	acetal
acta	6	95	2480	3	_acta_
actor	7	11	1607	3	_actor
aecia	7	38	1928	3	aecia_
aecial	8	48	1731	3	aecial
altar	5	55	2064	3	_altar
anear	5	54	2032	3	ane__ar
attar	5	65	1669	3	_attar
avatar	9	3	752	3	avatar
bear	6	68	4464	3	be__ar
beater	8	47	2939	3	beater
becap	11	43	1505	3	bec_ap
becharm	16	3	684	3	becharm
beggar	10	32	822	3	beggar
belter	8	47	2096	3	belter
bestir	8	3	1116	3	bestir
beta	6	62	3413	3	be_ta_
betas	7	55	2876	3	be_tas
betta	7	49	1684	3	betta_
bettas	8	49	1392	3	bettas
better	8	47	2370	3	better
bettor	8	36	1222	3	bettor
bezoar	17	3	691	3	bezoar
car	5	91	6556	3	__c_ar
ceca	8	48	2078	3	cec_a_
cecal	9	46	1911	3	cec_al
cedar	8	40	1432	3	ce_dar
cellar	8	45	1498	3	cellar
centai	8	48	1478	3	centai
cental	8	44	2096	3	cental
centare	9	31	1370	3	centare
centas	8	50	2070	3	centas
centaur	9	3	578	3	centaur
center	8	44	2141	3	center
centra	8	41	1388	3	centra
cesta	7	54	1948	3	cesta_
cestas	8	50	1854	3	cestas
char	9	51	3215	3	__char
costar	8	55	1861	3	costar
cottar	8	46	1381	3	cottar
czar	15	60	1313	3	__czar
dear	5	53	4360	3	de__ar
debar	8	55	1786	3	de_bar
debtor	9	3	833	3	debtor
decaf	11	49	1944	3	dec_af
decal	8	55	2323	3	dec_al
decare	9	39	1915	3	dec_are
decay	11	47	1848	3	dec_ay
deciare	10	7	1066	3	deciare
decker	13	52	1599	3	decker
declare	10	4	1122	3	declare
declaw	12	6	670	3	declaw
decor	8	47	1757	3	dec_or
defter	10	42	1592	3	defter
delta	6	61	1777	3	delta_
deltas	7	44	1482	3	deltas
denar	6	52	2329	3	de_nar
dental	7	43	1917	3	dental
deodar	8	3	771	3	deodar
deter	6	50	2804	3	de_ter
dewar	9	58	1773	3	de_war
dexter	14	38	1089	3	dexter
dicta	8	49	1563	3	dicta_
doctor	9	3	899	3	doctor
ductal	9	3	899	3	ductal
ear	3	68	6788	3	_e__ar
eater	5	46	3984	3	_eater
echard	12	4	922	3	_echard
eclair	8	3	681	3	_eclair
eclat	7	5	2360	3	_eclat
eggar	7	45	888	3	_eggar
ejecta	15	33	739	3	ejecta_
ejector	16	37	860	3	ejector
elector	9	33	1325	3	elector
embar	9	40	1160	3	_embar
enactor	9	3	803	3	enactor
endear	7	41	1001	3	endear
enter	5	47	2638	3	_enter
erecter	9	31	1339	3	erecter
erector	9	35	1380	3	erector
escar	7	40	1199	3	_escar
eschar	11	3	652	3	eschar
eskar	9	45	745	3	_eskar
ester	5	47	2771	3	_ester
eta	3	58	3419	3	_e_ta_
etas	4	64	3227	3	_e_tas
extra	12	3	900	3	_extra
factor	11	9	1145	3	factor
fear	7	53	3779	3	fe__ar
feater	9	52	2405	3	feater
fecal	10	51	1921	3	fec_al
fecial	11	47	1462	3	fecial
festal	9	42	1356	3	festal
fester	9	47	2351	3	fester
feta	7	65	2890	3	fe_ta_
fetal	8	56	2337	3	fe_tal
fetas	8	56	2440	3	fe_tas
fetor	8	12	1453	3	fe_tor
fetter	9	41	2038	3	fetter
feuar	8	3	1024	3	fe_uar
gear	5	59	3497	3	ge__ar
geta	5	66	2744	3	ge_ta_
getas	6	54	2148	3	ge_tas
getter	7	41	1761	3	getter
guitar	7	11	744	3	guitar
hear	7	61	4388	3	he__ar
heater	9	48	2830	3	heater
hectares	13	3	885	3	hectares
hectic	13	23	1151	3	hectic
hectors	12	35	1326	3	hectors
hefter	12	43	1392	3	hefter
hektare	14	3	550	3	hektare
heptad	12	3	727	3	heptad
infecter	13	22	915	3	infecter
infector	13	47	884	3	infector
injector	17	23	692	3	injector
insectan	10	4	538	3	insectan
insectary	14	4	420	3	insectary
instar	6	3	1001	3	instar
jester	13	43	1915	3	jester
kantar	10	3	1115	3	kantar
kebar	11	51	1353	3	ke_bar
kelter	10	32	1437	3	kelter
lactam	10	3	1094	3	lactam
lactary	12	3	784	3	lactary
lear	4	70	4595	3	le__ar
lecher	11	34	1585	3	lecher
lectern	9	3	703	3	lectern
lectin	8	25	1501	3	lectin
lectors	9	34	1576	3	lectors
lecture	9	14	951	3	lecture
lefter	9	36	1343	3	lefter
lekvar	13	3	304	3	lekvar
leotard	8	4	619	3	leotard
lepta	7	57	1439	3	lepta_
letter	6	37	2258	3	letter
lictor	8	36	1085	3	lictor
meatal	8	41	1473	3	meatal
mecca	11	3	993	3	mecca_
meccas	12	3	949	3	meccas
medlar	9	30	1046	3	medlar
meeter	8	36	1650	3	meeter
melter	8	35	2011	3	melter
menta	7	44	2442	3	menta_
mental	8	45	2160	3	mental
mentor	8	4	1436	3	mentor
meta	6	59	3241	3	me_ta_
metal	7	54	2738	3	me_tal
meter	7	51	3032	3	me_ter
mortar	8	38	1204	3	mortar
nachas	11	49	1419	3	nachas
natal	5	39	2149	3	n_atal
natter	6	44	2074	3	natter
navar	8	39	1273	3	n_avar
neap	6	69	2701	3	ne__ap
nearer	6	46	1889	3	nearer
nears	5	55	2942	3	ne__ars
neat	4	63	5678	3	ne__at
neaten	6	42	1454	3	neaten
neath	8	60	2028	3	neat_h
neatly	9	38	1248	3	neatly
neats	5	59	3190	3	neat_s
nebular	9	5	648	3	nebular
neck	10	54	2366	3	nec__k
necked	13	47	1506	3	necked
neckers	13	42	1046	3	neckers
necks	11	51	1933	3	nec_ks
necktie	13	4	436	3	necktie
neckwear	17	4	139	3	neckwear
nectarean	11	4	291	3	nectar~~ean~~
nectarial	11	4	709	3	nectar~~ial~~
nectaried	12	4	544	3	nectar~~ied~~
nectaries	11	4	980	3	nectar~~ies~~
nectarine	11	4	698	3	nectar~~ine~~
nectarous	11	4	471	3	nectar~~ous~~
needer	7	36	1495	3	needer
negate	7	29	1557	3	negate
negater	8	37	1195	3	negater
negator	8	30	1067	3	negator
neither	10	3	757	3	neither
nekton	10	3	658	3	nekton
nema	6	55	2252	3	ne_ma_
nemas	7	53	2157	3	ne_mas
nepeta	8	3	789	3	nepeta_
nepetas	9	3	594	3	nepetas
nerts	5	59	2498	3	nert_s
nertz	14	51	1745	3	nert_z
nest	4	55	4873	3	nest__
nested	7	47	2006	3	nested
nesters	7	44	2278	3	nesters
nestle	6	30	1395	3	nestle
nestler	7	35	1044	3	nestler
nestors	7	36	1496	3	nestors
nests	5	57	2800	3	nest_s
net	3	66	7029	3	ne_t__
nether	9	40	1416	3	nether
netop	7	3	1234	3	ne_top
nets	4	59	4153	3	ne_t_s
nett	4	66	4323	3	ne_t_t
netted	7	41	1871	3	netted
netters	7	36	1858	3	netters
nettier	7	42	1181	3	nettier
nettle	6	45	1458	3	nettle
nettler	7	34	950	3	nettler
nettly	9	45	945	3	nettly
netts	5	53	2072	3	ne_tts
netty	8	58	1676	3	ne_tty
neural	6	3	1199	3	neural
neuters	7	42	1226	3	neuters
neutral	7	3	792	3	neutral
never	8	62	1864	3	ne_ver
newer	8	57	1746	3	ne_wer
newt	7	69	3374	3	newt__
newton	9	3	698	3	newton
newts	8	60	1528	3	newt_s
next	11	66	3108	3	next__
nicad	8	3	1261	3	nic_ad
nicer	7	46	1829	3	nic_er
nicker	12	38	1870	3	nicker
nictate	9	3	1022	3	nictate
niter	5	50	2897	3	n_iter
nocturn	9	4	465	3	nocturn
nonpar	8	16	899	3	nonpar
nontax	13	4	841	3	nontax
nonwar	9	15	942	3	nonwar
nota	4	68	3077	3	n_ota_
notal	5	52	2135	3	n_otal
notary	9	23	1071	3	n_otary
noter	5	50	2564	3	n_oter
nucha	10	22	979	3	nucha_
nuchae	11	21	851	3	nuchae
nuchal	11	21	887	3	nuchal
nuclear	9	3	623	3	nuclear
nutter	6	39	1805	3	nutter
octad	8	15	1065	3	_octad
octal	7	12	1472	3	_octal
octan	7	13	1348	3	_octan
ottar	5	43	1399	3	_ottar
pear	6	97	4523	3	pe__ar
pecan	9	19	1903	3	pec_an
peccary	16	3	628	3	peccary
pechan	13	5	1154	3	pechan
pecker	14	46	1536	3	pecker
pectase	11	24	1036	3	pectase
pectate	11	22	1469	3	pectate
pecten	10	27	1110	3	pecten
pectic	12	29	1387	3	pectic
pectin	10	26	1553	3	pectin
pedlar	9	33	1127	3	pedlar
pelter	8	33	2162	3	pelter
pentad	9	3	1376	3	pentad
perter	8	44	2228	3	perter
pester	8	48	2759	3	pester
petal	7	65	2689	3	pe_tal
petard	9	50	1380	3	pe_tard
peter	7	44	2759	3	pe_ter
petter	8	39	2477	3	petter
pewter	11	40	1367	3	pewter
plectra	11	4	578	3	plectra
qintar	15	35	914	3	qintar
reactor	9	30	1165	3	reactor
rear	4	56	4455	3	re__ar
reata	5	42	2539	3	reata_
reatas	6	40	2101	3	reatas
rebar	7	54	2019	3	re_bar
recap	9	57	1802	3	rec_ap
rechart	12	3	1432	3	rechart
recital	9	4	1216	3	recital
reciter	9	41	1726	3	reciter
reclad	9	3	1187	3	reclad
recoal	8	41	1797	3	recoal
recoat	8	40	2427	3	recoat
recti	7	36	1962	3	rect_i
recto	7	45	2080	3	rect_o
rectors	9	35	2051	3	rectors
rectory	12	35	1272	3	rectory
rectos	8	57	1878	3	rectos
rectum	10	34	1128	3	rectum
rectus	8	33	1463	3	rectus
recur	7	41	1684	3	rec_ur
redear	7	35	1517	3	redear
regear	7	35	1274	3	regear
rehear	9	37	1322	3	rehear
rental	6	39	2202	3	rental
renter	6	45	2741	3	renter
restart	7	3	2003	3	restart
rester	6	38	3243	3	rester
retag	6	36	1841	3	re_tag
retard	7	50	1893	3	re_tard
retax	12	45	1797	3	re_tax
retear	6	31	1548	3	retear
rewear	9	30	1199	3	rewear
rictal	8	31	1317	3	rictal
scar	6	64	3420	3	_sc_ar
sear	4	73	5384	3	se__ar
seater	6	45	3415	3	seater
secpars	11	3	841	3	secpars
sect	6	74	4362	3	sect__
sectors	9	31	1643	3	sectors
sects	7	56	2289	3	sect_s
secular	9	22	1153	3	secular
seggar	8	35	781	3	seggar
seitan	6	26	1323	3	seitan
septa	7	55	1808	3	septa_
septal	8	45	1338	3	septal
seta	4	56	3731	3	se_ta_
setae	5	60	2622	3	se_tae
setal	5	64	3090	3	se_tal
setter	6	40	2372	3	setter
sewar	8	54	2109	3	se_war
sextan	13	38	964	3	sextan
sitar	5	48	2054	3	_sitar
specter	11	31	1173	3	specter
spectra	11	27	583	3	spectra
star	4	80	3776	3	__star
tar	3	75	7069	3	___tar
tartar	6	32	1475	3	tartar
tatar	5	61	2206	3	_tatar
tear	4	52	4288	3	te__ar
tectum	10	32	860	3	tectum
teeter	6	54	2031	3	teeter
tenter	6	46	2393	3	tenter
testa	5	48	2204	3	testa_
testae	6	42	1625	3	testae
tester	6	42	2715	3	tester
tetra	5	34	1795	3	te_tra
tetter	6	43	2245	3	tetter
tictac	10	3	656	3	tictac
vectors	12	32	1259	3	vectors
velar	8	58	1763	3	ve_lar
venter	9	42	1872	3	venter
vesta	8	66	1830	3	vesta_
vestal	9	46	1557	3	vestal
vestas	9	59	1668	3	vestas
vetter	9	34	1764	3	vetter
vicar	10	5	1386	3	vic_ar
victor	11	32	1067	3	victor
wear	7	58	3672	3	we__ar
welter	9	34	1738	3	welter
wester	9	42	2289	3	wester
wetter	9	39	1944	3	wetter
year	7	65	3425	3	ye__ar
yenta	8	39	1704	3	yenta_
yentas	9	46	1421	3	yentas
yester	9	34	1798	3	yester
zester	15	36	1779	3	zester
zeta	13	51	2164	3	ze_ta_
zetas	14	50	1816	3	ze_tas

Search took 6 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	371	5.610	20092.0
3	Display Results	371	371	0.110	3372.7
	(SQL Overall)	178691	371	5.860	30493.3