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

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

400 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
ternate	7	4	1548	(None)
aerate	6	48	3055	2	aer_ate
alternate	9	4	811	2	alternate
berate	8	47	2902	2	ber_ate
cerate	8	48	2946	2	cer_ate
crenate	9	33	1711	2	crenate
derate	7	45	3123	2	der_ate
enate	5	44	2815	2	_e_nate
ergate	7	3	1514	2	_ergate
fermate	12	28	1300	2	fermate
ferrate	10	30	1404	2	ferrate
herniate	11	4	811	2	herniate
iterate	7	11	1911	2	iter_ate
kernite	11	5	947	2	kernite
neonate	7	3	1133	2	neonate
nervate	10	3	953	2	nervate
ornate	6	3	1514	2	_ornate
pennate	9	33	1403	2	pennate
senate	6	37	2517	2	se_nate
serenate	8	19	1488	2	serenate
seriate	7	37	2247	2	seriate
serrate	7	30	1754	2	serrate
sternite	8	3	1054	2	sternite
tannate	7	18	1352	2	tannate
teenage	8	10	805	2	teenage
tenace	8	27	1569	2	te_nace
terete	6	3	1933	2	ter_ete
tergite	8	3	1100	2	tergite
terminate	11	4	1120	2	terminate
termite	9	3	1389	2	termite
ternary	10	3	834	2	ternary
ternately	12	4	500	2	ternately
terne	5	64	2615	2	tern__e
terrace	9	33	1184	2	terrace
terrae	6	29	1521	2	terra_e
terrane	7	28	1423	2	terrane
testate	7	39	1623	2	testate
acerate	9	28	1891	3	acer_ate
acerbate	12	4	753	3	acerbate
acervate	13	3	698	3	acervate
adnate	7	29	1348	3	_adnate
aerated	8	53	2237	3	aer_ated
aerates	7	46	2749	3	aer_ates
agnate	7	33	1488	3	_agnate
airdate	8	3	1132	3	airdate
altercate	11	4	785	3	altercate
alternated	11	4	572	3	alternated
alternates	10	4	787	3	alternates
arenite	7	10	1771	3	arenite
aurate	6	44	2647	3	aur_ate
aureate	7	25	1528	3	aureate
barbate	11	3	1454	3	barbate
bedmate	12	3	943	3	bedmate
bename	10	33	1607	3	be_name
berake	12	42	1608	3	ber_ake
berated	10	44	2213	3	ber_ated
berates	9	41	2687	3	ber_ates
bereave	12	5	835	3	bereave
binate	8	4	1977	3	_binate
borate	8	50	2615	3	bor_ate
bornite	9	3	1118	3	bornite
bursate	9	41	1120	3	bursate
carate	8	47	3400	3	car_ate
carinate	10	33	2025	3	carinate
carnage	10	3	1174	3	carnage
catenate	10	3	1283	3	cate_nate
cenote	8	37	1584	3	ce_note
cerated	10	39	2247	3	cer_ated
cerates	9	54	2825	3	cer_ates
cerite	8	47	2487	3	cer_ite
cirrate	9	24	1349	3	cirrate
cognate	10	3	1220	3	cognate
connate	9	3	1575	3	connate
cordate	10	3	1522	3	cordate
cornute	9	3	964	3	cornute
coronate	10	30	1821	3	coronate
crate	7	65	3740	3	_cr_ate
create	8	51	2638	3	_create
cremate	11	38	1618	3	cremate
crenated	11	30	1391	3	crenated
curate	8	52	2624	3	cur_ate
curtate	9	3	1264	3	curtate
cyanate	12	25	970	3	cyanate
cybernate	16	4	360	3	cybernate
dealate	8	36	1784	3	dealate
debate	9	44	1919	3	de_bate
deflate	11	36	1394	3	deflate
delate	7	38	2775	3	de_late
denote	7	41	1804	3	de_note
dentate	8	3	1515	3	dentate
derange	9	3	981	3	derange
derat	6	50	4408	3	der_at_
derated	9	36	2350	3	der_ated
derates	8	40	2889	3	der_ates
derats	7	46	2506	3	der_ats
derivate	12	3	1120	3	derivate
derogate	10	3	1135	3	derogate
detonate	9	3	1119	3	detonate
deviate	11	3	1271	3	deviate
donate	7	36	1950	3	_donate
elate	5	53	3588	3	_e_late
eluate	6	23	1543	3	_eluate
emanate	9	3	1247	3	emanate
enates	6	40	2643	3	_e_nates
enervate	11	4	846	3	enervate
enrage	7	27	1507	3	_enrage
equate	15	20	1246	3	_equate
erase	5	49	2549	3	_er_ase
ergates	8	3	1449	3	_ergates
erne	4	67	2743	3	_ern__e
errata	6	3	901	3	_errata
ersatz	15	3	665	3	_ersatz
estate	6	47	1976	3	_estate
eternal	7	29	1089	3	eterna_l
eternals	8	23	895	3	eternals
eterne	6	3	1172	3	etern__e
eternise	8	11	966	3	eternise
eternity	11	4	668	3	eternity
eternize	17	11	836	3	eternize
fellate	10	3	1343	3	fellate
feriae	9	56	1860	3	feria_e
fermata	12	27	814	3	fermata
ferrates	11	30	1342	3	ferrates
ferrite	10	33	1275	3	ferrite
formate	12	31	1509	3	formate
furcate	12	3	1045	3	furcate
furnace	12	3	594	3	furnace
gelate	7	34	2126	3	ge_late
geminate	11	4	1181	3	geminate
gemmate	12	41	838	3	gemmate
germane	10	4	966	3	germane
germinate	12	4	863	3	germinate
gestate	8	36	1407	3	gestate
grate	6	49	3288	3	_gr_ate
grenade	9	3	841	3	grenade
gyrate	10	49	1252	3	gyr_ate
herbage	13	3	700	3	herbage
hereat	9	35	2741	3	hereat_
hermae	11	53	1447	3	herma_e
herniae	10	3	904	3	herniae
herniated	13	4	601	3	herniated
herniates	12	4	733	3	herniates
hibernate	14	4	499	3	hibernate
innate	6	39	1731	3	_innate
irate	5	56	2798	3	_ir_ate
iterance	10	4	952	3	iterance
iterant	7	3	1778	3	iterant_
iterated	9	12	1382	3	iter_ated
iterates	8	13	1782	3	iter_ates
karate	10	53	2092	3	kar_ate
kente	9	58	2107	3	ke_n_te
kerne	9	47	1822	3	kern__e
kernites	12	6	911	3	kernites
keynote	14	4	390	3	keynote
khanate	14	3	707	3	khanate
lanate	6	4	2126	3	_lanate
legate	7	29	1745	3	le_gate
lenite	6	7	1998	3	le_nite
literate	8	12	1689	3	liter_ate
lunate	6	3	1604	3	_lunate
lyrate	9	41	1210	3	lyr_ate
magnate	10	5	1270	3	magnate
marinate	10	30	1778	3	marinate
mediate	10	34	1521	3	mediate
menace	10	32	1694	3	me_nace
menage	9	32	1654	3	me_nage
metate	8	27	2053	3	me_tate
muriate	9	3	1336	3	muriate
narrate	7	3	1349	3	narrate
negate	7	29	1557	3	ne_gate
neonates	8	3	1006	3	neonates
ocreate	9	37	1174	3	ocreate
odonate	8	4	840	3	odonate
operate	9	6	1573	3	oper_ate
orate	5	51	3330	3	_or_ate
overate	10	6	2096	3	over_ate
overhate	14	3	1279	3	overhate
overlate	11	7	1628	3	overlate
overrate	11	6	1569	3	overrate
ozonate	16	4	686	3	ozonate
pectate	11	22	1469	3	pectate
pedate	9	31	1776	3	pe_date
peltate	9	20	1377	3	peltate
penates	9	33	2160	3	pe_nates
pennae	8	43	1403	3	penna_e
penname	11	32	855	3	penname
pennated	11	29	954	3	pennated
peonage	10	4	872	3	peonage
percale	11	3	1409	3	percale
perennate	11	4	778	3	perennate
perlite	9	3	1732	3	perlite
permeate	12	3	1161	3	permeate
permute	11	3	879	3	permute
perorate	10	4	1792	3	perorate
personate	11	21	1142	3	personate
pervade	13	3	702	3	pervade
phenate	12	4	1220	3	phenate
phonate	12	4	1181	3	phonate
pinnate	9	36	1374	3	pinnate
pirate	8	23	2288	3	pir_ate
planate	9	3	1457	3	planate
prate	7	51	3598	3	_pr_ate
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
prename	11	4	1264	3	prename
pronate	9	4	1887	3	pronate
quinate	16	5	1157	3	quinate
rate	4	54	5876	3	__r_ate
rebate	8	44	2411	3	re_bate
recrate	9	26	2166	3	recrate
recreate	10	3	1360	3	recreate
redate	7	41	2468	3	re_date
reflate	10	35	1626	3	reflate
regrate	8	26	1866	3	regrate
relate	6	40	3363	3	re_late
remate	8	44	2868	3	re_mate
rename	8	27	1881	3	re_name
rennase	7	3	871	3	rennase
rente	5	47	3378	3	re_n_te
replate	9	34	2005	3	replate
reroute	7	3	1396	3	reroute
resinate	8	3	1677	3	resinate
reslate	7	35	2059	3	reslate
resonate	8	5	1351	3	resonate
restate	7	38	2488	3	restate
reunite	7	3	1271	3	reunite
ruinate	7	3	1283	3	ruinate
sedate	7	30	1981	3	se_date
selenate	8	17	1253	3	selenate
senates	7	33	2261	3	se_nates
sensate	7	3	1189	3	sensate
sente	5	64	3288	3	se_n_te
septate	9	5	1187	3	septate
serape	8	48	1841	3	ser_ape
serenade	9	21	834	3	serenade
serenata	8	19	767	3	serenata
serfage	11	3	840	3	serfage
seriated	9	27	1702	3	seriated
seriates	8	26	2067	3	seriates
serrated	9	25	1343	3	serrated
serrates	8	26	1702	3	serrates
sorbate	9	3	1173	3	sorbate
spinate	9	31	1481	3	spinate
stagnate	9	4	724	3	stagnate
stearate	8	3	972	3	stearate
stellate	8	3	1050	3	stellate
sterna	6	37	1276	3	sterna__
sternal	7	34	1191	3	sterna_l
sternites	9	3	1007	3	sternites
striate	7	42	1895	3	striate
supernate	11	3	1327	3	supernate
surname	9	3	760	3	surname
tannage	8	20	958	3	tannage
tannates	8	19	1195	3	tannates
tarnal	6	37	1650	3	tarna_l
tartare	7	30	1268	3	tartare
tartrate	8	9	968	3	tartrate
tate	4	47	4860	3	t___ate
teacake	13	3	545	3	teacake
teammate	12	4	561	3	teammate
tease	5	54	2871	3	te__ase
teat	4	59	6363	3	te__at_
teated	7	49	2402	3	te__ated
teats	5	56	3681	3	te__ats
teaware	10	4	814	3	teaware
tectite	9	3	1058	3	tectite
teenaged	10	10	513	3	teenaged
teenager	9	11	529	3	teenager
tektite	11	3	688	3	tektite
telae	5	43	2329	3	te_la_e
telnet	6	5	1883	3	telnet_
telneted	9	3	507	3	telneted
telnets	7	3	837	3	telnets
template	12	3	843	3	template
tenable	9	32	1449	3	te_nable
tenaces	9	28	1451	3	te_naces
tenail	6	45	1611	3	te_nail
tenant	6	3	2247	3	te_nant
tenanted	9	3	704	3	te_nanted
tenants	7	3	1101	3	te_nants
tenet	5	55	4221	3	te_net_
tenets	6	55	1895	3	te_nets
tenge	6	57	2044	3	te_n_ge
teniae	6	45	1735	3	te_niae
tense	5	52	2584	3	te_n_se
tent	4	61	5986	3	te_n_t_
tentage	8	10	1064	3	tentage
tented	7	42	2100	3	te_n_ted
tenter	6	46	2393	3	te_n_ter
tenth	8	54	2183	3	te_n_th
tentie	6	25	2118	3	te_ntie
tents	5	64	3421	3	te_n_ts
tenty	8	61	2160	3	te_n_ty
tenure	6	3	1161	3	te_nure
tenuti	6	3	897	3	te_nuti
tenuto	6	4	874	3	te_nuto
terabyte	13	5	355	3	terabyte
terai	5	35	2548	3	ter_a_i
terais	6	40	2351	3	ter_ais
teraph	11	31	909	3	ter_aph
terawatt	11	4	737	3	terawatt
terce	7	57	2184	3	ter__ce
tercet	8	36	2491	3	tercet_
tercets	9	35	1244	3	tercets
terga	6	33	1564	3	terga__
tergal	7	29	1283	3	terga_l
tergites	9	3	1054	3	tergites
terminated	13	4	816	3	terminated
terminates	12	4	1000	3	terminates
termites	10	3	1369	3	termites
tern	4	61	3480	3	tern___
ternaries	9	3	1164	3	ternaries
terneplate	12	5	378	3	tern~~epl~~ate
ternes	6	54	2290	3	tern_es
ternion	7	3	949	3	ternion
terns	5	52	2687	3	tern__s
terpene	9	23	1086	3	terpene
terra	5	44	1966	3	terra__
terraced	11	31	812	3	terraced
terraces	10	27	1225	3	terraces
terrain	7	4	1085	3	terrain
terranes	8	25	1443	3	terranes
terras	6	35	1697	3	terra_s
terrases	8	21	1148	3	terrases
terrene	7	24	1103	3	terrene
terret	6	34	2562	3	terret_
terrets	7	29	1358	3	terrets
terrine	7	25	1757	3	terrine
territ	6	34	2137	3	territ_
territs	7	27	1450	3	territs
terse	5	50	2682	3	ter__se
testae	6	42	1625	3	testa_e
testates	8	36	1545	3	testates
thanage	11	11	794	3	thanage
thecate	12	32	1002	3	thecate
thenage	11	10	784	3	thenage
thereat	10	43	1524	3	thereat_
thermae	12	53	1050	3	therma_e
thermite	13	3	903	3	thermite
thionate	11	13	750	3	thionate
thrave	12	60	1027	3	thr_ave
threat	9	50	2046	3	threat_
threated	12	5	920	3	threated
threaten	11	4	630	3	threaten
threats	10	43	1167	3	threats
throat	9	48	1975	3	throat_
throated	12	4	792	3	throated
throats	10	46	1219	3	throats
throaty	13	42	848	3	throaty
tirade	7	3	1169	3	tir_ade
titanate	8	9	717	3	titanate
titrate	7	22	1557	3	titrate
toccate	11	3	877	3	toccate
toeplate	10	4	761	3	toeplate
togate	7	45	1568	3	t_ogate
tolerate	8	3	1232	3	toler_ate
toluate	7	15	934	3	toluate
tonnage	8	16	805	3	tonnage
tornado	8	4	567	3	tornado
torquate	17	4	500	3	torquate
torsade	8	3	759	3	torsade
torte	5	54	3170	3	tor__te
trace	7	58	2961	3	t_r_ace
trade	6	50	2604	3	t_r_ade
trance	8	47	1876	3	t_rance
trave	8	52	2303	3	t_r_ave
treat	5	62	4035	3	t_reat_
treated	8	36	1870	3	t_reated
treater	7	42	1983	3	t_reater
treats	6	48	2169	3	t_reats
treaty	9	44	1435	3	t_reaty
trenail	7	4	1081	3	trenail
triage	7	28	1289	3	t_riage
triste	6	38	1864	3	t_riste
trite	5	47	3003	3	t_r_ite
truncate	10	4	628	3	truncate
tryste	9	39	958	3	t_ryste
tubate	8	28	1317	3	t_ubate
tunnage	8	16	637	3	tunnage
turbinate	11	4	667	3	turbinate
turgite	8	3	797	3	turgite
turnable	10	3	785	3	turnable
tyrant	9	3	1533	3	tyrant_
tyrants	10	3	745	3	tyrants
unornate	8	4	801	3	unornate
uprate	8	39	1654	3	upr_ate
urate	5	54	3216	3	_ur_ate
urinate	7	3	1536	3	urinate
username	10	4	258	3	username
variate	10	13	1643	3	variate
velate	9	37	2014	3	ve_late
venae	8	59	2098	3	ve_na_e
venenate	11	4	793	3	venenate
verite	9	43	2344	3	ver_ite
vernacle	13	4	558	3	vernacle
vernal	9	35	1421	3	verna_l
verste	9	45	1563	3	ver_ste
virgate	11	3	873	3	virgate
yente	8	62	2004	3	ye_n_te
zonate	15	41	1492	3	_zonate

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	134027	0.403	443402.0
2	DLD Change Limit	134027	400	6.440	20811.6
3	Display Results	400	400	0.156	2564.1
	(SQL Overall)	178691	400	6.999	25530.9