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

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

121 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
beakers	13	42	1687	(None)
bakers	12	53	2345	1	b_akers
beaders	10	41	2018	1	beaders
beaker	12	55	2069	1	beaker_
bearers	9	46	1959	1	bearers
beaters	9	49	2504	1	beaters
beavers	12	44	1732	1	beavers
breakers	14	38	1097	1	breakers
leakers	11	34	1542	1	leakers
backers	15	38	2188	2	backers
baker	11	56	2954	2	b_aker_
bakery	15	59	1100	2	b_akery
bakes	11	70	3537	2	b_ake_s
balers	8	56	2693	2	b_alers
balkers	13	49	1572	2	balkers
bankers	13	39	1909	2	bankers
barkers	13	43	1851	2	barkers
beader	9	46	2379	2	beader_
beaked	13	59	1949	2	beake_d
beakier	13	40	1216	2	beakier_
beakless	14	29	738	2	beakless
beaks	11	53	2662	2	beak__s
beanery	12	3	756	2	beanery
bearer	8	53	2391	2	bearer_
bears	7	57	3904	2	bea__rs
beater	8	47	2939	2	beater_
beaver	11	48	1925	2	beaver_
beckets	15	39	982	2	beckets
bedders	11	35	1338	2	bedders
bedmakers	18	4	438	2	bedmakers
beepers	11	36	1238	2	beepers
beers	7	56	2839	2	be__ers
beezers	18	34	924	2	beezers
behavers	16	20	561	2	behavers
bejabers	19	3	363	2	bejabers
belayers	13	29	814	2	belayers
beliers	9	46	1738	2	beliers
belters	9	38	1941	2	belters
benders	10	40	2106	2	benders
berakes	13	48	1577	2	berake_s
betakes	13	42	1252	2	betake_s
betters	9	44	2209	2	betters
bickers	15	43	1655	2	bickers
bikers	12	45	1755	2	b_ikers
bilkers	13	47	1186	2	bilkers
bladers	10	42	1468	2	bladers
blamers	11	53	1421	2	blamers
blazers	18	48	1168	2	blazers
bleaker	13	35	1053	2	bleaker_
bleaters	10	34	1232	2	bleaters
boaters	9	34	1924	2	boaters
bonkers	13	40	1530	2	bonkers
bookers	13	40	1661	2	bookers
bracers	11	46	1670	2	bracers
brakes	12	49	2312	2	brake_s
bravers	12	47	1552	2	bravers
brayers	12	45	1190	2	brayers
brazers	18	45	1394	2	brazers
breaker	13	39	1292	2	breaker_
brokers	13	31	1191	2	brokers
buckers	15	35	1745	2	buckers
bunkers	13	37	1595	2	bunkers
burkers	13	37	1662	2	burkers
buskers	13	34	1409	2	buskers
dealers	8	41	1861	2	dealers
deckers	14	44	1383	2	deckers
eagers	7	45	2368	2	_eagers
eaters	6	55	3595	2	_eaters
eskers	10	53	1222	2	_eskers
fakers	13	42	1953	2	_fakers
fearers	10	48	1527	2	fearers
flakers	14	36	1327	2	flakers
headers	11	38	1939	2	headers
healers	10	43	1946	2	healers
heapers	12	36	1667	2	heapers
hearers	10	43	1978	2	hearers
heaters	10	42	2522	2	heaters
heavers	13	37	1719	2	heavers
jerkers	18	28	708	2	jerkers
lakers	10	52	2515	2	_lakers
leaders	8	38	1960	2	leaders
leaker	10	46	2007	2	leaker_
leaners	7	37	1817	2	leaners
leapers	9	37	1666	2	leapers
leasers	7	47	1784	2	leasers
leavers	10	37	1778	2	leavers
makers	12	39	2173	2	_makers
meaners	9	44	1524	2	meaners
neckers	13	42	1046	2	neckers
peckers	15	33	1267	2	peckers
quakers	20	30	969	2	quakers
rakers	10	41	2357	2	_rakers
readers	8	38	2377	2	readers
reamers	9	42	2108	2	reamers
reapers	9	35	2045	2	reapers
rearers	7	43	2356	2	rearers
reavers	10	83	2074	2	reavers
reekers	11	36	1314	2	reekers
remakers	14	38	1130	2	remakers
retakers	12	35	1113	2	retakers
sakers	10	41	2543	2	_sakers
sealers	7	43	2355	2	sealers
seamers	9	47	1943	2	seamers
seaters	7	40	2894	2	seaters
seekers	11	37	1233	2	seekers
shakers	14	40	1556	2	shakers
slakers	11	41	1575	2	slakers
sneakers	12	30	864	2	sneakers
soakers	11	41	1495	2	soakers
speakers	14	29	945	2	speakers
takers	10	39	2374	2	_takers
tearers	7	52	1823	2	tearers
teasers	7	53	1724	2	teasers
vealers	10	32	1429	2	vealers
wakers	13	48	2249	2	_wakers
weakens	14	36	706	2	weakens
weaker	13	40	1544	2	weaker_
weaners	10	46	1383	2	weaners
wearers	10	46	1590	2	wearers
weavers	13	37	1446	2	weavers
wreakers	15	32	842	2	wreakers

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	121	3.403	31640.0
3	Display Results	121	121	0.033	3666.7
	(SQL Overall)	178691	121	3.812	46875.9