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

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

112 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
walkers	14	34	1147	(None)
balkers	13	49	1572	1	balkers
calkers	13	44	1469	1	calkers
talkers	11	35	1321	1	talkers
wakers	13	48	2249	1	wa_kers
walers	9	48	2446	1	wal_ers
walker	13	39	1399	1	walker_
wankers	14	45	1471	1	wankers
alders	7	42	1842	2	_alders
alters	6	49	2422	2	_alters
askers	10	59	1540	2	_askers
backers	15	38	2188	2	backers
bakers	12	53	2345	2	ba_kers
balers	8	56	2693	2	bal_ers
balker	12	45	1916	2	balker_
ballers	9	44	2101	2	ballers
bankers	13	39	1909	2	bankers
barkers	13	43	1851	2	barkers
bilkers	13	47	1186	2	bilkers
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
wacker	15	49	2012	2	wacker_
wackes	15	47	1771	2	wacke_s
wadders	12	38	1244	2	wadders
waders	10	91	2064	2	wa_ders
wafers	12	43	1614	2	wa_fers
wafters	13	41	1281	2	wafters
wagers	10	51	2220	2	wa_gers
waggers	12	46	1308	2	waggers
wailers	10	39	1680	2	wailers
waiters	10	42	1862	2	waiters
waivers	13	34	1005	2	waivers
wakens	13	50	1204	2	wa_kens
waker	12	55	2659	2	wa_ker_
wakes	12	66	3365	2	wa_ke_s
waler	8	42	2926	2	wal_er_
wales	8	61	4283	2	wal_e_s
walies	9	53	2452	2	walie_s
walked	14	53	1378	2	walke_d
walkovers	19	4	261	2	walkovers
walks	12	62	1850	2	walk__s
walkups	16	3	301	2	walkups
wallets	10	39	1483	2	wallets
waltzers	20	3	400	2	waltzers
wanders	11	42	2133	2	wanders
wanker	13	42	1997	2	wanker_
wanters	10	44	2009	2	wanters
warders	11	34	1681	2	warders
warmers	12	45	1429	2	warmers
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
washers	13	45	1752	2	washers
wasters	10	40	2659	2	wasters
waters	9	50	3063	2	wa_ters
wavers	12	50	2247	2	wa_vers
waxers	16	40	1430	2	wa_xers
welders	11	33	1341	2	welders
welters	10	35	1606	2	welters
whackers	20	32	654	2	whackers
whalers	13	52	970	2	whal_ers
wickers	16	41	1470	2	wickers
wilders	11	35	1350	2	wilders
willers	10	35	1791	2	willers
winkers	14	35	1711	2	winkers
wolfers	13	40	963	2	wolfers
wolvers	13	34	931	2	wolvers
workers	14	46	1269	2	workers
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	112	2.890	37256.4
3	Display Results	112	112	0.046	2434.8
	(SQL Overall)	178691	112	3.312	53952.6