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

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

170 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
chuckle	18	3	644	(None)
chuckled	20	4	516	1	chuckled
chuckler	19	3	555	1	chuckler
chuckles	19	3	680	1	chuckles
huckle	15	39	1307	1	_huckle
buckle	14	48	1519	2	_buckle
cackle	14	34	1692	2	c_ackle
chickee	18	31	1155	2	chickee
chicle	13	43	1254	2	chic_le
chuck	16	48	1487	2	chuck__
chucked	19	46	973	2	chucked
chuckhole	23	5	240	2	chuckhole
chuckies	19	3	770	2	chuckies
chucklers	20	3	444	2	chucklers
chucks	17	48	1293	2	chuck_s
chucky	20	41	800	2	chuck_y
cockle	14	39	1357	2	c_ockle
crackle	15	36	1125	2	crackle
hackle	15	49	1681	2	_hackle
heckle	15	31	1209	2	_heckle
huckles	16	36	1262	2	_huckles
knuckle	12	5	423	2	knuckle
muckle	14	34	1358	2	_muckle
ruckle	12	44	1458	2	_ruckle
shackle	16	40	954	2	shackle
suckle	12	40	1596	2	_suckle
truckle	13	35	886	2	truckle
boucle	10	37	1278	3	bouc_le
brickle	15	27	993	3	brickle
buckled	16	44	1188	3	_buckled
buckler	15	41	1203	3	_buckler
buckles	15	34	1609	3	_buckles
cackled	16	46	1330	3	c_ackled
cackler	15	38	1257	3	c_ackler
cackles	15	37	1720	3	c_ackles
caudle	9	39	1291	3	cau_dle
check	16	47	1471	3	check__
checkable	22	4	474	3	checkable
checked	19	37	1002	3	checked
checker	18	32	953	3	checker
checkless	20	4	423	3	checkless
checks	17	49	1270	3	check_s
checkup	20	4	332	3	checkup
chicane	14	8	955	3	chicane
chick	16	54	1913	3	chick__
chickees	19	25	851	3	chickees
chicken	18	27	898	3	chicken
chickpea	21	4	319	3	chickpea
chicks	17	53	1759	3	chick_s
chicles	14	35	1250	3	chic_les
chicly	16	42	920	3	chic_ly
chile	10	56	2689	3	ch__ile
chock	16	43	1661	3	chock__
chocked	19	44	1161	3	chocked
chocks	17	48	1531	3	chock_s
choke	14	51	1802	3	ch_ok_e
chorale	12	43	1335	3	chorale
chortle	12	42	1044	3	chortle
chuckholes	24	5	237	3	chuckholes
chucking	20	37	950	3	chucking
chuckling	21	4	419	3	chuckling
chukar	15	3	463	3	chu_kar
chukka	14	3	301	3	chu_kka
chukkar	15	4	205	3	chukkar
chukkas	15	3	278	3	chukkas
chukker	15	4	383	3	chukker
chunk	14	48	1238	3	chunk__
chunked	17	42	821	3	chunked
chunkier	17	39	588	3	chunkier
chunkily	20	4	308	3	chunkily
chunks	15	42	1033	3	chunk_s
chunky	18	46	827	3	chunk_y
chunnel	12	39	530	3	chunnel
churchly	21	4	297	3	churchly
churl	10	59	1388	3	chu_rl_
churls	11	54	1107	3	chu_rls
chute	10	43	1646	3	chu__te
chutnee	12	4	683	3	chutnee
chyle	13	49	1348	3	ch__yle
cicale	10	3	1450	3	c_icale
circle	10	3	970	3	circ_le
cluck	13	49	1489	3	cluck__
clucked	16	38	1013	3	clucked
clucks	14	45	1207	3	cluck_s
cockled	16	37	1082	3	c_ockled
cockles	15	34	1464	3	c_ockles
couple	10	44	1596	3	cou_ple
crackled	17	42	886	3	crackled
crackles	16	41	1127	3	crackles
crackly	18	39	770	3	crackly
crankle	13	36	1006	3	crankle
crinkle	13	35	941	3	crinkle
crucible	14	4	519	3	crucible
cruck	13	56	1532	3	cruck__
crucks	14	44	1258	3	cruck_s
crumble	13	34	1040	3	crumble
crumple	13	36	836	3	crumple
cuckold	16	4	372	3	c_uckold
cuckoo	14	8	641	3	c_uckoo
cuddle	10	44	1453	3	c_uddle
cuke	10	58	2498	3	c_u_k_e
cupule	10	34	1072	3	c_upule
curdle	9	55	1431	3	c_urdle
curule	8	36	1412	3	c_urule
cuttle	8	41	1389	3	c_uttle
cycle	12	3	952	3	c_yc_le
deckle	13	120	1245	3	_deckle
duckie	13	35	1166	3	_duckie
fickle	15	39	1297	3	_fickle
freckle	16	10	664	3	freckle
grackle	14	33	889	3	grackle
hackee	15	49	2183	3	_hackee
hackie	15	46	1562	3	_hackie
hackled	17	33	1249	3	_hackled
hackler	16	35	1235	3	_hackler
hackles	16	29	1706	3	_hackles
hackly	18	29	873	3	_hackly
heckled	17	31	846	3	_heckled
heckler	16	27	857	3	_heckler
heckles	16	37	1138	3	_heckles
hickie	15	38	1247	3	_hickie
huck	13	59	2763	3	_huck__
hucks	14	43	2217	3	_huck_s
huddle	11	37	1299	3	_huddle
humble	13	36	1505	3	_humble
hunkie	13	38	1238	3	_hunkie
hurdle	10	37	1279	3	_hurdle
hurtle	9	35	1294	3	_hurtle
hustle	9	31	1399	3	_hustle
keckle	11	35	942	3	_keckle
knuckled	14	6	356	3	knuckled
knuckler	13	8	362	3	knuckler
knuckles	13	8	445	3	knuckles
knuckly	15	4	247	3	knuckly
luckie	12	36	1141	3	_luckie
mackle	14	37	1643	3	_mackle
mickle	14	37	1513	3	_mickle
muckles	15	34	1325	3	_muckles
nickle	12	38	1448	3	_nickle
penuckle	16	4	326	3	penuckle
pickle	14	42	1565	3	_pickle
prickle	15	36	1101	3	prickle
rackle	12	39	1729	3	_rackle
ruckled	14	41	1103	3	_ruckled
ruckles	13	34	1460	3	_ruckles
runkle	10	36	1154	3	_runkle
shackled	18	27	760	3	shackled
shackler	17	31	797	3	shackler
shackles	17	30	1059	3	shackles
shuck	14	43	1453	3	shuck__
shucked	17	38	983	3	shucked
shucker	16	37	1010	3	shucker
shucks	15	40	1041	3	shuck_s
shuffle	16	27	692	3	shuffle
shuttle	10	4	610	3	shuttle
sickle	12	44	1832	3	_sickle
spackle	15	36	957	3	spackle
speckle	15	29	755	3	speckle
stickle	13	24	1097	3	stickle
suckled	14	42	1251	3	_suckled
suckler	13	34	1309	3	_suckler
suckles	13	45	1674	3	_suckles
tackle	12	38	1573	3	_tackle
thickly	19	41	557	3	thickly
tickle	12	46	1674	3	_tickle
trickle	13	36	1344	3	trickle
truckled	15	32	731	3	truckled
truckler	14	29	745	3	truckler
truckles	14	31	938	3	truckles
unbuckle	16	4	386	3	unbuckle

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.390	458182.1
2	DLD Change Limit	134027	170	5.580	24019.2
3	Display Results	170	170	0.060	2833.3
	(SQL Overall)	178691	170	6.030	29633.7