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

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

332 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
planate	9	3	1457	(None)
lanate	6	4	2126	1	_lanate
placate	11	3	1243	1	placate
clavate	12	3	871	2	clavate
cyanate	12	25	970	2	cyanate
emanate	9	3	1247	2	emanate
khanate	14	3	707	2	khanate
lanated	8	3	1320	2	_lanated
lunate	6	3	1604	2	_lunate
palate	8	42	2679	2	p_alate
paleate	9	41	2000	2	paleate
palmate	11	32	1523	2	palmate
palpate	11	32	1392	2	palpate
pennate	9	33	1403	2	pennate
phenate	12	4	1220	2	phenate
phonate	12	4	1181	2	phonate
pinnate	9	36	1374	2	pinnate
placated	13	3	845	2	placated
placater	12	3	801	2	placater
placates	12	3	1175	2	placates
planar	8	42	1271	2	plana_r
planche	14	29	975	2	planche
plane	7	49	2914	2	plan__e
planet	8	42	2835	2	planet_
planets	9	39	1408	2	planets
plankter	14	3	536	2	plankter
plant	7	54	3711	2	plan_t_
plantar	9	36	999	2	plantar
planted	10	35	1612	2	plan_ted
planter	9	40	1781	2	plan_ter
plants	8	49	2180	2	plan_ts
planulate	11	4	690	2	planulate
platane	9	31	1230	2	platane
plate	7	46	3511	2	pl__ate
playdate	14	6	526	2	playdate
playmate	15	6	646	2	playmate
plicate	11	3	1451	2	plicate
plumate	11	4	980	2	plumate
pronate	9	4	1887	2	pronate
abate	7	66	2784	3	__abate
adnate	7	29	1348	3	_adnate
agate	6	65	2515	3	__agate
agnate	7	33	1488	3	_agnate
alane	5	61	3561	3	alan__e
alanine	7	3	1686	3	alanine
alant	5	57	4229	3	alan_t_
alants	6	77	2202	3	alan_ts
alate	5	53	4033	3	__alate
alginate	9	3	1069	3	alginate
alienate	8	3	1155	3	alienate
allanite	8	4	1109	3	allanite
alunite	7	3	1163	3	alunite
ansate	6	45	1786	3	__ansate
antae	5	68	2829	3	__antae
ante	4	65	3890	3	__an_te
apanage	10	3	680	3	apanage
aphanite	13	4	877	3	aphanite
aplanatic	13	4	490	3	aplanatic
appanage	13	4	408	3	appanage
binate	8	4	1977	3	_binate
blanket	13	43	1309	3	blanket
blate	7	59	3378	3	bl__ate
canape	10	9	1352	3	_canape
carate	8	47	3400	3	_carate
climate	11	3	1283	3	climate
cognate	10	3	1220	3	cognate
connate	9	3	1575	3	connate
craniate	10	3	1256	3	craniate
crenate	9	33	1711	3	crenate
cyanates	13	23	843	3	cyanates
cyanite	12	27	1076	3	cyanite
dealate	8	36	1784	3	dealate
dilatate	9	4	777	3	dilatate
donate	7	36	1950	3	_donate
elate	5	53	3588	3	el__ate
elevate	10	11	1037	3	elevate
elongate	9	4	561	3	elongate
eluate	6	23	1543	3	el_uate
emanated	11	3	916	3	emanated
emanates	10	3	1133	3	emanates
enate	5	44	2815	3	__enate
esplanade	12	11	192	3	esplanade
falcate	12	3	1162	3	falcate
flange	10	34	1197	3	flan_ge
flatmate	13	4	639	3	flatmate
galeate	8	39	1679	3	galeate
gallate	8	34	1713	3	gallate
glabrate	11	4	604	3	glabrate
glaciate	11	6	808	3	glaciate
gladiate	10	5	705	3	gladiate
glance	9	43	1231	3	glan_ce
globate	10	5	782	3	globate
gradate	9	5	1123	3	gradate
granite	8	20	1708	3	granite
guanase	8	3	621	3	guanase
hamate	11	33	1983	3	_hamate
imamate	11	3	810	3	imamate
innate	6	39	1731	3	_innate
karate	10	53	2093	3	_karate
khanates	15	3	573	3	khanates
kyanite	14	23	731	3	kyanite
labiate	9	13	1357	3	_labiate
lactate	9	3	1270	3	_lactate
lacunate	10	12	896	3	_lacunate
laminate	10	30	1463	3	_laminate
lanai	5	3	1957	3	_lana_i
lanais	6	3	1679	3	_lanais
lance	7	51	2672	3	_lan_ce
lancet	8	42	2357	3	_lancet
lane	4	51	5333	3	_lan__e
langue	7	10	1218	3	_langue
lanose	6	3	1359	3	_lanose
late	4	75	6048	3	_l__ate
latte	5	54	2630	3	_la_tte
lavage	10	3	826	3	_lavage
legate	7	29	1745	3	_legate
lenite	6	7	1998	3	_lenite
ligate	7	25	1925	3	_ligate
linage	7	7	1340	3	_linage
lineate	7	8	1515	3	_lineate
lobate	8	29	1524	3	_lobate
locate	8	39	1984	3	_locate
lunated	8	3	1082	3	_lunated
luxate	13	3	808	3	_luxate
lyrate	9	41	1210	3	_lyrate
lysate	9	38	810	3	_lysate
magnate	10	5	1270	3	magnate
malate	8	46	2456	3	_malate
maleate	9	41	1754	3	maleate
manage	9	38	1890	3	_manage
manat	7	60	3999	3	_manat_
manatee	9	3	1766	3	_manatee
manats	8	46	2346	3	_manats
mandate	10	3	1557	3	_mandate
melanite	10	5	1203	3	melanite
neonate	7	3	1133	3	neonate
odonate	8	4	840	3	odonate
oleate	6	3	1888	3	ol_eate
ornate	6	3	1514	3	_ornate
oxalate	14	5	762	3	oxalate
ozonate	16	4	686	3	ozonate
paginate	11	40	1244	3	paginate
palace	10	45	1692	3	p_alace
palates	9	36	2494	3	p_alates
palatinate	12	4	560	3	palatinate
paleae	8	48	2029	3	palea_e
palette	9	36	1398	3	palette
palliate	10	3	1190	3	palliate
palmated	13	25	1100	3	palmated
palpated	13	24	976	3	palpated
palpates	12	26	1306	3	palpates
panacea	11	3	779	3	p_anacea
panache	14	5	843	3	p_anache
panada	9	41	1305	3	p_anada
panama	10	42	1335	3	p_anama
panatela	10	4	491	3	p_anatela
pancake	15	3	667	3	p_ancake
pane	6	49	5029	3	p_an__e
panne	7	66	2365	3	p_an_ne
pant	6	60	6126	3	p_an_t_
panted	9	50	2482	3	p_an_ted
pantie	8	43	2647	3	p_antie
panto	7	61	2941	3	p_an_to
pants	7	65	3692	3	p_an_ts
panty	10	59	2930	3	p_an_ty
parade	9	47	2064	3	p_arade
parae	7	63	3571	3	p_ara_e
parlante	10	3	969	3	parlan_te
paste	7	49	3295	3	p_a_ste
pate	6	53	5046	3	p___ate
patinate	10	30	1631	3	patinate
pavane	11	41	1344	3	p_avane
pawnage	13	3	587	3	pawnage
peanut	8	3	1818	3	peanut_
peanuts	9	3	699	3	peanuts
pectate	11	22	1469	3	pectate
pedate	9	31	1776	3	p_edate
peltate	9	20	1377	3	peltate
penates	9	33	2160	3	p_enates
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
phenates	13	6	1158	3	phenates
phonated	14	4	789	3	phonated
phonates	13	4	1064	3	phonates
phorate	12	4	1336	3	phorate
picante	11	3	1052	3	pican_te
picrate	11	20	1414	3	picrate
pileate	9	38	1592	3	pileate
pinata	8	38	1722	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
placable	14	16	924	3	placable
placard	12	3	678	3	placard
placaters	13	3	647	3	placaters
placative	16	4	622	3	placative
place	9	48	2461	3	pl__ace
placentae	13	6	435	3	placentae
placet	10	39	2367	3	placet_
placets	11	39	1122	3	placets
placket	15	4	1287	3	placket
plagal	9	4	857	3	plaga_l
plage	8	45	2040	3	pl__age
plague	9	36	1085	3	pla_gue
plaice	10	3	1155	3	pla_ice
plaint	8	53	2320	3	plaint_
plaints	9	40	1205	3	plaints
plaister	10	6	801	3	plaister
plait	7	56	3157	3	pla_it_
plaited	10	37	1389	3	pla_ited
plaiter	9	36	1539	3	pla_iter
plaits	8	38	1647	3	pla_its
plan	6	58	3394	3	plan___
planaria	10	4	735	3	planaria
planarity	14	4	532	3	planarity
planation	11	3	1012	3	planation
planch	13	37	1144	3	plan_ch
planches	15	31	1186	3	planches
planchet	15	25	1196	3	planchet
planed	9	44	2091	3	plan_ed
planer	8	41	2266	3	plan_er
planers	9	45	1795	3	planers
planes	8	50	2808	3	plan_es
planing	10	34	1825	3	planing
planish	12	4	1206	3	planish
plank	11	52	2114	3	plan__k
planked	14	35	1228	3	planked
planks	12	41	1675	3	plan_ks
plankters	15	4	458	3	plankters
plankton	14	4	385	3	plankton
planned	10	38	1015	3	planned
planner	9	35	1163	3	planner
plans	7	57	3127	3	plan__s
plantable	13	3	727	3	plantable
plantain	10	4	790	3	plantain
planters	10	29	1533	3	plan_ters
plantlet	10	3	1001	3	plantlet
planula	9	3	577	3	planula
planulae	10	4	479	3	planulae
plaque	17	31	764	3	pla_que
plaster	9	33	1869	3	pla_ster
plat	6	60	4887	3	pl__at_
platan	8	39	1369	3	plata_n
platanes	10	27	1188	3	platanes
platans	9	34	1312	3	platans
plated	9	52	2577	3	pl__ated
platen	8	45	1820	3	pl__aten
plater	8	44	2769	3	pl__ater
plates	8	54	3224	3	pl__ates
plats	7	55	3137	3	pl__ats
platted	10	36	1426	3	pla_tted
platter	9	39	1741	3	pla_tter
platy	10	50	2166	3	pl__aty
playa	10	58	1294	3	playa__
playable	15	13	792	3	playable
playact	14	4	655	3	playact
playacted	17	4	264	3	playacted
playacts	15	4	381	3	playacts
playas	11	46	1228	3	playa_s
playdates	15	5	490	3	playdates
playlet	12	3	952	3	playlet
playmates	16	4	660	3	playmates
plaza	16	43	1106	3	plaza__
plazas	17	40	991	3	plaza_s
please	8	43	1573	3	pl_ease
pleat	7	47	3447	3	pl_eat_
pleated	10	38	1663	3	pl_eated
pleater	9	39	1633	3	pl_eater
pleats	8	52	1859	3	pl_eats
plena	7	58	1639	3	plena__
plenary	12	3	754	3	plenary
plenty	11	3	1141	3	plen_ty
pliant	8	39	1882	3	plian_t_
plicae	10	4	1095	3	plica_e
plicated	13	3	1064	3	plicated
plinth	11	3	1045	3	plin_th
plumage	12	4	550	3	plumage
plunge	9	38	1106	3	plun_ge
pointe	8	46	1931	3	poin_te
pollenate	11	5	714	3	pollenate
pollinate	11	4	771	3	pollinate
prance	10	43	1857	3	pran_ce
prate	7	51	3598	3	p__rate
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
prename	11	4	1264	3	prename
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
pulmonate	13	4	476	3	pulmonate
pulsate	9	5	1023	3	pulsate
pulvinate	14	4	519	3	pulvinate
pupate	10	42	1312	3	p_upate
qanat	14	44	2684	3	_qanat_
qanats	15	41	1281	3	_qanats
quinate	16	5	1157	3	quinate
ramate	8	39	2169	3	_ramate
ruinate	7	3	1283	3	ruinate
savate	9	3	1378	3	_savate
selenate	8	17	1253	3	selenate
senate	6	37	2517	3	_senate
slainte	7	3	854	3	slainte
slant	5	52	3870	3	slan_t_
slanted	8	35	1474	3	slan_ted
slants	6	48	1908	3	slan_ts
slanty	9	51	1484	3	slan_ty
slate	5	54	3828	3	sl__ate
spinate	9	31	1481	3	spinate
stagnate	9	4	724	3	stagnate
sultanate	9	4	605	3	sultanate
tannate	7	18	1352	3	tannate
ternate	7	4	1548	3	ternate
thanage	11	11	794	3	thanage
titanate	8	9	717	3	titanate
ulnae	5	52	1457	3	ul_na_e
ululate	7	4	996	3	ululate
uranite	7	25	1569	3	uranite
urinate	7	3	1536	3	urinate
vacate	11	3	1455	3	_vacate
vallate	10	30	1656	3	vallate
valuate	10	25	1273	3	valuate
valvate	13	37	1081	3	valvate
volante	10	3	851	3	volan_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.406	440125.6
2	DLD Change Limit	134027	332	6.106	21950.0
3	Display Results	332	332	0.126	2634.9
	(SQL Overall)	178691	332	6.638	26919.4