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

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

311 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
palpate	11	32	1392	(None)
palate	8	42	2678	1	pal_ate
paleate	9	41	2000	1	paleate
palmate	11	32	1523	1	palmate
palpated	13	24	976	1	palpated
palpates	12	26	1306	1	palpates
alate	5	53	4032	2	_al_ate
baldpate	13	4	548	2	baldpate
falcate	12	3	1161	2	falcate
galeate	8	39	1678	2	galeate
gallate	8	34	1712	2	gallate
malate	8	46	2455	2	mal_ate
maleate	9	41	1754	2	maleate
palace	10	45	1691	2	pal_ace
palates	9	36	2493	2	pal_ates
paleae	8	48	2029	2	palea_e
palette	9	36	1398	2	palette
palliate	10	3	1189	2	palliate
palmated	13	25	1100	2	palmated
palpable	14	4	803	2	palpable
palpal	10	41	1205	2	palpa_l
palpator	12	4	712	2	palpator
palpitate	13	6	597	2	palpitate
peltate	9	20	1377	2	peltate
pileate	9	38	1592	2	pileate
placate	11	3	1243	2	placate
planate	9	3	1457	2	planate
plate	7	46	3511	2	p_l_ate
pulsate	9	5	1023	2	pulsate
pupate	10	42	1312	2	p_upate
salpae	8	46	1427	2	salpa_e
vallate	10	30	1656	2	vallate
valuate	10	25	1273	2	valuate
valvate	13	37	1081	2	valvate
abate	7	66	2784	3	_a_bate
ablate	8	22	1921	3	_ablate
acuate	8	3	1563	3	_acuate
adnate	7	29	1348	3	_adnate
aerate	6	48	3055	3	_aerate
agate	6	65	2515	3	_a_gate
agnate	7	33	1488	3	_agnate
alae	4	56	4375	3	_al_a_e
alane	5	61	3561	3	_al_ane
alated	7	56	2514	3	_al_ated
alates	6	48	3396	3	_al_ates
albata	8	3	933	3	_albata
albite	8	3	1331	3	_albite
alcade	9	11	1151	3	_alcade
algae	6	53	1962	3	_alga_e
alkane	10	43	1332	3	_alkane
alpaca	10	4	738	3	_alpaca
alpine	8	44	1737	3	_alpine
ansate	6	45	1786	3	_ansate
apace	9	47	1838	3	_a_pace
aplite	8	3	1639	3	apl_ite
aurate	6	44	2647	3	_aurate
aviate	9	3	1520	3	_aviate
baccate	13	10	1126	3	baccate
balata	8	6	1467	3	bal_ata
baldpated	15	4	382	3	baldpated
baldpates	14	4	523	3	baldpates
ballade	10	40	1256	3	ballade
ballute	9	3	854	3	ballute
barbate	11	3	1454	3	barbate
blate	7	59	3378	3	_bl_ate
bullate	9	34	1507	3	bullate
calceate	12	3	986	3	calceate
calcite	11	4	1378	3	calcite
califate	13	3	1048	3	califate
caliphate	16	4	529	3	caliphate
calotte	9	5	1056	3	calotte
calpac	12	32	1106	3	calpa_c
calpack	17	33	833	3	calpack
calpacs	13	31	1034	3	calpacs
calpain	11	3	1041	3	calpain
calycate	15	3	789	3	calycate
capote	10	3	1573	3	ca_pote
carate	8	47	3400	3	ca_rate
carpale	11	34	1435	3	carpale
caseate	9	3	1478	3	caseate
caudate	10	3	1135	3	caudate
ciliate	9	5	1460	3	ciliate
clavate	12	3	871	3	clavate
collate	9	29	1968	3	collate
culpae	10	38	926	3	culpa_e
cuspate	11	3	823	3	cuspate
dealate	8	36	1784	3	deal_ate
delate	7	38	2775	3	del_ate
dilate	7	32	2069	3	dil_ate
elate	5	53	3588	3	_el_ate
eluate	6	23	1543	3	_eluate
epilate	9	3	1428	3	epil_ate
evaluate	11	28	779	3	evaluate
falcated	14	3	847	3	falcated
fellate	10	3	1343	3	fellate
filiate	10	4	1423	3	filiate
folate	9	33	2039	3	fol_ate
foliate	10	5	1353	3	foliate
galatea	8	3	995	3	gal_atea
galeae	7	47	1745	3	galea_e
galeated	10	41	1157	3	galeated
galette	8	42	1269	3	galette
gallates	9	28	1552	3	gallates
galopade	12	4	395	3	galopade
gelate	7	34	2125	3	gel_ate
halite	9	36	2423	3	hal_ite
hamate	11	33	1983	3	ha_mate
haplite	12	3	1070	3	haplite
hastate	10	3	1391	3	hastate
helpmate	15	4	560	3	helpmate
kalifate	15	5	649	3	kalifate
kaliphate	18	4	325	3	kaliphate
kalpa	11	45	1219	3	kalpa__
kalpac	14	42	822	3	kalpa_c
kalpacs	15	32	713	3	kalpacs
kalpak	11	43	724	3	kalpa_k
kalpaks	12	36	616	3	kalpaks
kalpas	12	41	1294	3	kalpa_s
karate	10	53	2092	3	ka_rate
labiate	9	13	1357	3	labiate
lactate	9	3	1269	3	lactate
lanate	6	4	2126	3	la_nate
late	4	75	6048	3	__l_ate
magnate	10	5	1270	3	magnate
malates	9	35	2260	3	mal_ates
maleates	10	33	1634	3	maleates
maltase	9	3	890	3	maltase
mammate	10	44	1127	3	mammate
mandate	10	3	1557	3	mandate
narrate	7	3	1349	3	narrate
oblate	8	22	1474	3	obl_ate
oleate	6	3	1888	3	_oleate
oxalate	14	5	762	3	oxal_ate
package	16	12	801	3	package
paginate	11	40	1244	3	paginate
palaced	12	41	1077	3	pal_aced
palaces	11	42	1645	3	pal_aces
palais	8	4	2042	3	pal_ais
palapa	10	3	1067	3	pal_apa
palapas	11	3	1149	3	palapas
palatal	9	3	1015	3	pal_atal
palatine	10	3	1606	3	pal_atine
palaver	12	3	875	3	pal_aver
pale	6	60	5501	3	pal___e
palea	7	50	2866	3	palea__
paleal	8	47	1667	3	palea_l
paleface	15	4	534	3	paleface
palest	8	39	2622	3	palest_
palet	7	46	5080	3	pal_et_
palets	8	51	2231	3	pal_ets
palettes	10	31	1283	3	palettes
palisade	11	4	583	3	palisade
pallet	8	42	3265	3	pallet_
palleted	11	3	987	3	palleted
pallets	9	39	1930	3	pallets
pallette	10	3	951	3	pallette
palliated	12	3	849	3	palliated
palliates	11	3	1103	3	palliates
palmar	10	41	1346	3	palma_r
palmary	14	33	855	3	palmary
palmately	16	4	444	3	palmately
palmette	12	4	773	3	palmette
palmitate	13	4	641	3	palmitate
palp	8	58	2857	3	palp___
palpably	17	4	536	3	palpably
palpating	14	3	853	3	palpating
palpation	13	3	907	3	palpation
palpators	13	4	679	3	palpators
palpatory	16	4	521	3	palpatory
palped	11	45	1364	3	palp_ed
palpi	9	54	1455	3	palp__i
palping	12	41	1287	3	palping
palpitated	15	4	423	3	palpitated
palpitates	14	4	530	3	palpitates
palps	9	47	1956	3	palp__s
palpus	10	42	1028	3	palp_us
palter	8	44	2326	3	pal__ter
pampa	11	49	1342	3	pampa__
pampas	12	49	1399	3	pampa_s
pancake	15	3	667	3	pancake
panpipe	10	3	483	3	panpipe
papa	8	58	2714	3	pa_pa__
papacy	15	4	749	3	pa_pacy
papain	10	3	1379	3	pa_pain
papal	9	58	2067	3	pa_pa_l
papas	9	49	2749	3	pa_pa_s
papaw	12	51	1249	3	pa_pa_w
papaws	13	41	911	3	pa_paws
papaya	13	3	750	3	pa_paya
papillate	13	12	757	3	papillate
pappose	10	4	741	3	pappose
papule	10	22	1213	3	pa_pule
parade	9	47	2064	3	pa_rade
parae	7	63	3570	3	pa_ra_e
parapet	11	3	1764	3	parapet
parbake	15	3	835	3	parbake
parkade	14	3	758	3	parkade
parlante	10	3	969	3	parlante
partake	13	3	964	3	partake
partite	9	3	1713	3	partite
passade	10	3	923	3	passade
passage	10	3	980	3	passage
paste	7	49	3295	3	pa__ste
pate	6	53	5046	3	___pate
patellate	11	4	748	3	patellate
patinate	10	30	1631	3	patinate
patriate	10	3	1193	3	patriate
pavane	11	41	1344	3	pa_vane
pawnage	13	3	587	3	pawnage
pawpaw	16	5	350	3	pawpa_w
pawpaws	17	3	282	3	pawpaws
pectate	11	22	1469	3	pectate
pedate	9	31	1776	3	p_edate
pelage	9	5	1536	3	pel_age
pelite	8	43	2300	3	pel_ite
pennate	9	33	1403	3	pennate
phenate	12	4	1220	3	phenate
phonate	12	4	1181	3	phonate
phorate	12	4	1336	3	phorate
picrate	11	20	1414	3	picrate
pileated	11	27	1113	3	pileated
pillage	10	34	1260	3	pillage
pinnate	9	36	1374	3	pinnate
pipage	11	9	914	3	p_ipage
pirate	8	23	2288	3	p_irate
placated	13	3	845	3	placated
placater	12	3	801	3	placater
placates	12	3	1175	3	placates
place	9	48	2461	3	p_l_ace
plage	8	45	2040	3	p_l_age
plane	7	49	2914	3	p_l_ane
plat	6	60	4887	3	p_l_at_
platane	9	31	1230	3	platane
plated	9	52	2577	3	p_l_ated
platen	8	45	1820	3	p_l_aten
plater	8	44	2769	3	p_l_ater
plates	8	54	3224	3	p_l_ates
plats	7	55	3137	3	p_l_ats
platy	10	50	2166	3	p_l_aty
playdate	14	6	526	3	playdate
playmate	15	6	646	3	playmate
please	8	43	1573	3	p_lease
pleat	7	47	3447	3	p_leat_
pleated	10	38	1663	3	p_leated
pleater	9	39	1633	3	p_leater
pleats	8	52	1859	3	p_leats
plicate	11	3	1451	3	plicate
plumate	11	4	980	3	plumate
poleaxe	16	5	630	3	poleaxe
polite	8	36	2507	3	pol_ite
pollute	9	3	738	3	pollute
prate	7	51	3598	3	p__rate
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
prepare	11	19	1362	3	prepare
prepaste	12	13	908	3	prepaste
prepave	14	22	887	3	prepave
primate	11	15	1628	3	primate
private	12	15	1326	3	private
probate	11	4	1448	3	probate
prolate	9	4	1979	3	prolate
pronate	9	4	1887	3	pronate
propane	11	27	1615	3	propane
prorate	9	4	1873	3	prorate
pulpal	10	40	845	3	pulpa_l
pulpit	10	3	1093	3	pulpit_
pulpits	11	3	724	3	pulpits
pulsated	11	3	685	3	pulsated
pulsates	10	4	881	3	pulsates
pupae	9	65	1564	3	p_upa_e
pupated	12	31	935	3	p_upated
pupates	11	33	1143	3	p_upates
radiate	8	34	1631	3	radiate
ramate	8	39	2168	3	ra_mate
rampage	12	3	745	3	rampage
relate	6	40	3363	3	rel_ate
replate	9	34	2005	3	replate
saccate	11	13	1176	3	saccate
salivate	11	3	1001	3	salivate
salpa	7	50	1835	3	salpa__
salpas	8	51	1692	3	salpa_s
salute	6	44	1802	3	sal_ute
salvage	11	3	819	3	salvage
sapote	8	3	1436	3	sa_pote
satiate	7	3	1540	3	satiate
savate	9	3	1378	3	sa_vate
slate	5	54	3828	3	_sl_ate
solate	6	45	2607	3	sol_ate
solvate	10	27	1021	3	solvate
spate	7	47	3158	3	__spate
spoliate	10	3	924	3	spoliate
sulcate	9	3	1442	3	sulcate
sulfate	10	3	1165	3	sulfate
sulphate	13	4	664	3	sulphate
tailgate	9	4	682	3	tailgate
tallage	8	27	1207	3	tallage
tannate	7	18	1352	3	tannate
toluate	7	15	934	3	toluate
vacate	11	3	1455	3	va_cate
valerate	11	3	1147	3	valerate
validate	12	3	900	3	validate
valuated	12	23	920	3	valuated
valuates	11	28	1120	3	valuates
variate	10	13	1643	3	variate
velate	9	37	2014	3	vel_ate
volvate	13	31	799	3	volvate
vulgate	11	38	843	3	vulgate
vulvate	13	38	832	3	vulvate
warpage	13	3	640	3	warpage
warpath	15	4	520	3	warpath
zapateo	18	4	459	3	za_pateo

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	311	6.093	21996.9
3	Display Results	311	311	0.123	2528.5
	(SQL Overall)	178691	311	6.622	26984.4