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

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

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

65 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
crackers	16	41	1172	(None)
clackers	16	39	1170	1	clackers
cracker	15	31	1417	1	cracker_
rackers	13	43	2045	1	_rackers
trackers	14	35	1285	1	trackers
backers	15	38	2188	2	_backers
bracers	11	46	1670	2	brac_ers
brackens	16	32	792	2	brackens
brackets	16	33	1043	2	brackets
cacklers	16	37	1070	2	c_acklers
calkers	13	44	1469	2	c_alkers
cankers	13	44	1875	2	c_ankers
carjackers	25	5	341	2	carjackers
checkers	19	31	784	2	checkers
clacker	15	38	1377	2	clacker_
clickers	16	39	1020	2	clickers
clockers	16	36	981	2	clockers
coachers	15	43	1230	2	coachers
cockers	15	36	1833	2	c_ockers
crabbers	14	35	875	2	crabbers
cracked	16	35	1474	2	cracke_d
crackles	16	41	1127	2	crackles
cracknels	17	4	343	2	cracknels
cracks	14	48	1700	2	crack__s
crackups	18	4	312	2	crackups
cradlers	11	30	920	2	cradlers
crafters	13	41	995	2	crafters
crakes	12	49	2181	2	cra_ke_s
crammers	14	36	935	2	crammers
cranker	13	36	1279	2	cranker_
crappers	14	40	1102	2	crappers
crashers	13	40	1323	2	crashers
craters	9	50	2189	2	cra_ters
cravers	12	44	1656	2	cra_vers
crawlers	13	30	901	2	crawlers
crickets	16	41	812	2	crickets
croakers	14	28	852	2	croakers
crockery	19	35	660	2	crockery
crockets	16	33	954	2	crockets
dackers	14	34	1704	2	_dackers
frankers	15	34	835	2	frankers
hackers	16	46	1904	2	_hackers
jackers	20	42	1445	2	_jackers
knackers	13	28	684	2	knackers
lackers	13	41	2054	2	_lackers
packers	15	38	1889	2	_packers
prickers	16	37	1067	2	prickers
racers	8	47	2543	2	_rac_ers
racker	12	48	2455	2	_racker_
rackets	13	49	1687	2	_rackets
rakers	10	41	2357	2	_ra_kers
rankers	11	32	1746	2	_rankers
rockers	13	39	1655	2	_rockers
sackers	13	38	2022	2	_sackers
slackers	14	38	1274	2	slackers
smackers	16	31	871	2	smackers
snackers	14	30	1022	2	snackers
stackers	14	34	1356	2	stackers
tackers	13	43	1962	2	_tackers
tracers	9	49	1784	2	trac_ers
tracker	13	35	1517	2	tracker_
trickers	14	38	1281	2	trickers
truckers	14	27	901	2	truckers
whackers	20	32	654	2	whackers
wreckers	17	31	597	2	wreckers

Search took 5 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	121059	0.390	458182.1
2	DLD Change Limit	121059	65	3.843	31501.2
3	Display Results	65	65	0.033	1969.7
	(SQL Overall)	178691	65	4.266	41887.2