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

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

150 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
rackers	13	43	2045	(None)
backers	15	38	2188	1	backers
crackers	16	41	1172	1	crackers
dackers	14	34	1704	1	dackers
hackers	16	46	1904	1	hackers
jackers	20	42	1445	1	jackers
lackers	13	41	2054	1	lackers
packers	15	38	1889	1	packers
racers	8	47	2543	1	rac_ers
racker	12	48	2455	1	racker_
rackets	13	49	1687	1	rackets
rakers	10	41	2357	1	ra_kers
rankers	11	32	1746	1	rankers
rockers	13	39	1655	1	rockers
sackers	13	38	2022	1	sackers
tackers	13	43	1962	1	tackers
trackers	14	35	1285	1	trackers
ackees	12	49	1458	2	_ackees
archers	12	44	1457	2	archers
askers	10	59	1540	2	_askers
backer	14	45	2552	2	backer_
bakers	12	53	2345	2	ba_kers
balkers	13	49	1572	2	balkers
bankers	13	39	1909	2	bankers
barkers	13	43	1851	2	barkers
bickers	15	43	1655	2	bickers
bracers	11	46	1670	2	brac_ers
brackens	16	32	792	2	brackens
brackets	16	33	1043	2	brackets
buckers	15	35	1745	2	buckers
cacklers	16	37	1070	2	cacklers
calkers	13	44	1469	2	calkers
cankers	13	44	1875	2	cankers
clackers	16	39	1170	2	clackers
cockers	15	36	1833	2	cockers
cracker	15	31	1417	2	cracker_
dacker	13	49	2075	2	dacker_
daikers	12	40	1031	2	daikers
deckers	14	44	1383	2	deckers
dickers	14	41	1766	2	dickers
dockers	14	37	1500	2	dockers
duckers	14	32	1471	2	duckers
facers	11	55	1944	2	fac_ers
fakers	13	42	1953	2	fa_kers
frankers	15	34	835	2	frankers
fuckers	16	36	1159	2	fuckers
gawkers	15	34	745	2	gawkers
hackees	16	50	1410	2	hackees
hacker	15	48	2269	2	hacker_
hacklers	17	37	1030	2	hacklers
hankers	14	42	1813	2	hankers
hawkers	17	42	1033	2	hawkers
hockers	16	39	1591	2	hockers
ickers	12	39	1418	2	_ickers
jacker	19	44	1758	2	jacker_
jackets	20	50	1137	2	jackets
kickers	12	40	1329	2	kickers
knackers	13	28	684	2	knackers
lacers	8	52	2525	2	lac_ers
lacker	12	53	2562	2	lacker_
lackeys	16	45	826	2	lackeys
lakers	10	52	2515	2	la_kers
larkers	11	30	1451	2	larkers
lickers	13	41	1825	2	lickers
lockers	13	35	1692	2	lockers
macers	10	53	2127	2	mac_ers
makers	12	39	2173	2	ma_kers
markers	13	35	1610	2	markers
maskers	13	39	1384	2	maskers
mockers	15	38	1294	2	mockers
muckers	15	36	1280	2	muckers
neckers	13	42	1046	2	neckers
nickers	13	44	1509	2	nickers
ockers	12	38	1390	2	_ockers
pacers	10	51	2454	2	pac_ers
packer	14	42	2340	2	packer_
packets	15	51	1477	2	packets
parkers	13	38	1687	2	parkers
peckers	15	33	1267	2	peckers
pickers	15	37	1809	2	pickers
prickers	16	37	1067	2	prickers
puckers	15	35	1467	2	puckers
racer	7	52	3302	2	rac_er_
races	7	49	4324	2	rac_e_s
rachets	12	45	1683	2	rachets
racier	8	51	2097	2	racier_
racked	13	45	2608	2	racke_d
racket	12	52	2942	2	racke_t
rackety	16	49	911	2	rackety
racks	11	50	2885	2	rack__s
rafters	10	37	1563	2	rafters
raiders	8	46	1514	2	raiders
railers	7	44	2066	2	railers
raisers	7	36	1739	2	raisers
rakees	10	45	1697	2	ra_kees
raker	9	45	2979	2	ra_ker_
rakes	9	44	4035	2	ra_ke_s
rammers	11	37	1504	2	rammers
ranchers	13	33	1179	2	ranchers
rangers	8	36	2104	2	rangers
ranker	10	50	2190	2	ranker_
ranters	7	33	2364	2	ranters
rapers	8	43	2718	2	ra_pers
rapiers	9	50	1287	2	rapiers
rappers	11	36	1844	2	rappers
rasers	6	45	2678	2	ra_sers
rashers	10	40	2091	2	rashers
raspers	9	44	1592	2	raspers
rasters	7	46	2902	2	rasters
raters	6	39	3658	2	ra_ters
ratters	7	44	2247	2	ratters
ravers	9	46	2818	2	ra_vers
razers	15	49	1961	2	ra_zers
reachers	13	35	1572	2	reachers
reekers	11	36	1314	2	reekers
ricers	8	41	2099	2	ric_ers
rickets	13	49	1509	2	rickets
rickeys	16	54	898	2	rickeys
riskers	11	40	1199	2	riskers
rocker	12	43	1957	2	rocker_
rockery	16	43	925	2	rockery
rockets	13	46	1536	2	rockets
sacker	12	51	2484	2	sacker_
sakers	10	41	2543	2	sa_kers
slackers	14	38	1274	2	slackers
smackers	16	31	871	2	smackers
snackers	14	30	1022	2	snackers
stackers	14	34	1356	2	stackers
suckers	13	37	1762	2	suckers
tacker	12	42	2450	2	tacker_
tackets	13	49	1436	2	tackets
tacklers	14	30	1077	2	tacklers
takers	10	39	2374	2	ta_kers
talkers	11	35	1321	2	talkers
tankers	11	34	1691	2	tankers
tickers	13	36	1772	2	tickers
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
tuckers	13	40	1435	2	tuckers
wacker	15	49	2012	2	wacker_
wackes	15	47	1771	2	wacke_s
wakers	13	48	2249	2	wa_kers
walkers	14	34	1147	2	walkers
wankers	14	45	1471	2	wankers
whackers	20	32	654	2	whackers
wickers	16	41	1470	2	wickers
wreckers	17	31	597	2	wreckers
yakkers	13	30	427	2	yakkers

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	107671	0.766	233278.1
2	DLD Change Limit	107671	150	7.093	15179.9
3	Display Results	150	150	0.110	1363.6
	(SQL Overall)	178691	150	7.969	22423.3