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

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

319 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
spicate	11	32	1419	(None)
spicae	10	43	1370	1	spica_e
spicated	13	30	990	1	spicated
spinate	9	31	1481	1	spinate
aspirate	10	3	994	2	aspirate
auspicate	13	4	574	2	auspicate
epilate	9	3	1428	2	epilate
opiate	8	5	1346	2	opi_ate
picante	11	3	1052	2	_picante
picrate	11	20	1414	2	_picrate
pirate	8	23	2288	2	_pirate
plicate	11	3	1451	2	plicate
saccate	11	13	1176	2	saccate
silicate	10	3	1262	2	silicate
sonicate	10	3	1093	2	sonicate
spate	7	47	3158	2	sp__ate
speciate	12	20	958	2	speciate
spectate	12	24	883	2	spectate
spica	9	47	1794	2	spica__
spicas	10	47	1582	2	spica_s
spiccato	14	6	318	2	spiccato
spice	9	55	2881	2	spic__e
spiculate	13	22	1016	2	spiculate
spicule	11	26	993	2	spicule
spinage	10	28	965	2	spinage
spite	7	54	3066	2	spi__te
sulcate	9	3	1442	2	sulcate
supinate	10	3	1031	2	supinate
suricate	10	3	1261	2	suricate
abdicate	13	4	890	3	abdicate
agitate	8	3	1206	3	agitate
amirate	9	11	1595	3	amirate
animate	9	16	1721	3	animate
apical	10	9	1390	3	apica_l
apicals	11	5	992	3	apicals
apiculate	13	27	988	3	apiculate
asperate	10	3	1237	3	asperate
aspirata	10	5	499	3	aspirata
aspiratae	11	4	335	3	aspiratae
aspirated	12	4	770	3	aspirated
aspirates	11	3	961	3	aspirates
auspicated	15	4	430	3	auspicated
auspicates	14	4	491	3	auspicates
aviate	9	3	1520	3	avi_ate
baccate	13	10	1126	3	baccate
binate	8	4	1977	3	_binate
busticate	13	5	775	3	busticate
capitate	12	17	1218	3	capitate
cate	6	62	5460	3	___cate
chicane	14	8	955	3	chicane
cicale	10	3	1450	3	_cicale
climate	11	3	1283	3	climate
cuspidate	14	4	357	3	cuspidate
dedicate	12	3	1280	3	dedicate
delicate	11	3	1549	3	delicate
depilate	11	3	1170	3	depilate
dictate	10	3	1166	3	_dictate
dilate	7	32	2069	3	_dilate
duplicate	14	4	700	3	duplicate
educate	10	3	1021	3	educate
emirate	9	10	1583	3	emirate
epical	10	4	1339	3	epica_l
epicarp	13	7	607	3	epicarp
epicene	11	4	859	3	epicene
epicure	11	3	682	3	epicure
epidote	10	3	739	3	epidote
epilated	11	3	1075	3	epilated
epilates	10	3	1350	3	epilates
estimate	10	9	1200	3	estimate
estivate	11	10	1000	3	estivate
expiate	16	9	1059	3	expi_ate
explicate	20	11	749	3	explicate
falcate	12	3	1161	3	falcate
fixate	16	3	873	3	_fixate
frigate	11	3	1106	3	frigate
furcate	12	3	1045	3	furcate
imitate	9	3	1087	3	imitate
implicate	15	4	727	3	implicate
indicate	11	3	1335	3	indicate
irate	5	56	2798	3	__irate
lapidate	11	5	790	3	lapidate
ligate	7	25	1925	3	_ligate
locate	8	39	1984	3	_locate
loricate	10	3	1066	3	loricate
masticate	13	4	1128	3	masticate
medicate	13	5	1324	3	medicate
misate	8	12	2269	3	_misate
muricate	12	3	1111	3	muricate
nictate	9	3	1022	3	_nictate
nidate	7	3	1378	3	_nidate
ocicat	10	14	1281	3	ocicat_
ocicats	11	13	741	3	ocicats
operate	9	6	1573	3	operate
opiated	10	3	948	3	opi_ated
opiates	9	3	1214	3	opi_ates
oppilate	12	4	586	3	oppilate
oxidate	15	3	702	3	oxidate
palate	8	42	2678	3	_palate
pate	6	53	5046	3	_p__ate
pectate	11	22	1469	3	_pectate
pedate	9	31	1776	3	_pedate
pica	8	58	3149	3	_pica__
pical	9	55	2437	3	_pica_l
picara	10	3	1190	3	_picara
picaro	10	3	1132	3	_picaro
picas	9	46	2652	3	_pica_s
piccata	13	4	570	3	_piccata
pice	8	46	4109	3	_pic__e
pickaxe	22	4	462	3	_pickaxe
picket	14	49	2431	3	_picket
pickle	14	42	1565	3	_pickle
picot	9	50	3101	3	_picot_
picoted	12	3	921	3	_picoted
picotee	11	3	1147	3	_picotee
picots	10	46	1644	3	_picots
picrated	13	21	1011	3	_picrated
picrates	12	20	1321	3	_picrates
picrite	11	19	1131	3	_picrite
pikake	11	11	580	3	_pikake
pileate	9	38	1592	3	_pileate
pinata	8	38	1722	3	_pinata
pinite	8	3	2124	3	_pinite
pinnate	9	36	1374	3	_pinnate
pipage	11	9	914	3	_pipage
pirated	10	25	1561	3	_pirated
pirates	9	30	2033	3	_pirates
piste	7	58	2460	3	_pi_ste
placate	11	3	1243	3	placate
plate	7	46	3511	3	_p_late
plicae	10	4	1095	3	plica_e
plicated	13	3	1064	3	plicated
prate	7	51	3598	3	_p_rate
primate	11	15	1628	3	primate
private	12	15	1326	3	private
pupate	10	42	1312	3	_pupate
quinate	16	5	1157	3	quinate
radicate	11	4	1287	3	radicate
replicate	13	4	1004	3	replicate
ruinate	7	3	1283	3	ruinate
rusticate	11	4	903	3	rusticate
saccade	12	10	703	3	saccade
saice	7	54	2405	3	saic__e
salivate	11	3	1001	3	salivate
sanitate	8	6	1204	3	sanitate
sate	4	55	5610	3	s___ate
satiate	7	3	1540	3	satiate
savate	9	3	1378	3	s_avate
scale	7	46	2914	3	s__cale
scape	9	69	2184	3	s__cape
scare	7	53	3446	3	s__care
scat	6	58	4837	3	s__cat_
scathe	11	44	1499	3	s__cathe
scats	7	59	3060	3	s__cats
scatt	7	60	3009	3	s__catt
scutate	9	3	1032	3	scutate
scute	7	55	2094	3	s__cute
sedate	7	30	1981	3	s_edate
seiche	11	8	1183	3	seic_he
senate	6	37	2517	3	s_enate
sensate	7	3	1189	3	sensate
separate	10	3	1078	3	separate
septate	9	5	1187	3	septate
seriate	7	37	2247	3	seriate
serrate	7	30	1754	3	serrate
shipmate	15	4	615	3	shipmate
shitake	14	5	562	3	shitake
sibilate	10	4	953	3	sibilate
sice	6	55	4559	3	s_ic__e
sickee	12	46	2222	3	s_ickee
sickie	12	37	1574	3	s_ickie
sickle	12	44	1832	3	s_ickle
sigmate	10	7	1014	3	sigmate
silage	7	27	1530	3	s_ilage
silane	6	27	1805	3	s_ilane
silicates	11	3	1152	3	silicates
sinuate	7	4	1216	3	sinuate
site	4	70	5241	3	s_i__te
situate	7	4	1078	3	situate
sixte	12	62	1658	3	s_i_xte
skate	9	47	2155	3	s__kate
skite	9	51	2005	3	ski__te
slate	5	54	3828	3	s__late
slice	7	49	2582	3	slic__e
slipcase	12	6	392	3	slipcase
smite	7	52	2487	3	smi__te
socage	9	10	1212	3	s_ocage
soccage	12	3	628	3	soccage
soilage	8	16	935	3	soilage
solate	6	45	2607	3	s_olate
solvate	10	27	1021	3	solvate
sonicated	12	4	845	3	sonicated
sonicates	11	4	1038	3	sonicates
sopite	8	49	1771	3	sopi__te
sorbate	9	3	1173	3	sorbate
space	9	53	2567	3	sp__ace
spackle	15	36	957	3	spackle
spade	8	44	2332	3	sp__ade
spae	6	50	3432	3	sp__a_e
spake	11	43	2274	3	sp__ake
spale	7	49	2921	3	sp__ale
spare	7	51	3556	3	sp__are
spat	6	65	4852	3	sp__at_
spates	8	50	2817	3	sp__ates
spathe	11	51	1569	3	sp__athe
spats	7	50	3138	3	sp__ats
speciated	14	20	754	3	speciated
speciates	13	22	923	3	speciates
specie	10	4	1222	3	spec_ie
speckle	15	29	755	3	speckle
spectated	14	23	659	3	spectated
spectates	13	22	881	3	spectates
specter	11	31	1173	3	spec_ter
spectre	11	29	777	3	spectre
speculate	13	23	918	3	speculate
spic	8	52	2743	3	spic___
spiccatos	15	5	325	3	spiccatos
spiced	11	52	1831	3	spic_ed
spicer	10	47	1931	3	spic_er
spicers	11	38	1555	3	spicers
spicery	14	49	901	3	spicery
spices	10	43	2603	3	spic_es
spicey	13	44	1423	3	spic_ey
spicier	11	51	1246	3	spicier
spicily	14	3	865	3	spicily
spicing	12	39	1453	3	spicing
spick	13	45	1907	3	spic__k
spicks	14	48	1499	3	spic_ks
spics	9	41	2324	3	spic__s
spicula	11	25	929	3	spicula
spiculae	12	21	860	3	spiculae
spicules	12	21	980	3	spicules
spicy	12	54	1771	3	spic__y
spigot	9	3	1260	3	spigot_
spigots	10	3	779	3	spigots
spike	11	49	2284	3	spi__ke
spile	7	52	3008	3	spi__le
spillage	11	4	626	3	spillage
spilt	7	55	3222	3	spi_lt_
spilth	11	46	973	3	spi_lth
spinach	14	3	540	3	spinach
spinages	11	28	929	3	spinages
spinal	8	49	1531	3	spina_l
spinals	9	39	1186	3	spinals
spindle	10	32	1009	3	spindle
spine	7	65	3442	3	spi__ne
spinet	8	56	2975	3	spinet_
spinets	9	47	1481	3	spinets
spinose	9	3	794	3	spinose
spinster	10	3	668	3	spinster
spinto	8	4	1066	3	spi_nto
spinule	9	29	999	3	spinule
spiracle	12	5	580	3	spiracle
spiraea	9	40	798	3	spiraea
spiral	8	37	1534	3	spira_l
spiraled	11	3	773	3	spiraled
spirals	9	32	1251	3	spirals
spirant	9	8	1429	3	spirant
spirants	10	8	828	3	spirants
spire	7	58	2869	3	spi__re
spireme	11	47	836	3	spireme
spirit	8	35	1992	3	spirit_
spirited	11	4	897	3	spirited
spirits	9	41	1262	3	spirits
spirt	7	50	3295	3	spi_rt_
spirted	10	39	1307	3	spi_rted
spirts	8	53	1713	3	spi_rts
spit	6	55	4508	3	spi__t_
spital	8	38	1387	3	spita_l
spitals	9	30	1159	3	spitals
spited	9	48	2044	3	spi__ted
spites	8	41	2733	3	spi__tes
spits	7	44	2955	3	spi__ts
spitted	10	39	1270	3	spi_tted
spitter	9	40	1518	3	spi_tter
spittle	9	3	792	3	spittle
spitz	16	60	1797	3	spi__tz
splake	12	5	978	3	sp_lake
splat	7	61	2934	3	sp_lat_
splats	8	48	1730	3	sp_lats
splice	10	49	1510	3	splic__e
spoilage	11	19	537	3	spoilage
spoliate	10	3	924	3	spoliate
sprat	7	66	3597	3	sp_rat_
sprats	8	58	1993	3	sp_rats
sprite	8	44	2177	3	sp_rite
stacte	8	21	1391	3	stac_te
state	5	62	3733	3	s__tate
stickle	13	24	1097	3	stickle
stipitate	11	4	461	3	stipitate
stomate	9	3	1312	3	stomate
striate	7	42	1895	3	striate
stylate	10	17	977	3	stylate
subcaste	12	8	785	3	subcaste
sublate	9	3	1536	3	sublate
suicide	10	3	889	3	suicide
suitcase	10	4	389	3	suitcase
suite	5	48	2956	3	sui__te
sulcated	11	3	1037	3	sulcated
sulfate	10	3	1165	3	sulfate
summate	11	36	1166	3	summate
supinated	12	3	788	3	supinated
supinates	11	3	955	3	supinates
supplicate	16	4	452	3	supplicate
suricates	11	3	1174	3	suricates
syndicate	15	4	451	3	syndicate
thecate	12	32	1002	3	thecate
tipcat	10	3	1265	3	tipcat_
tipcats	11	3	710	3	tipcats
toccate	11	3	877	3	toccate
tunicate	10	33	1004	3	tunicate
update	9	38	1029	3	up_date
uprate	8	39	1654	3	up_rate
upscale	11	13	632	3	upscale
upstate	9	16	1049	3	upstate
urinate	7	3	1536	3	urinate
urticate	10	4	986	3	urticate
vacate	11	3	1455	3	_vacate
vesicate	13	12	1005	3	vesicate
zincate	18	3	853	3	zincate

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	319	6.266	21389.6
3	Display Results	319	319	0.123	2593.5
	(SQL Overall)	178691	319	6.795	26297.4