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

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

328 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
pricket	15	36	1644	(None)
cricket	15	47	1695	1	cricket
picket	14	49	2431	1	p_icket
pricked	16	46	1383	1	pricked
pricker	15	40	1341	1	pricker
prickets	16	32	908	1	prickets
bracket	15	41	1723	2	bracket
bricked	16	43	1206	2	bricked
brisket	13	44	1340	2	brisket
brocket	15	40	1338	2	brocket
cricked	16	48	1428	2	cricked
crickets	16	41	812	2	crickets
crickey	18	41	814	2	crickey
crocket	15	46	1567	2	crocket
frisket	14	38	1177	2	frisket
packet	14	47	2650	2	p_acket
picked	15	44	2131	2	p_icked
picker	14	44	2217	2	p_icker
pickets	15	43	1418	2	p_ickets
placket	15	4	1287	2	placket
pocket	14	46	2262	2	p_ocket
price	9	37	2541	2	pric_e_
priced	11	50	1888	2	pric_ed
pricer	10	39	1829	2	pric_er
prices	10	45	2454	2	pric_es
pricey	13	44	1263	2	pric_ey
pricier	11	33	1311	2	pricier
priciest	12	21	1290	2	priciest
prick	13	43	1750	2	prick__
prickers	16	37	1067	2	prickers
prickier	16	36	814	2	prickier
prickiest	17	4	818	2	prickiest
prickle	15	36	1101	2	prickle
prickled	17	35	807	2	prickled
prickles	16	25	1110	2	prickles
prickly	18	36	789	2	prickly
pricks	14	44	1426	2	prick_s
pricky	17	42	1034	2	prick_y
prinked	14	34	1216	2	prinked
prinker	13	34	1274	2	prinker
privet	11	38	2134	2	pri_vet
racket	12	52	2942	2	_racket
ricked	13	65	2362	2	_ricked
rickets	13	49	1509	2	_rickets
rickety	16	47	831	2	_rickety
rickey	15	46	1397	2	_rickey
rocket	12	54	2528	2	_rocket
sprocket	16	4	677	2	sprocket
thicket	16	32	1307	2	thicket
ticket	12	45	2485	2	_ticket
tricked	14	40	1616	2	tricked
tricker	13	46	1552	2	tricker
trinket	11	3	1481	2	trinket
wicket	15	53	1894	2	_wicket
wricked	17	49	1019	2	wricked
apricot	11	10	1018	3	apric_ot
arcked	13	62	1194	3	ar_cked
becket	14	46	1988	3	_becket
bicker	14	48	1917	3	_bicker
brachet	14	40	2031	3	brachet
bracken	15	40	981	3	bracken
brackets	16	33	1043	3	brackets
brick	13	46	1815	3	brick__
brickbat	18	5	363	3	brickbat
brickier	16	30	716	3	brickier
brickiest	17	3	743	3	brickiest
brickle	15	27	993	3	brickle
brickles	16	28	1028	3	brickles
bricks	14	46	1462	3	brick_s
bricky	17	48	909	3	brick_y
briquet	18	3	883	3	briquet
brisked	14	42	1000	3	brisked
brisker	13	42	1029	3	brisker
briskest	14	33	780	3	briskest
briskets	14	34	656	3	briskets
brockets	16	32	812	3	brockets
bucket	14	46	2073	3	_bucket
chickee	18	31	1155	3	chickee
chicken	18	27	898	3	chicken
circlet	11	3	1147	3	circlet
clicked	16	41	1245	3	clicked
clicker	15	41	1188	3	clicker
cracked	16	35	1474	3	cracked
cracker	15	31	1417	3	cracker
crick	13	51	1875	3	crick__
cricketed	18	5	469	3	cricketed
cricketer	17	4	457	3	cricketer
cricks	14	43	1605	3	crick_s
crikey	15	31	778	3	cri_key
crochet	14	36	1666	3	crochet
crocked	16	40	1444	3	crocked
crockets	16	33	954	3	crockets
dicked	14	49	2086	3	_dicked
dicker	13	45	2140	3	_dicker
dickey	16	59	1352	3	_dickey
docket	13	47	2117	3	_docket
driblet	10	37	1224	3	driblet
drinker	12	34	948	3	drinker
flicked	17	46	1067	3	flicked
flicker	16	36	1062	3	flicker
frisked	15	47	882	3	frisked
frisker	14	38	927	3	frisker
friskets	15	32	626	3	friskets
frocked	17	43	933	3	frocked
grivet	10	35	1782	3	gri_vet
hickey	18	50	1199	3	_hickey
hoicked	17	3	596	3	hoicked
icker	11	40	1844	3	__icker
jacket	19	47	2067	3	_jacket
kicked	12	44	1594	3	_kicked
kicker	11	41	1618	3	_kicker
licked	13	46	2156	3	_licked
licker	12	52	2204	3	_licker
locket	12	39	2247	3	_locket
mickey	17	42	1185	3	_mickey
nicked	13	50	1968	3	_nicked
nickel	12	38	1134	3	_nickel
nicker	12	38	1870	3	_nicker
packed	15	48	2260	3	p_acked
packer	14	42	2340	3	p_acker
packets	15	51	1477	3	p_ackets
paiked	13	51	1343	3	pai_ked
panicked	17	8	517	3	panicked
parroket	14	4	921	3	parroket
pecked	15	50	1910	3	p_ecked
pecker	14	46	1536	3	p_ecker
pernickety	21	5	170	3	pernickety
pice	8	46	4110	3	p_ic_e_
pick	12	59	3382	3	p_ick__
pickax	21	3	591	3	p_ickax
pickeer	15	37	1011	3	p_ickeer
pickers	15	37	1809	3	p_ickers
picketed	17	16	738	3	p_icketed
picketer	16	18	743	3	p_icketer
pickier	15	39	1297	3	p_ickier
pickiest	16	27	1259	3	p_ickiest
pickle	14	42	1565	3	p_ickle
pickled	16	40	1188	3	p_ickled
pickles	15	32	1544	3	p_ickles
picks	13	52	2614	3	p_ick_s
pickup	16	5	563	3	p_ickup
picky	16	54	1694	3	p_ick_y
picot	9	50	3101	3	p_ic_ot
picquet	20	4	774	3	p_icquet
piglet	9	34	2092	3	p_iglet
pike	10	63	3522	3	p_i_ke_
piked	12	56	2331	3	p_i_ked
piker	11	56	2284	3	p_i_ker
pikes	11	50	3103	3	p_i_kes
pinked	13	48	1988	3	p_inked
pinken	12	45	1328	3	p_inken
pinker	12	53	2244	3	p_inker
pinkest	13	28	1262	3	p_inkest
pinkey	15	43	1467	3	p_inkey
piolet	8	32	2564	3	p_iolet
pipet	9	55	3332	3	p_i_pet
piquet	17	4	1235	3	p_iquet
placet	10	39	2367	3	plac_et
plackets	16	4	658	3	plackets
plicae	10	4	1095	3	plicae_
plicate	11	3	1451	3	plicate
plinked	14	39	1089	3	plinked
plinker	13	40	1097	3	plinker
plucked	16	36	796	3	plucked
plucker	15	36	825	3	plucker
pocked	15	48	1898	3	p_ocked
pockets	15	46	1225	3	p_ockets
pranked	14	37	1209	3	pranked
precast	11	3	1485	3	precast
precent	11	35	2026	3	precent
precept	13	31	1251	3	precept
precut	10	20	1653	3	prec_ut
premeet	11	6	1515	3	premeet
preset	8	44	3098	3	pr_eset
pricers	11	39	1506	3	pricers
pricily	14	27	1028	3	pricily
pricing	12	34	1734	3	pricing
pricking	17	32	1260	3	pricking
pricklier	17	24	506	3	pricklier
prickliest	18	4	529	3	prickliest
pricy	12	48	1456	3	pric__y
pride	8	47	2474	3	pri_de_
prided	10	36	1803	3	pri_ded
prides	9	43	2418	3	pri_des
pried	8	44	2686	3	pri__ed
prier	7	50	2776	3	pri__er
pries	7	43	3953	3	pri__es
priest	8	41	2542	3	pri_est
prigged	12	39	893	3	prigged
prilled	10	47	1300	3	prilled
primate	11	15	1628	3	primate
prime	9	65	2560	3	pri_me_
primed	11	51	1891	3	pri_med
primer	10	51	1868	3	pri_mer
primes	10	42	2526	3	pri_mes
primmed	14	38	885	3	primmed
primmer	13	43	1016	3	primmer
primmest	14	22	669	3	primmest
primped	14	47	915	3	primped
prince	10	41	1476	3	prince_
princelet	13	4	653	3	princelet
princes	11	30	1515	3	princes
prink	11	47	1967	3	prink__
prinkers	14	30	1039	3	prinkers
prinks	12	43	1538	3	prink_s
print	7	48	3746	3	pri__nt
printed	10	40	1637	3	printed
printer	9	39	1730	3	printer
prise	7	46	3261	3	pri_se_
prised	9	43	2220	3	pri_sed
prises	8	41	3317	3	pri_ses
prissed	10	33	1126	3	prissed
prisses	9	48	1671	3	prisses
prithee	12	3	993	3	prithee
private	12	15	1326	3	private
privets	12	29	1005	3	pri_vets
privier	12	29	1045	3	privier
privies	12	24	1426	3	privies
priviest	13	23	1031	3	priviest
prize	16	47	1894	3	pri_ze_
prized	18	44	1539	3	pri_zed
prizer	17	47	1488	3	pri_zer
prizes	17	38	1981	3	pri_zes
proceed	12	3	1055	3	proceed
projet	15	3	1518	3	pr_ojet
prophet	14	3	1603	3	prophet
propjet	18	3	991	3	propjet
pucker	14	38	1763	3	p_ucker
quicken	22	3	515	3	quicken
quicker	22	4	702	3	quicker
quickest	23	4	534	3	quickest
quickset	23	4	536	3	quickset
rachet	11	50	2897	3	_rachet
racked	13	45	2608	3	_racked
racker	12	48	2455	3	_racker
rackets	13	49	1687	3	_rackets
rackety	16	49	911	3	_rackety
recked	13	48	2180	3	_recked
riblet	8	42	2244	3	_riblet
rice	6	49	4292	3	_ric_e_
riced	8	58	2554	3	_ric_ed
ricer	7	47	2661	3	_ric_er
rices	7	55	3615	3	_ric_es
richen	11	38	1251	3	_richen
richer	11	40	1504	3	_richer
riches	11	50	2208	3	_riches
richest	12	28	1368	3	_richest
rick	10	73	3466	3	_rick__
rickeys	16	54	898	3	_rickeys
ricks	11	51	2613	3	_rick_s
rillet	6	48	2885	3	_rillet
risked	11	55	1463	3	_risked
risker	10	54	1449	3	_risker
rivet	8	56	3636	3	_ri_vet
rochet	11	54	2300	3	_rochet
rocked	13	50	2232	3	_rocked
rocker	12	43	1957	3	_rocker
rockets	13	46	1536	3	_rockets
rucked	13	47	1876	3	_rucked
shicker	16	39	1482	3	shicker
sicked	13	45	2440	3	_sicked
sickee	12	46	2222	3	_sickee
sicken	12	46	1525	3	_sicken
sicker	12	40	2390	3	_sicker
sickest	13	18	1379	3	_sickest
slicked	14	44	1384	3	slicked
slicken	13	30	929	3	slicken
slicker	13	33	1453	3	slicker
slickest	14	22	925	3	slickest
snicked	14	38	1163	3	snicked
snicker	13	30	1267	3	snicker
socket	12	39	2352	3	_socket
sprockets	17	4	325	3	sprockets
sticked	14	41	1463	3	sticked
sticker	13	35	1588	3	sticker
stickit	13	3	946	3	stickit
stricken	14	3	689	3	stricken
tacket	12	46	2749	3	_tacket
thicken	16	31	787	3	thicken
thicker	16	36	1102	3	thicker
thickest	17	33	730	3	thickest
thickets	17	28	708	3	thickets
thickety	20	27	410	3	thickety
thickset	17	25	713	3	thickset
ticked	13	47	2052	3	_ticked
ticker	12	43	2150	3	_ticker
tickets	13	41	1368	3	_tickets
tracked	14	37	1613	3	tracked
tracker	13	35	1517	3	tracker
trice	7	51	2749	3	tric_e_
triced	9	55	1867	3	tric_ed
tricep	10	39	1107	3	tric_ep
trices	8	48	2633	3	tric_es
trick	11	54	2069	3	trick__
trickers	14	38	1281	3	trickers
trickery	17	29	734	3	trickery
trickie	13	26	1103	3	trickie
trickier	14	30	1023	3	trickier
trickiest	15	4	902	3	trickiest
trickle	13	36	1344	3	trickle
trickled	15	26	1043	3	trickled
trickles	14	30	1376	3	trickles
trickly	16	36	989	3	trickly
tricks	12	53	1901	3	trick_s
tricksy	16	43	658	3	tricksy
tricky	15	42	1147	3	trick_y
tricot	8	3	1775	3	tric_ot
trijet	13	39	1655	3	tri_jet
trike	9	53	2016	3	tri_ke_
trikes	10	54	1949	3	tri_kes
trinkets	12	3	714	3	trinkets
triolet	7	32	1952	3	triolet
triplet	9	43	1921	3	triplet
trippet	11	37	1411	3	trippet
trivet	9	37	2188	3	tri_vet
trocked	14	43	1224	3	trocked
trucked	14	39	1081	3	trucked
trucker	13	40	1073	3	trucker
tucket	12	42	1948	3	_tucket
whicker	19	35	977	3	whicker
wicked	16	43	1741	3	_wicked
wicker	15	45	1867	3	_wicker
wickets	16	40	1094	3	_wickets
wracked	17	41	1011	3	wracked
wrecked	17	41	833	3	wrecked
wrecker	16	36	760	3	wrecker
wrick	14	40	1339	3	wrick__
wricks	15	46	1062	3	wrick_s

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.420	425454.8
2	DLD Change Limit	134027	328	7.033	19056.9
3	Display Results	328	328	0.110	2981.8
	(SQL Overall)	178691	328	7.563	23627.0