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

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

289 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
phenate	12	4	1219	(None)
phenates	13	6	1156	1	phenates
phonate	12	4	1181	1	phonate
chelate	12	29	1489	2	chelate
crenate	9	33	1711	2	crenate
enate	5	44	2814	2	__enate
hyphenate	20	4	450	2	hyphenate
khanate	14	3	707	2	khanate
pedate	9	31	1776	2	p_edate
penates	9	33	2159	2	p_enates
pennate	9	33	1403	2	pennate
phenacite	16	8	609	2	phenacite
phenakite	18	6	422	2	phenakite
phenolate	14	4	746	2	phenolate
phonated	14	4	789	2	phonated
phonates	13	4	1064	2	phonates
phorate	12	4	1336	2	phorate
pinnate	9	36	1374	2	pinnate
planate	9	3	1457	2	planate
predate	10	6	1689	2	predate
prelate	9	5	1969	2	prelate
prename	11	4	1264	2	prename
pronate	9	4	1887	2	pronate
senate	6	37	2514	2	_senate
thecate	12	32	1002	2	thecate
thenage	11	10	783	2	thenage
acerate	9	28	1891	3	acerate
acetate	9	25	1475	3	acetate
adnate	7	29	1348	3	_adnate
aerate	6	48	3055	3	_aerate
agemate	10	12	1058	3	agemate
agnate	7	33	1487	3	_agnate
alienate	8	3	1155	3	alienate
aphanite	13	4	877	3	aphanite
apholate	13	4	1047	3	apholate
arenite	7	10	1771	3	arenite
arsenate	8	10	1048	3	arsenate
bename	10	33	1607	3	_bename
berate	8	47	2902	3	_berate
binate	8	4	1977	3	_binate
catenate	10	3	1283	3	catenate
cenote	8	37	1584	3	_cenote
cerate	8	48	2946	3	_cerate
cheat	10	57	3245	3	che_at_
cheated	13	44	1634	3	che_ated
cheater	12	48	1695	3	che_ater
cheats	11	45	1954	3	che_ats
chedite	13	3	886	3	chedite
chelae	11	36	1460	3	chela_e
chelated	14	26	1048	3	chelated
chelates	13	27	1383	3	chelates
cholate	12	21	1493	3	cholate
cognate	10	3	1219	3	cognate
connate	9	3	1575	3	connate
create	8	51	2637	3	cre_ate
cremate	11	38	1618	3	cremate
crenated	11	30	1391	3	crenated
cuneate	9	3	1172	3	cuneate
cyanate	12	25	970	3	cyanate
debate	9	44	1919	3	_debate
delate	7	38	2775	3	_delate
denote	7	41	1804	3	_denote
dentate	8	3	1515	3	_dentate
derate	7	45	3123	3	_derate
donate	7	36	1950	3	_donate
echinate	13	5	940	3	echinate
edentate	9	4	770	3	edentate
elate	5	53	3588	3	__elate
elevate	10	11	1037	3	elevate
emanate	9	3	1247	3	emanate
emendate	11	4	676	3	emendate
enates	6	40	2642	3	__enates
ephorate	13	5	950	3	ephorate
gelate	7	34	2125	3	_gelate
grenade	9	3	841	3	grenade
hamate	11	33	1982	3	_hamate
hate	7	84	5017	3	_h__ate
heat	7	70	6142	3	_he_at_
heated	10	45	2559	3	_he_ated
heater	9	48	2830	3	_he_ater
heath	11	57	2428	3	_he_ath
heats	8	58	3840	3	_he_ats
heave	11	45	2181	3	_he_ave
henbane	12	3	735	3	_henbane
hence	10	49	2004	3	_hen_ce
henge	9	48	1982	3	_hen_ge
hent	7	66	5638	3	_hen_t_
hented	10	42	1875	3	_hen_ted
hents	8	73	3074	3	_hen_ts
herniate	11	4	811	3	_herniate
hexade	17	43	890	3	_hexade
hexane	16	37	953	3	_hexane
humate	11	32	1444	3	_humate
hyphenated	22	5	336	3	hyphenated
hyphenates	21	4	445	3	hyphenates
ideate	7	3	1368	3	ide_ate
innate	6	39	1731	3	_innate
iterate	7	11	1910	3	iterate
kente	9	58	2106	3	_ken_te
khanates	15	3	573	3	khanates
lanate	6	4	2126	3	_lanate
legate	7	29	1745	3	_legate
lenite	6	7	1998	3	_lenite
lineate	7	8	1515	3	lineate
lunate	6	3	1604	3	_lunate
magnate	10	5	1270	3	magnate
menace	10	32	1694	3	_menace
menage	9	32	1654	3	_menage
metate	8	27	2053	3	_metate
negate	7	29	1557	3	_negate
neonate	7	3	1133	3	neonate
odonate	8	4	840	3	odonate
oleate	6	3	1888	3	ole_ate
operate	9	6	1573	3	operate
ornate	6	3	1513	3	_ornate
overate	10	6	2096	3	overate
ozonate	16	4	686	3	ozonate
paginate	11	40	1244	3	paginate
palate	8	42	2678	3	p_alate
paleate	9	41	2000	3	paleate
palmate	11	32	1523	3	palmate
palpate	11	32	1392	3	palpate
pate	6	53	5046	3	p___ate
patinate	10	30	1631	3	patinate
pawnage	13	3	587	3	pawnage
peace	9	50	2608	3	p_e_ace
peage	8	47	2356	3	p_e_age
pease	7	52	3111	3	p_e_ase
peat	6	59	6793	3	p_e_at_
peats	7	61	4019	3	p_e_ats
peaty	10	57	2569	3	p_e_aty
pectate	11	22	1469	3	pectate
peerage	10	8	980	3	peerage
pelage	9	5	1536	3	p_elage
pelite	8	43	2300	3	p_elite
peltate	9	20	1377	3	peltate
penal	7	52	2837	3	p_ena_l
penalty	12	6	774	3	p_enalty
penance	11	3	1344	3	p_enance
penang	9	25	1111	3	p_enang
pence	9	49	2445	3	p_en_ce
penile	8	22	1960	3	p_enile
penlite	9	3	1324	3	p_enlite
pennae	8	43	1403	3	p_ennae
penname	11	32	855	3	penname
pennated	11	29	954	3	pennated
penne	7	54	2385	3	p_en_ne
pensee	8	4	1731	3	p_ensee
penster	9	28	1195	3	p_enster
pent	6	65	5907	3	p_en_t_
pentad	9	3	1376	3	p_entad
pentane	9	4	1574	3	p_entane
peonage	10	4	872	3	peonage
perennate	11	4	777	3	perennate
pesade	9	3	1110	3	p_esade
petite	8	43	2065	3	p_etite
peyote	11	3	985	3	p_eyote
phage	11	51	1367	3	ph__age
phase	10	46	1721	3	ph__ase
phat	9	58	3786	3	ph__at_
phenacites	17	6	538	3	phenacites
phenakites	19	6	384	3	phenakites
phenazin	22	4	557	3	phenazin
phenazine	23	4	562	3	phenazine
phenetic	15	4	920	3	phenetic
phenetol	13	4	406	3	phenetol
phenetole	14	4	407	3	phenetole
phenix	18	3	713	3	phen_ix
phenixes	20	3	563	3	phenixes
phenol	11	4	925	3	phen_ol
phenolated	16	4	523	3	phenolated
phenolates	15	4	699	3	phenolates
phenols	12	3	810	3	phenols
phenom	13	3	947	3	phen_om
phenoms	14	3	781	3	phenoms
phenotype	19	4	438	3	phenotype
phenoxy	22	4	348	3	phenoxy
phenyl	14	3	532	3	phen_yl
phenyls	15	3	432	3	phenyls
phonal	11	3	1038	3	phona_l
phone	10	56	2193	3	phon__e
phoneme	14	4	620	3	phoneme
phorates	13	4	1304	3	phorates
phrase	11	10	990	3	ph_rase
phylae	14	45	873	3	phyla_e
phytane	15	4	544	3	phytane
picante	11	3	1052	3	picante
picrate	11	20	1414	3	picrate
pileate	9	38	1592	3	pileate
pinata	8	38	1721	3	p_inata
pinite	8	3	2124	3	p_inite
pinnace	11	35	1031	3	pinnace
pinnae	8	44	1464	3	pinna_e
pinnated	11	33	855	3	pinnated
pirate	8	23	2288	3	p_irate
placate	11	3	1243	3	placate
plate	7	46	3511	3	p__late
please	8	43	1573	3	ple_ase
pleat	7	47	3447	3	ple_at_
pleated	10	38	1663	3	ple_ated
pleater	9	39	1633	3	ple_ater
pleats	8	52	1859	3	ple_ats
plena	7	58	1639	3	plena__
plenary	12	3	754	3	plenary
plenty	11	3	1141	3	plen_ty
plicate	11	3	1451	3	plicate
plumate	11	4	980	3	plumate
pointe	8	46	1931	3	poin_te
pollenate	11	5	714	3	pollenate
potentate	11	9	725	3	potentate
prate	7	51	3598	3	p__rate
prebade	12	3	1028	3	prebade
prebake	15	3	909	3	prebake
predated	12	5	1327	3	predated
predates	11	6	1580	3	predates
preface	14	5	1092	3	preface
prefade	13	3	901	3	prefade
pregame	12	3	955	3	pregame
prelates	10	4	1856	3	prelates
premade	12	3	1144	3	premade
prenames	12	3	1163	3	prenames
prenatal	10	4	837	3	prenatal
prepare	11	19	1362	3	prepare
prepaste	12	13	908	3	prepaste
prepave	14	22	887	3	prepave
prerace	11	4	1412	3	prerace
presage	10	3	1229	3	presage
presale	9	4	1635	3	presale
pretape	11	35	1162	3	pretape
pretaste	10	13	952	3	pretaste
preunite	10	3	957	3	preunite
primate	11	15	1628	3	primate
private	12	15	1326	3	private
probate	11	4	1448	3	probate
prolate	9	4	1979	3	prolate
pronated	11	4	1405	3	pronated
pronates	10	4	1837	3	pronates
prorate	9	4	1873	3	prorate
pulsate	9	5	1023	3	pulsate
pupate	10	42	1312	3	p_upate
quinate	16	5	1157	3	quinate
rebate	8	44	2410	3	_rebate
redate	7	41	2468	3	_redate
relate	6	40	3363	3	_relate
remate	8	44	2868	3	_remate
rename	8	27	1881	3	_rename
rente	5	47	3378	3	_ren_te
ruinate	7	3	1283	3	ruinate
saphenae	13	4	485	3	saphena_e
sedate	7	30	1980	3	_sedate
selenate	8	17	1252	3	selenate
senates	7	33	2258	3	_senates
sensate	7	3	1188	3	_sensate
sente	5	64	3287	3	_sen_te
serenate	8	19	1487	3	serenate
sheath	12	4	1288	3	she_ath
sheathe	13	4	898	3	she_athe
sheave	12	45	1400	3	she_ave
shent	8	59	3349	3	shen_t_
sienite	7	3	1271	3	sienite
sphene	11	34	1240	3	sphen__e
spinate	9	31	1481	3	spinate
syenite	10	3	977	3	syenite
tannate	7	18	1352	3	tannate
teenage	8	10	805	3	teenage
tenace	8	27	1569	3	_tenace
ternate	7	4	1548	3	ternate
thanage	11	11	793	3	thanage
theater	10	40	1425	3	the_ater
theatre	10	35	849	3	the_atre
thecae	11	29	965	3	theca_e
thenages	12	10	747	3	thenages
thenal	9	27	1241	3	thena_l
thenar	9	26	999	3	thena_r
thenars	10	24	850	3	thenars
thence	11	20	1084	3	then_ce
thionate	11	13	749	3	thionate
upheave	15	4	402	3	uphe_ave
urinate	7	3	1536	3	urinate
velate	9	37	2014	3	_velate
venae	8	59	2098	3	_vena_e
venenate	11	4	792	3	venenate
wheat	11	49	2457	3	whe_at_
wheaten	13	3	640	3	whe_aten
wheats	12	50	1322	3	whe_ats
whenas	12	46	1046	3	whena_s
whence	14	18	792	3	when_ce
yente	8	62	2004	3	_yen_te
zonate	15	41	1492	3	_zonate

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	134027	0.156	1145455.1
2	DLD Change Limit	134027	289	6.266	21389.6
3	Display Results	289	289	0.140	2064.3
	(SQL Overall)	178691	289	6.562	27231.2