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

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

242 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
truckles	14	31	938	(None)
ruckles	13	34	1460	1	_ruckles
trickles	14	30	1376	1	trickles
truckle	13	35	886	1	truckle_
truckled	15	32	731	1	truckled
truckler	14	29	745	1	truckler
trucklers	15	29	558	1	trucklers
brickles	16	28	1028	2	brickles
buckles	15	34	1609	2	_buckles
chuckles	19	3	680	2	chuckles
crackles	16	41	1127	2	crackles
freckles	17	12	638	2	freckles
grackles	15	30	918	2	grackles
huckles	16	36	1262	2	_huckles
knuckles	13	8	445	2	knuckles
muckles	15	34	1325	2	_muckles
prickles	16	25	1109	2	prickles
ruckle	12	44	1458	2	_ruckle_
ruckled	14	41	1103	2	_ruckled
runkles	11	41	1194	2	_runkles
strickles	15	6	781	2	strickles
suckles	13	45	1674	2	_suckles
tackles	13	38	1652	2	t_ackles
tickles	13	34	1685	2	t_ickles
trachles	13	3	1175	2	trachles
trackless	15	24	672	2	trackless
trauchles	14	4	549	2	trauchles
trickle	13	36	1344	2	trickle_
trickled	15	26	1043	2	trickled
truceless	11	23	539	2	truceless
truces	8	49	1633	2	truc__es
truckages	16	4	352	2	truckages
trucked	14	39	1081	2	truck_ed
trucker	13	40	1073	2	truck_er
truckers	14	27	901	2	truckers
trucklines	16	4	429	2	trucklines
truckmen	16	4	337	2	truckmen
trucks	12	47	1197	2	truck__s
truffles	14	8	558	2	truffles
trundles	9	27	848	2	trundles
boucles	11	31	1300	3	bouc_les
brickle	15	27	993	3	brickle_
bricoles	12	26	1030	3	bricoles
brucines	12	3	776	3	brucines
buckle	14	48	1519	3	_buckle_
buckled	16	44	1188	3	_buckled
buckler	15	41	1203	3	_buckler
bucklers	16	34	950	3	_bucklers
buckoes	15	38	1039	3	_buckoes
cackles	15	37	1720	3	_cackles
chuckies	19	3	770	3	chuckies
chuckle	18	3	644	3	chuckle_
chuckled	20	4	516	3	chuckled
chuckler	19	3	555	3	chuckler
chucklers	20	3	444	3	chucklers
cockles	15	34	1464	3	_cockles
crackle	15	36	1125	3	crackle_
crackled	17	42	886	3	crackled
crankles	14	35	1015	3	crankles
crinkles	14	26	916	3	crinkles
cruces	10	51	1754	3	cruc__es
crucibles	15	4	374	3	crucibles
crucks	14	44	1258	3	cruck__s
crumbles	14	32	968	3	crumbles
crumples	14	34	881	3	crumples
deckles	14	33	1280	3	_deckles
drumbles	13	27	772	3	drumbles
duckies	14	36	1381	3	_duckies
freckle	16	10	664	3	freckle_
freckled	18	10	444	3	freckled
frockless	18	4	345	3	frockless
graciles	11	25	1161	3	graciles
grackle	14	33	889	3	grackle_
grumbles	13	28	887	3	grumbles
gruntles	9	28	723	3	gruntles
hackles	16	29	1706	3	_hackles
heckles	16	37	1138	3	_heckles
huckle	15	39	1307	3	_huckle_
keckles	12	31	876	3	_keckles
knuckle	12	5	423	3	knuckle_
knuckled	14	6	356	3	knuckled
knuckler	13	8	362	3	knuckler
knucklers	14	8	304	3	knucklers
luckies	13	33	1368	3	_luckies
luckless	14	26	589	3	_luckless
mackles	15	44	1575	3	_mackles
mickles	15	34	1500	3	_mickles
muckle	14	34	1358	3	_muckle_
nickles	13	37	1382	3	_nickles
oracles	9	32	1242	3	orac_les
parbuckles	20	5	191	3	parbuckles
penuckles	17	4	324	3	penuckles
pickles	15	32	1544	3	_pickles
prickle	15	36	1101	3	prickle_
prickled	17	35	807	3	prickled
rackle	12	39	1729	3	_rackle_
rankles	11	31	1454	3	_rankles
reckless	14	25	797	3	_reckless
rockless	14	29	729	3	_rockless
rubbles	11	37	1511	3	_rubbles
rubles	8	39	2170	3	_ru_bles
ruches	11	48	1958	3	_ruc_hes
rucked	13	47	1876	3	_ruck_ed
rucks	11	44	2205	3	_ruck__s
ruckus	12	40	779	3	_ruck_us
ruckuses	14	4	491	3	_ruckuses
ruddles	9	28	1387	3	_ruddles
ruffles	13	35	1226	3	_ruffles
rules	5	52	3425	3	_ru__les
rumbles	11	40	1839	3	_rumbles
rumples	11	33	1313	3	_rumples
rundles	8	32	1471	3	_rundles
runkle	10	36	1154	3	_runkle_
runkled	12	39	901	3	_runkled
rustles	7	34	1641	3	_rustles
rutiles	7	43	1584	3	_rutiles
shackles	17	30	1059	3	shackles
sickles	13	34	1754	3	_sickles
spackles	16	31	994	3	spackles
speckles	16	26	813	3	speckles
stickles	14	25	1210	3	stickles
strickle	14	6	779	3	strickle_
strickled	16	6	583	3	strickled
strucken	14	4	432	3	struck_en
struggles	11	25	528	3	struggles
suckle	12	40	1596	3	_suckle_
suckled	14	42	1251	3	_suckled
suckler	13	34	1309	3	_suckler
sucklers	14	37	996	3	_sucklers
suckless	14	28	882	3	_suckless
tackle	12	38	1573	3	t_ackle_
tackled	14	39	1318	3	t_ackled
tackler	13	40	1332	3	t_ackler
tacklers	14	30	1077	3	t_acklers
tackless	14	41	948	3	t_ackless
tickle	12	46	1674	3	t_ickle_
tickled	14	43	1313	3	t_ickled
tickler	13	36	1265	3	t_ickler
ticklers	14	33	930	3	t_icklers
tinkles	11	37	1392	3	t_inkles
touches	12	51	1834	3	touc_hes
tousles	7	41	1393	3	tou_sles
touzles	16	35	922	3	tou_zles
traceless	11	22	864	3	traceless
traces	8	53	2993	3	trac__es
trachle	12	3	1185	3	trachle_
trachled	14	3	831	3	trachled
trackages	16	4	534	3	trackages
tracked	14	37	1613	3	track_ed
tracker	13	35	1517	3	track_er
trackers	14	35	1285	3	trackers
trackmen	16	3	557	3	trackmen
tracks	12	48	1884	3	track__s
tramples	12	26	1020	3	tramples
trauchle	13	4	496	3	trauchle_
trauchled	15	4	373	3	trauchled
treacles	10	3	970	3	treacles
treadles	9	3	970	3	treadles
trebles	9	3	1144	3	tr_ebles
treddles	10	3	626	3	treddles
trembles	12	3	735	3	trembles
trestles	8	30	1255	3	trestles
trices	8	48	2633	3	tric__es
tricked	14	40	1616	3	trick_ed
tricker	13	46	1552	3	trick_er
trickers	14	38	1281	3	trickers
trickie	13	26	1103	3	trickie_
trickier	14	30	1023	3	trickier
trickiest	15	4	902	3	trickiest
tricklier	15	25	682	3	tricklier
trickliest	16	4	643	3	trickliest
trickly	16	36	989	3	trickl_y
tricks	12	53	1901	3	trick__s
tricycles	16	4	436	3	tricycles
trifles	10	38	1482	3	tr_ifles
trikes	10	54	1949	3	tr_ik_es
trindles	9	32	1168	3	trindles
triples	9	46	1687	3	tr_iples
trisceles	11	4	529	3	trisceles
triskeles	13	4	427	3	triskeles
trochees	13	25	1018	3	trochees
troches	12	37	1534	3	troc_hes
trochlea	13	4	519	3	trochlea
trochleas	14	4	471	3	trochleas
trocked	14	43	1224	3	trock_ed
trocks	12	36	1463	3	trock__s
trokes	10	40	1926	3	tr_ok_es
troubles	10	5	719	3	troubles
truce	7	51	1869	3	truc__e_
truced	9	53	1205	3	truc__ed
truck	11	61	1546	3	truck___
truckable	17	4	451	3	truckable_
truckage	15	4	363	3	truckage
truckful	17	4	307	3	truckful
truckfuls	18	4	246	3	truckfuls
trucking	15	33	1016	3	trucking
truckings	16	23	502	3	truckings
truckline	15	4	491	3	truckline
truckling	16	4	507	3	truckling
truckload	16	4	197	3	truckload
truckloads	17	5	166	3	truckloads
truckman	16	4	315	3	truckman
truculent	11	4	438	3	truculent
trudges	9	33	999	3	tru_dges
trueblues	11	4	205	3	trueblues
trues	5	49	2532	3	tru___es
truffes	13	5	677	3	tru_ffes
truffle	13	8	489	3	truffle_
truffled	15	6	399	3	truffled
trulls	6	41	1028	3	tru__lls
truncates	11	4	584	3	truncates
trundle	8	30	787	3	trundle_
trundled	10	30	639	3	trundled
trundler	9	25	615	3	trundler
trundlers	10	21	500	3	trundlers
trunked	12	35	841	3	trunk_ed
trunks	10	42	975	3	trunk__s
trunnels	8	4	451	3	trunnels
trusses	7	38	1363	3	tru_sses
trustees	8	33	932	3	trustees
trusties	8	27	1285	3	trusties
trustless	9	5	595	3	trustless
truthless	12	4	403	3	truthless
tubules	9	3	1023	3	t_ubules
tucked	13	40	1749	3	t_uck_ed
tucker	12	43	1695	3	t_uck_er
tuckers	13	40	1435	3	t_uckers
tucket	12	42	1948	3	t_uck_et
tuckets	13	48	1033	3	t_uckets
tucks	11	47	2112	3	t_uck__s
tuilles	7	24	1192	3	t_uilles
tules	5	45	3279	3	t_u__les
tulles	6	32	1889	3	t_u_lles
tumbles	11	38	1602	3	t_umbles
turnbuckles	19	5	103	3	turnbuckles
turtles	7	29	1434	3	t_urtles
tuskless	12	3	421	3	t_uskless
tussles	7	3	783	3	t_ussles
twinkles	15	3	507	3	twinkles
unbuckles	17	4	319	3	unbuckles
utricles	10	3	722	3	utric_les
wrinkles	15	29	669	3	wrinkles

Search took 9 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	146162	0.343	520965.0
2	DLD Change Limit	146162	242	7.940	18408.3
3	Display Results	242	242	0.106	2283.0
	(SQL Overall)	178691	242	8.389	21300.6