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

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

327 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
crocket	15	46	1567	(None)
brocket	15	40	1338	1	brocket
cricket	15	47	1695	1	cricket
crochet	14	36	1666	1	crochet
crocked	16	40	1443	1	crocked
crockets	16	33	954	1	crockets
rocket	12	54	2528	1	_rocket
bracket	15	41	1723	2	bracket
brockets	16	32	812	2	brockets
chocked	19	44	1161	2	chocked
clocked	16	41	1283	2	clocked
clocker	15	39	1087	2	clocker
cocked	15	50	2256	2	c_ocked
cocker	14	43	2039	2	c_ocker
cracked	16	35	1474	2	cracked
cracker	15	31	1417	2	cracker
cricked	16	48	1428	2	cricked
crickets	16	41	812	2	crickets
crickey	18	41	814	2	crickey
croaked	14	37	1053	2	croaked
croaker	13	30	1068	2	croaker
crochets	15	35	983	2	crochets
crock	13	59	2199	2	crock__
crockery	19	35	660	2	crockery
crocketed	18	4	512	2	crocketed
crockpot	18	4	429	2	crockpot
crocks	14	51	1842	2	crock_s
crooked	14	39	1094	2	crooked
crooker	13	41	1109	2	crooker
crookest	14	3	668	2	crookest
croquet	18	5	968	2	croquet
crotchet	15	27	1199	2	crotchet
crownet	12	37	1411	2	crownet
docket	13	47	2117	2	_docket
frocked	17	43	933	2	frocked
locket	12	39	2247	2	_locket
pocket	14	46	2262	2	_pocket
pricket	15	36	1644	2	pricket
racket	12	52	2942	2	_racket
rochet	11	54	2300	2	_rochet
rocked	13	50	2232	2	_rocked
rocker	12	43	1957	2	_rocker
rockets	13	46	1536	2	_rockets
socket	12	39	2352	2	_socket
sprocket	16	4	677	2	sprocket
trocked	14	43	1224	2	trocked
arcked	13	62	1194	3	ar_cked
avocet	11	4	1268	3	avoc_et
becket	14	46	1988	3	_becket
blocked	16	44	998	3	blocked
blocker	15	41	992	3	blocker
bosket	12	49	1922	3	_bosket
brachet	14	40	2031	3	brachet
bracken	15	40	981	3	bracken
brackets	16	33	1043	3	brackets
bricked	16	43	1206	3	bricked
brisket	13	44	1340	3	brisket
broche	13	36	1210	3	broche_
brock	13	60	1707	3	brock__
brocks	14	52	1415	3	brock_s
broke	11	60	1978	3	bro_ke_
broken	12	40	1152	3	bro_ken
broker	12	43	1424	3	bro_ker
brooked	14	36	1003	3	brooked
brooklet	14	5	640	3	brooklet
bucket	14	46	2073	3	_bucket
cachet	13	45	2641	3	c_achet
caroche	14	6	924	3	caroche_
caroches	15	7	1069	3	caroches
casket	12	48	2099	3	c_asket
checked	19	37	1002	3	checked
checker	18	32	953	3	checker
chickee	18	31	1155	3	chickee
chicken	18	27	898	3	chicken
chock	16	43	1661	3	chock__
chocks	17	48	1531	3	chock_s
choke	14	51	1802	3	cho_ke_
choked	16	49	1479	3	cho_ked
choker	15	43	1437	3	cho_ker
chokes	15	49	1738	3	cho_kes
chokey	18	48	1171	3	cho_key
chucked	19	46	973	3	chucked
circlet	11	3	1147	3	circlet
clacked	16	41	1360	3	clacked
clacker	15	38	1377	3	clacker
clicked	16	41	1245	3	clicked
clicker	15	41	1188	3	clicker
cloaked	14	36	854	3	cloaked
cloche	13	43	1237	3	cloche_
cloches	14	41	1371	3	cloches
clock	13	49	1798	3	clock__
clockers	16	36	981	3	clockers
clocks	14	49	1623	3	clock_s
clonked	14	42	956	3	clonked
closet	8	52	2660	3	clo_set
clucked	16	38	1013	3	clucked
cock	12	63	3290	3	c_ock__
cockers	15	36	1833	3	c_ockers
cockeye	18	6	722	3	c_ockeye
cockier	15	40	1362	3	c_ockier
cockiest	16	30	1329	3	c_ockiest
cockle	14	39	1357	3	c_ockle
cockled	16	37	1082	3	c_ockled
cockles	15	34	1464	3	c_ockles
cockney	18	3	587	3	c_ockney
cockpit	17	4	799	3	c_ockpit
cocks	13	52	2716	3	c_ock_s
cockup	16	3	571	3	c_ockup
cocky	16	42	1593	3	c_ock_y
coke	10	70	3838	3	c_o_ke_
coked	12	47	3069	3	c_o_ked
cokes	11	55	3719	3	c_o_kes
collet	8	40	3036	3	c_ollet
comet	9	59	4607	3	c_o_met
conked	13	50	1911	3	c_onked
conker	12	47	2155	3	c_onker
cooches	14	35	1583	3	cooches
cooked	13	59	2136	3	c_ooked
cooker	12	47	2245	3	c_ooker
cookey	15	54	1433	3	c_ookey
coquet	17	43	1801	3	c_oquet
corked	13	50	2078	3	c_orked
corker	12	47	2085	3	c_orker
cornet	8	44	3673	3	c_ornet
coronet	9	42	2717	3	coronet
corset	8	56	3622	3	c_orset
corslet	9	3	1806	3	corslet
corvet	11	46	2693	3	c_orvet
coset	7	57	4884	3	c_o_set
cosset	8	41	2586	3	c_osset
covet	10	56	3894	3	c_o_vet
crack	13	41	2053	3	crack__
crackers	16	41	1172	3	crackers
crackle	15	36	1125	3	crackle
crackled	17	42	886	3	crackled
crackles	16	41	1127	3	crackles
crackly	18	39	770	3	crackly
cracknel	16	4	370	3	cracknel
crackpot	18	4	383	3	crackpot
cracks	14	48	1700	3	crack_s
crackup	17	4	356	3	crackup
cracky	17	50	1022	3	crack_y
crake	11	48	2352	3	cr_ake_
crakes	12	49	2181	3	cr_akes
cranked	14	38	1284	3	cranked
cranker	13	36	1278	3	cranker
crankest	14	3	814	3	crankest
creaked	14	34	1323	3	creaked
creche	13	3	1076	3	creche_
creches	14	3	1309	3	creches
cresset	9	33	1994	3	cresset
crick	13	51	1875	3	crick__
cricketed	18	5	468	3	cricketed
cricketer	17	4	456	3	cricketer
cricks	14	43	1605	3	crick_s
crikey	15	31	778	3	cr_ikey
croak	11	52	1663	3	croak__
croakers	14	28	852	3	croakers
croakier	14	43	626	3	croakier
croakiest	15	16	717	3	croakiest
croaks	12	58	1298	3	croak_s
croaky	15	52	848	3	croak_y
croc	8	57	2373	3	croc___
crocein	11	3	807	3	crocein
crocheted	17	4	531	3	crocheted
crocheter	16	4	556	3	crocheter
croci	9	58	1813	3	croc__i
crocine	11	3	1415	3	crocine
crocking	17	43	1344	3	crocking
crockpots	19	4	302	3	crockpots
crocoite	12	4	805	3	crocoite
crocs	9	57	2243	3	croc__s
crocus	10	48	1317	3	croc_us
crocuses	12	3	902	3	crocuses
croft	10	56	2268	3	cro__ft
crofter	12	29	957	3	crofter
crone	7	52	3133	3	cro_ne_
crones	8	47	2924	3	cro_nes
cronies	9	6	2250	3	cronies
crook	11	52	1757	3	crook__
crookery	17	41	599	3	crookery
crooks	12	49	1441	3	crook_s
crooned	10	38	1334	3	crooned
crooner	9	37	1404	3	crooner
cropped	14	38	1206	3	cropped
cropper	13	33	1296	3	cropper
croquets	19	5	521	3	croquets
crore	7	49	2287	3	cro_re_
crores	8	61	2116	3	cro_res
crosier	9	41	1657	3	crosier
crosse	8	52	1630	3	crosse_
crossed	10	53	1389	3	crossed
crosser	9	50	1546	3	crosser
crosses	9	42	2079	3	crosses
crossest	10	120	1212	3	crossest
crosslet	10	4	959	3	crosslet
crotched	16	42	859	3	crotched
crotches	15	34	1130	3	crotches
crotchets	16	39	630	3	crotchets
crotchety	19	40	381	3	crotchety
crouched	16	35	914	3	crouched
crouches	15	37	1129	3	crouches
croupe	10	51	1443	3	croupe_
croupes	11	46	1310	3	croupes
crouse	8	46	1936	3	crouse_
croute	8	46	1727	3	croute_
croutes	9	48	1565	3	croutes
crowded	14	41	879	3	crowded
crowder	13	38	986	3	crowder
crowed	12	47	1730	3	cro_wed
crower	11	41	1756	3	cro_wer
crowfeet	16	4	556	3	crowfeet
crowned	13	39	1243	3	crowned
crowner	12	40	1260	3	crowner
crownets	13	40	767	3	crownets
croze	16	47	1945	3	cro_ze_
crozer	17	51	1284	3	cro_zer
crozes	17	44	1766	3	cro_zes
crozier	18	36	993	3	crozier
cruces	10	51	1754	3	cruc_es
cruck	13	56	1532	3	cruck__
crucks	14	44	1258	3	cruck_s
cruet	7	48	3184	3	cr__uet
crumpet	13	37	1106	3	crumpet
cruset	8	44	2509	3	cr_uset
docked	14	50	1833	3	_docked
docker	13	44	1765	3	_docker
dockets	14	44	1224	3	_dockets
droplet	10	3	1211	3	droplet
drouked	13	3	554	3	drouked
flocked	17	45	1025	3	flocked
frisket	14	38	1177	3	frisket
frock	14	53	1465	3	frock__
frocks	15	41	1121	3	frock_s
froglet	11	3	1006	3	froglet
grocer	9	42	1214	3	groc_er
grokked	12	3	367	3	grokked
grommet	12	26	845	3	grommet
hocked	16	55	2130	3	_hocked
hocker	15	51	1856	3	_hocker
hockey	18	48	1315	3	_hockey
jacket	19	47	2067	3	_jacket
jockey	22	40	803	3	_jockey
knocked	13	23	630	3	knocked
knocker	12	29	639	3	knocker
locked	13	49	2166	3	_locked
locker	12	40	1942	3	_locker
lockets	13	46	1220	3	_lockets
lockset	13	3	1116	3	_lockset
mocked	15	47	1661	3	_mocked
mocker	14	33	1544	3	_mocker
nocked	13	46	1738	3	_nocked
ocker	11	39	1575	3	__ocker
octet	7	3	2406	3	__octet
packet	14	47	2650	3	_packet
picket	14	49	2431	3	_picket
placket	15	4	1287	3	placket
pocked	15	48	1898	3	_pocked
pockets	15	46	1225	3	_pockets
pricked	16	46	1383	3	pricked
pricker	15	40	1341	3	pricker
prickets	16	32	908	3	prickets
proceed	12	3	1055	3	proceed
projet	15	3	1518	3	pro_jet
prophet	14	3	1603	3	prophet
propjet	18	3	991	3	propjet
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
ricked	13	65	2362	3	_ricked
rickets	13	49	1509	3	_rickets
rickety	16	47	831	3	_rickety
rickey	15	46	1397	3	_rickey
rochets	12	42	1347	3	_rochets
rock	10	57	3518	3	_rock__
rockers	13	39	1655	3	_rockers
rockery	16	43	925	3	_rockery
rocketed	15	15	779	3	_rocketed
rocketer	14	15	833	3	_rocketer
rocketry	17	4	450	3	_rocketry
rockier	13	49	1188	3	_rockier
rockiest	14	29	1222	3	_rockiest
rocks	11	46	2641	3	_rock_s
rocky	14	45	1385	3	_rock_y
rooked	11	49	1814	3	_rooked
roquet	15	44	1589	3	_roquet
roset	5	59	4524	3	_ro_set
roupet	8	42	1834	3	_roupet
rucked	13	47	1876	3	_rucked
shocked	17	46	1181	3	shocked
shocker	16	34	1143	3	shocker
skyrocket	17	5	267	3	skyrocket
smocked	16	39	822	3	smocked
socked	13	47	2150	3	_socked
sockets	13	40	1298	3	_sockets
sprockets	17	4	325	3	sprockets
stocked	14	43	1287	3	stocked
stocker	13	37	1308	3	stocker
tacket	12	46	2749	3	_tacket
thicket	16	32	1307	3	thicket
ticket	12	45	2485	3	_ticket
tracked	14	37	1613	3	tracked
tracker	13	35	1517	3	tracker
tricked	14	40	1616	3	tricked
tricker	13	46	1552	3	tricker
trinket	11	3	1481	3	trinket
troaked	12	43	825	3	troaked
troche	11	31	1251	3	troche_
trochee	12	26	1388	3	trochee
troches	12	37	1534	3	troches
trock	11	48	1760	3	trock__
trocks	12	36	1463	3	trock_s
troke	9	48	2105	3	tro_ke_
troked	11	41	1458	3	tro_ked
trokes	10	40	1926	3	tro_kes
trucked	14	39	1081	3	trucked
trucker	13	40	1073	3	trucker
tucket	12	42	1948	3	_tucket
wicket	15	53	1894	3	_wicket
wracked	17	41	1011	3	wracked
wrecked	17	41	833	3	wrecked
wrecker	16	36	760	3	wrecker
wricked	17	49	1019	3	wricked
yocked	16	41	1442	3	_yocked

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.406	440125.6
2	DLD Change Limit	134027	327	6.856	19548.9
3	Display Results	327	327	0.110	2972.7
	(SQL Overall)	178691	327	7.372	24239.1