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

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

294 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
picrate	11	20	1414	(None)
picrated	13	21	1011	1	picrated
picrates	12	20	1320	1	picrates
picrite	11	19	1131	1	picrite
pirate	8	23	2288	1	pi_rate
cirrate	9	24	1348	2	cirrate
citrate	9	22	1679	2	citrate
crate	7	65	3740	2	__crate
dictate	10	3	1166	2	dictate
disrate	8	14	1852	2	disrate
irate	5	56	2798	2	_i_rate
librate	9	32	1423	2	librate
migrate	10	13	1416	2	migrate
misrate	9	13	1914	2	misrate
nictate	9	3	1022	2	nictate
nitrate	7	20	1701	2	nitrate
pectate	11	22	1469	2	pectate
phorate	12	4	1336	2	phorate
picante	11	3	1052	2	picante
piccata	13	4	570	2	piccata
pickaxe	22	4	462	2	pickaxe
picrites	12	18	1108	2	picrites
pileate	9	38	1592	2	pileate
pinnate	9	36	1374	2	pinnate
pirated	10	25	1561	2	pi_rated
pirates	9	30	2032	2	pi_rates
plicate	11	3	1451	2	plic_ate
prate	7	51	3598	2	p__rate
priorate	10	4	1173	2	priorate
prorate	9	4	1873	2	prorate
recrate	9	26	2164	2	recrate
spicate	11	32	1419	2	spic_ate
titrate	7	22	1557	2	titrate
uncrate	9	4	1595	2	uncrate
vibrate	12	28	1151	2	vibrate
vicarate	13	7	860	2	vicarate
accrete	11	3	784	3	accrete
accurate	12	4	1066	3	accurate
acerate	9	28	1891	3	acerate
acierate	10	3	1181	3	acierate
acuate	8	3	1563	3	_acuate
aerate	6	48	3055	3	_aerate
airdate	8	3	1132	3	airdate
amirate	9	11	1595	3	amirate
apiculate	13	27	988	3	apiculate
arcuate	9	3	1196	3	arcuate
aspirate	10	3	994	3	aspi_rate
aurate	6	44	2647	3	_aurate
baccate	13	10	1126	3	baccate
berate	8	47	2902	3	_berate
biforate	13	4	690	3	biforate
binate	8	4	1977	3	bi_nate
bistate	9	3	1381	3	bistate
borate	8	50	2615	3	_borate
carate	8	47	3400	3	_carate
carte	7	59	4042	3	__carte
cate	6	62	5459	3	__c_ate
cerate	8	48	2946	3	_cerate
cicale	10	3	1450	3	cic_ale
ciliate	9	5	1459	3	ciliate
citrated	11	27	1224	3	citrated
citrates	10	23	1507	3	citrates
cocreate	12	26	1181	3	cocreate
crake	11	48	2352	3	__crake
crane	7	53	3160	3	__crane
crape	9	61	2844	3	__crape
crated	9	48	2777	3	__crated
crater	8	50	2663	3	__crater
crates	8	57	3605	3	__crates
crave	10	56	2631	3	__crave
craze	16	52	2146	3	__craze
create	8	51	2637	3	__create
curate	8	52	2624	3	_curate
decorate	11	3	1519	3	decorate
derate	7	45	3123	3	_derate
dictated	12	3	920	3	dictated
dictates	11	3	1137	3	dictates
dilate	7	32	2069	3	di_late
diorite	8	3	1491	3	diorite
discrete	11	4	1028	3	discrete
disrated	10	9	1557	3	disrated
disrates	9	11	1814	3	disrates
ecarte	8	43	1350	3	_ecarte
emigrate	11	4	960	3	emigrate
emirate	9	10	1583	3	emirate
ephorate	13	5	950	3	ephorate
epilate	9	3	1428	3	epi_late
eucrite	9	3	990	3	eucrite
excrete	16	6	716	3	excrete
execrate	17	3	964	3	execrate
ferrate	10	30	1403	3	ferrate
figurate	12	3	718	3	figurate
filiate	10	4	1423	3	filiate
filtrate	11	4	822	3	filtrate
fissate	10	30	1003	3	fissate
fixate	16	3	873	3	fi_xate
furcate	12	3	1045	3	furcate
grate	6	49	3288	3	__grate
gyrate	10	49	1252	3	_gyrate
hydrate	14	23	981	3	hydrate
ideate	7	3	1368	3	_ideate
increate	10	3	1220	3	increate
ingate	7	30	1823	3	_ingate
ingrate	8	7	1511	3	ingrate
inmate	8	29	1735	3	_inmate
innate	6	39	1731	3	_innate
iodate	7	3	1350	3	_iodate
irade	6	56	1815	3	_i_rade
irater	6	52	1834	3	_i_rater
iterate	7	11	1910	3	iterate
karate	10	53	2092	3	_karate
lacerate	10	22	1470	3	lacerate
lactate	9	3	1269	3	lactate
liberate	10	11	1338	3	liberate
librae	8	43	1017	3	libra_e
librated	11	31	1031	3	librated
librates	10	34	1293	3	librates
licente	9	12	1089	3	licente
ligate	7	25	1924	3	li_gate
limbate	11	3	921	3	limbate
lineate	7	8	1515	3	lineate
liquate	16	3	841	3	liquate
literate	8	12	1688	3	literate
locate	8	39	1984	3	loc_ate
lyrate	9	41	1210	3	_lyrate
macerate	12	23	1407	3	macerate
macrame	13	3	871	3	macrame
micra	9	62	1497	3	micra__
microbe	13	3	866	3	microbe
micturate	13	6	664	3	micturate
migrated	12	11	1049	3	migrated
migrates	11	11	1284	3	migrates
mirage	9	23	1365	3	mi_rage
misate	8	12	2269	3	mi_sate
miscreate	13	4	889	3	miscreate
misdate	10	14	1396	3	misdate
mismate	11	14	1535	3	mismate
misrated	11	13	1538	3	misrated
misrates	10	13	1823	3	misrates
narrate	7	3	1349	3	narrate
nictated	11	3	779	3	nictated
nictates	10	3	958	3	nictates
nidate	7	3	1378	3	ni_date
niobate	9	3	770	3	niobate
nitrated	9	22	1315	3	nitrated
nitrates	8	25	1620	3	nitrates
nitrite	7	23	1446	3	nitrite
ocreate	9	37	1174	3	_ocreate
operate	9	6	1573	3	operate
opiate	8	5	1346	3	opi__ate
orate	5	51	3330	3	__orate
outrate	7	23	2318	3	outrate
overate	10	6	2096	3	overate
package	16	12	801	3	package
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
parade	9	47	2064	3	p_arade
parae	7	63	3570	3	p_ara_e
pate	6	53	5046	3	p___ate
patriate	10	3	1193	3	patriate
pectase	11	24	1036	3	pectase
pectates	12	22	1393	3	pectates
peculate	12	24	1466	3	peculate
pedate	9	31	1776	3	p_edate
peerage	10	8	980	3	peerage
peltate	9	20	1377	3	peltate
pennate	9	33	1403	3	pennate
percale	11	3	1408	3	percale
perorate	10	4	1791	3	perorate
petrale	9	3	1262	3	petrale
phenate	12	4	1219	3	phenate
phonate	12	4	1181	3	phonate
phorates	13	4	1304	3	phorates
phrase	11	10	990	3	p_hrase
pica	8	58	3149	3	pic_a__
pical	9	55	2437	3	pic_a_l
picara	10	3	1190	3	pic_ara
picaras	11	3	1127	3	picaras
picaro	10	3	1132	3	pic_aro
picaros	11	3	1089	3	picaros
picas	9	46	2652	3	pic_a_s
pice	8	46	4109	3	pic___e
pickax	21	3	591	3	picka_x
pickaxed	24	4	351	3	pickaxed
pickaxes	23	4	491	3	pickaxes
picket	14	49	2431	3	picket_
picketed	17	16	738	3	picketed
picketer	16	18	743	3	picketer
pickets	15	43	1418	3	pickets
pickle	14	42	1565	3	pic_kle
picot	9	50	3101	3	pic_ot_
picoted	12	3	921	3	pic_oted
picotee	11	3	1147	3	picotee
picots	10	46	1644	3	pic_ots
picowave	18	10	279	3	picowave
picquet	20	4	774	3	picquet
picric	12	30	992	3	picr_ic
picritic	14	4	826	3	picritic
picture	11	5	861	3	picture
pierce	10	40	1039	3	pier_ce
pikake	11	11	580	3	pi_kake
pileated	11	27	1113	3	pileated
pillage	10	34	1259	3	pillage
pinata	8	38	1721	3	pi_nata
pinite	8	3	2124	3	pi_nite
pinnace	11	35	1031	3	pinnace
pinnae	8	44	1464	3	pinna_e
pinnated	11	33	855	3	pinnated
pinwale	12	5	784	3	pinwale
pipage	11	9	914	3	pi_page
pipeage	12	3	620	3	pipeage
pipette	11	3	794	3	pipette
piracy	13	3	947	3	pi_racy
pirana	8	7	1326	3	pi_rana
piratic	11	3	1429	3	pi_ratic
piraya	11	6	771	3	pi_raya
piste	7	58	2460	3	pi__ste
placate	11	3	1243	3	placate
planate	9	3	1457	3	planate
plate	7	46	3511	3	p__late
plicae	10	4	1095	3	plic_a_e
plicated	13	3	1064	3	plic_ated
plumate	11	4	980	3	plumate
prase	7	61	2875	3	p__rase
prat	6	59	5204	3	p__rat_
prated	9	49	2492	3	p__rated
prater	8	48	2535	3	p__rater
prates	8	46	3316	3	p__rates
prats	7	63	3339	3	p__rats
predate	10	6	1689	3	predate
prelate	9	5	1969	3	prelate
prerace	11	4	1412	3	prerace
primate	11	15	1628	3	primate
priorates	11	4	1075	3	priorates
private	12	15	1326	3	private
probate	11	4	1448	3	probate
procreate	13	4	813	3	procreate
prolate	9	4	1979	3	prolate
pronate	9	4	1887	3	pronate
prorated	11	5	1371	3	prorated
prorates	10	4	1806	3	prorates
pulsate	9	5	1023	3	pulsate
punctate	12	4	647	3	punctate
pupate	10	42	1312	3	p_upate
pyrite	11	9	1331	3	p_yrite
rate	4	54	5876	3	___rate
recrated	11	29	1858	3	recrated
recrates	10	24	2035	3	recrates
recreate	10	3	1360	3	recreate
regrate	8	26	1865	3	regrate
ricrac	10	3	701	3	ricra_c
ricracs	11	3	636	3	ricracs
saccate	11	13	1176	3	saccate
scrape	10	59	1757	3	_scrape
secrete	9	3	1107	3	secrete
serrate	7	30	1753	3	serrate
sigmate	10	7	1012	3	sigmate
sinuate	7	4	1215	3	sinuate
situate	7	4	1077	3	situate
speciate	12	20	958	3	speciate
spectate	12	24	883	3	spectate
spicae	10	43	1370	3	spic_a_e
spicated	13	30	990	3	spic_ated
spiccato	14	6	318	3	spiccato
spiculate	13	22	1016	3	spiculate
spinate	9	31	1481	3	spi_nate
sucrase	9	3	1034	3	sucrase
tirade	7	3	1169	3	ti_rade
titrated	9	26	1168	3	titrated
titrates	8	23	1464	3	titrates
toccate	11	3	877	3	toccate
ulcerate	10	3	973	3	ulcerate
uncrated	11	4	1631	3	uncrated
uncrates	10	3	1455	3	uncrates
uncreate	10	3	1135	3	uncreate
uprate	8	39	1654	3	_uprate
urate	5	54	3216	3	__urate
vacate	11	3	1455	3	vac_ate
vibrated	14	22	838	3	vibrated
vibrates	13	22	1059	3	vibrates
vibrato	12	24	738	3	vibrato
vicarage	14	4	443	3	vicarage
vicarates	14	8	761	3	vicarates
vicariate	14	7	635	3	vicariate
vicomte	14	4	572	3	vicomte
violate	10	3	1155	3	violate
virgate	11	3	873	3	virgate
vitiate	10	34	1295	3	vitiate
vittate	10	40	972	3	vittate
vizirate	20	4	535	3	vizirate
wickape	18	4	372	3	wickape
zincate	18	3	853	3	zincate

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.140	1276364.3
2	DLD Change Limit	134027	294	7.360	18210.2
3	Display Results	294	294	0.110	2672.7
	(SQL Overall)	178691	294	7.610	23481.1