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

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

116 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
balkers	13	49	1572	(None)
backers	15	38	2188	1	backers
bakers	12	53	2345	1	ba_kers
balers	8	56	2693	1	bal_ers
balker	12	45	1916	1	balker_
ballers	9	44	2101	1	ballers
bankers	13	39	1909	1	bankers
barkers	13	43	1851	1	barkers
bilkers	13	47	1186	1	bilkers
calkers	13	44	1469	1	calkers
talkers	11	35	1321	1	talkers
walkers	14	34	1147	1	walkers
alders	7	42	1842	2	_alders
alters	6	49	2422	2	_alters
askers	10	59	1540	2	_askers
backer	14	45	2552	2	backer_
badgers	11	48	1265	2	badgers
baggers	11	39	1569	2	baggers
bailers	9	42	2135	2	bailers
baiters	9	46	1930	2	baiters
baker	11	56	2954	2	ba_ker_
bakery	15	59	1100	2	ba_kery
bakes	11	70	3537	2	ba_ke_s
balder	9	53	1886	2	balder_
baleens	9	3	847	2	baleens
baler	7	56	3527	2	bal_er_
bales	7	62	5008	2	bal_e_s
balked	13	52	1941	2	balke_d
balkier	13	41	1198	2	balkier_
balks	11	49	2629	2	balk__s
baller	8	38	2520	2	baller_
ballets	9	37	1951	2	ballets
banders	10	43	2456	2	banders
bangers	10	40	2035	2	bangers
banker	12	42	2273	2	banker_
banners	9	40	1871	2	banners
banters	9	46	2311	2	banters
barbers	11	43	1750	2	barbers
barker	12	48	2286	2	barker_
barters	9	42	2303	2	barters
bashers	12	48	2083	2	bashers
baskets	13	51	1183	2	baskets
basters	9	49	3030	2	basters
bathers	12	47	2036	2	bathers
batters	9	46	2601	2	batters
bawlers	12	44	1273	2	bawlers
beakers	13	42	1687	2	beakers
beliers	9	46	1738	2	beliers
belters	9	38	1941	2	belters
bickers	15	43	1655	2	bickers
bikers	12	45	1755	2	b_ikers
bilker	12	49	1344	2	bilker_
billers	9	47	2083	2	billers
bladers	10	42	1468	2	bladers
blamers	11	53	1421	2	blamers
blazers	18	48	1168	2	blazers
bolters	9	40	1780	2	bolters
bonkers	13	40	1530	2	bonkers
bookers	13	40	1661	2	bookers
brokers	13	31	1191	2	brokers
buckers	15	35	1745	2	buckers
bulgers	10	52	1514	2	bulgers
bunkers	13	37	1595	2	bunkers
burkers	13	37	1662	2	burkers
buskers	13	34	1409	2	buskers
calker	12	49	1708	2	calker_
callers	9	42	2196	2	callers
cankers	13	44	1875	2	cankers
caulkers	14	37	565	2	caulkers
dackers	14	34	1704	2	dackers
daikers	12	40	1031	2	daikers
fakers	13	42	1953	2	fa_kers
fallers	10	39	1799	2	fallers
falters	10	39	1647	2	falters
flakers	14	36	1327	2	flakers
gawkers	15	34	745	2	gawkers
hackers	16	46	1904	2	hackers
halers	9	49	2691	2	hal_ers
halters	10	46	1980	2	halters
halvers	13	33	1142	2	halvers
hankers	14	42	1813	2	hankers
hawkers	17	42	1033	2	hawkers
jackers	20	42	1445	2	jackers
lackers	13	41	2054	2	lackers
lakers	10	52	2515	2	la_kers
larkers	11	30	1451	2	larkers
makers	12	39	2173	2	ma_kers
markers	13	35	1610	2	markers
maskers	13	39	1384	2	maskers
milkers	13	44	1161	2	milkers
packers	15	38	1889	2	packers
palmers	11	35	1362	2	palmers
palters	9	40	2168	2	palters
parkers	13	38	1687	2	parkers
rackers	13	43	2045	2	rackers
rakers	10	41	2357	2	ra_kers
rankers	11	32	1746	2	rankers
sackers	13	38	2022	2	sackers
sakers	10	41	2543	2	sa_kers
salters	7	36	2225	2	salters
salvers	10	39	1600	2	salvers
slakers	11	41	1575	2	slakers
stalkers	12	36	985	2	stalkers
sulkers	11	36	1334	2	sulkers
tackers	13	43	1962	2	tackers
takers	10	39	2374	2	ta_kers
talers	6	46	2814	2	tal_ers
talker	10	39	1622	2	talker_
tankers	11	34	1691	2	tankers
valkyrs	17	3	216	2	valkyrs
valuers	10	32	894	2	valuers
wakers	13	48	2249	2	wa_kers
walers	9	48	2446	2	wal_ers
walker	13	39	1399	2	walker_
wankers	14	45	1471	2	wankers
yakkers	13	30	427	2	yakkers

Search took 4 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.376	475242.0
2	DLD Change Limit	107671	116	3.310	32529.0
3	Display Results	116	116	0.033	3515.2
	(SQL Overall)	178691	116	3.719	48048.1