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

Here are the results of your fuzzy-string dictionary search for “cracked” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

118 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
cracked	16	35	1474	(None)
clacked	16	41	1360	1	clacked
cracker	15	31	1417	1	cracker
crackled	17	42	886	1	crackled
cranked	14	38	1284	1	cranked
cricked	16	48	1428	1	cricked
crocked	16	40	1443	1	crocked
racked	13	45	2608	1	_racked
tracked	14	37	1613	1	tracked
wracked	17	41	1011	1	wracked
arcked	13	62	1194	2	ar_cked
backed	15	57	2572	2	_backed
blacked	16	36	1337	2	blacked
braced	11	54	2060	2	brac_ed
bracken	15	40	981	2	bracken
bracket	15	41	1723	2	bracket
bracted	12	4	1093	2	bracted
braked	13	53	1869	2	bra_ked
bricked	16	43	1206	2	bricked
cached	14	54	1920	2	c_ached
cackled	16	46	1329	2	c_ackled
caked	12	61	2862	2	c_a_ked
calked	13	46	1740	2	c_alked
carjacked	25	4	335	2	carjacked
carked	13	40	2482	2	c_arked
casked	13	48	1551	2	c_asked
chalked	17	44	986	2	chalked
charked	17	48	1401	2	charked
checked	19	37	1002	2	checked
chocked	19	44	1161	2	chocked
chucked	19	46	973	2	chucked
clacker	15	38	1377	2	clacker
clanked	14	38	1225	2	clanked
clicked	16	41	1245	2	clicked
clocked	16	41	1283	2	clocked
clucked	16	38	1013	2	clucked
coached	15	33	1384	2	coached
coacted	12	36	1161	2	coacted
cocked	15	50	2256	2	c_ocked
craaled	10	33	942	2	craaled
crabbed	14	38	887	2	crabbed
crack	13	41	2053	2	crack__
crackers	16	41	1172	2	crackers
crackhead	21	4	332	2	crackhead
crackle	15	36	1125	2	crackle
crackles	16	41	1127	2	crackles
crackly	18	39	770	2	crackly
cracknel	16	4	370	2	cracknel
cracks	14	48	1700	2	crack_s
crackup	17	4	356	2	crackup
cracky	17	50	1022	2	crack_y
cradled	11	34	1081	2	cradled
crafted	13	41	977	2	crafted
cragged	12	47	988	2	cragged
crake	11	48	2352	2	cra_ke_
crakes	12	49	2181	2	cra_kes
crammed	14	37	1012	2	crammed
cramped	14	47	1218	2	cramped
cranched	16	32	1041	2	cranched
craned	9	61	2165	2	cra_ned
cranker	13	36	1278	2	cranker
crankled	15	40	815	2	crankled
craped	11	61	2052	2	cra_ped
crapped	14	39	1262	2	crapped
crashed	13	42	1420	2	crashed
crated	9	48	2777	2	cra_ted
craved	12	54	1777	2	cra_ved
crawled	13	37	1039	2	crawled
crazed	18	47	1445	2	cra_zed
creaked	14	34	1323	2	creaked
cricket	15	47	1695	2	cricket
crickey	18	41	814	2	crickey
croaked	14	37	1053	2	croaked
crocket	15	46	1567	2	crocket
crooked	14	39	1094	2	crooked
flacked	17	37	1158	2	flacked
fracted	13	3	937	2	fracted
franked	15	36	1005	2	franked
frocked	17	43	933	2	frocked
graced	10	52	1790	2	grac_ed
hacked	16	49	2351	2	_hacked
jacked	20	48	1752	2	_jacked
knacked	13	28	779	2	knacked
lacked	13	53	2465	2	_lacked
packed	15	48	2260	2	_packed
pranked	14	37	1209	2	pranked
pricked	16	46	1383	2	pricked
quacked	23	3	679	2	quacked
raced	8	76	3531	2	_rac_ed
racker	12	48	2455	2	_racker
racket	12	52	2942	2	_racket
raked	10	58	3142	2	_ra_ked
ranked	11	46	2074	2	_ranked
recked	13	48	2180	2	_recked
reracked	15	16	912	2	reracked
ricked	13	65	2362	2	_ricked
rocked	13	50	2232	2	_rocked
rucked	13	47	1876	2	_rucked
sacked	13	55	2521	2	_sacked
shacked	17	40	1539	2	shacked
slacked	14	38	1545	2	slacked
smacked	16	37	1099	2	smacked
snacked	14	40	1311	2	snacked
stacked	14	34	1612	2	stacked
swacked	17	31	1052	2	swacked
tacked	13	47	2394	2	_tacked
thacked	17	38	1020	2	thacked
traced	9	48	2158	2	trac_ed
tracker	13	35	1517	2	tracker
traiked	12	33	1045	2	traiked
tricked	14	40	1616	2	tricked
trocked	14	43	1224	2	trocked
trucked	14	39	1081	2	trucked
uncracked	18	22	680	2	uncracked
whacked	20	45	862	2	whacked
wrecked	17	41	833	2	wrecked
wricked	17	49	1019	2	wricked
yacked	16	45	1679	2	_yacked

Search took 6 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	107671	0.140	1276364.3
2	DLD Change Limit	107671	118	5.016	21465.5
3	Display Results	118	118	0.030	3933.3
	(SQL Overall)	178691	118	5.186	34456.4