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

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

139 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
markers	13	35	1610	(None)
barkers	13	43	1851	1	barkers
larkers	11	30	1451	1	larkers
makers	12	39	2173	1	ma_kers
marker	12	44	2039	1	marker_
markets	13	33	1403	1	markets
marrers	9	34	1431	1	marrers
maskers	13	39	1383	1	maskers
parkers	13	38	1687	1	parkers
armers	8	55	2027	2	_armers
askers	10	59	1540	2	_askers
backers	15	38	2188	2	backers
bakers	12	53	2345	2	ba_kers
balkers	13	49	1572	2	balkers
bankers	13	39	1909	2	bankers
barbers	11	43	1750	2	barbers
barker	12	48	2286	2	barker_
barters	9	42	2303	2	barters
burkers	13	37	1662	2	burkers
calkers	13	44	1469	2	calkers
cankers	13	44	1875	2	cankers
carders	10	48	2035	2	carders
careers	9	52	1878	2	careers
carers	8	51	3395	2	car_ers
carpers	11	45	2125	2	carpers
carters	9	53	2724	2	carters
carvers	12	48	1753	2	carvers
corkers	13	41	1885	2	corkers
dackers	14	34	1704	2	dackers
daikers	12	40	1031	2	daikers
darers	7	59	2187	2	dar_ers
darkens	12	40	987	2	darkens
darker	11	47	1869	2	darker_
darkeys	15	35	653	2	darkeys
darners	8	38	1577	2	darners
darters	8	40	1760	2	darters
earners	7	40	1645	2	earners
fakers	13	42	1953	2	fa_kers
farcers	12	47	1344	2	farcers
farers	9	59	2405	2	far_ers
farmers	12	43	1526	2	farmers
forkers	14	46	1578	2	forkers
garners	8	38	1598	2	garners
garters	8	42	1822	2	garters
gawkers	15	34	745	2	gawkers
hackers	16	46	1904	2	hackers
hankers	14	42	1813	2	hankers
harkens	14	41	1286	2	harkens
harmers	12	41	1659	2	harmers
harpers	12	49	1620	2	harpers
hawkers	17	42	1033	2	hawkers
jackers	20	42	1445	2	jackers
jerkers	18	28	708	2	jerkers
lackers	13	41	2054	2	lackers
lakers	10	52	2515	2	la_kers
larders	8	35	1694	2	larders
larker	10	45	1924	2	larker_
lurkers	11	39	1008	2	lurkers
macers	10	53	2127	2	ma_cers
madders	11	35	1321	2	madders
mailers	9	44	2033	2	mailers
maimers	11	38	1304	2	maimers
makars	12	46	1263	2	ma_kars
maker	11	41	2781	2	ma_ker_
makes	11	53	3685	2	ma_ke_s
mammers	10	46	1569	2	mammers
mamzers	20	40	916	2	mamzers
mangers	10	35	2126	2	mangers
manners	9	34	1783	2	manners
mappers	13	33	1377	2	mappers
marblers	12	31	923	2	marblers
marcels	11	32	1237	2	marcels
marchers	15	37	1081	2	marchers
mares	7	64	5763	2	mar_e_s
marges	9	45	2571	2	marge_s
mariners	10	31	1386	2	mariners
markas	12	47	1700	2	mark_as
marked	13	39	2162	2	marke_d
market	12	32	2604	2	marke_t
marketers	15	4	598	2	marketers
markhors	17	4	539	2	markhors
markkas	12	35	608	2	markkas
marks	11	59	3348	2	mark__s
markups	15	3	496	2	markups
marrer	8	37	1667	2	marrer_
marriers	10	33	1247	2	marriers
marses	8	48	2711	2	marse_s
martens	9	37	1495	2	martens
martyrs	12	3	489	2	martyrs
marvels	12	38	1009	2	marvels
masers	8	46	2345	2	ma_sers
mashers	12	46	2105	2	mashers
maskegs	14	37	541	2	maskegs
masker	12	44	1610	2	masker_
masters	9	46	2892	2	masters
maters	8	50	3238	2	ma_ters
matters	9	44	2175	2	matters
maulers	9	42	1330	2	maulers
mazers	17	39	1709	2	ma_zers
mercers	11	44	1277	2	mercers
mergers	10	38	1342	2	mergers
milkers	13	44	1161	2	milkers
mirker	12	37	1269	2	mirker_
mockers	15	38	1294	2	mockers
muckers	15	36	1279	2	muckers
murders	10	33	1136	2	murders
murker	12	37	1524	2	murker_
packers	15	38	1889	2	packers
parers	8	55	3074	2	par_ers
parker	12	41	2137	2	parker_
parsers	9	41	1815	2	parsers
porkers	13	43	1493	2	porkers
rackers	13	43	2045	2	rackers
rakers	10	41	2357	2	ra_kers
rankers	11	32	1746	2	rankers
remarkers	15	19	728	2	remarkers
sackers	13	38	2022	2	sackers
sakers	10	41	2543	2	sa_kers
sharkers	15	40	1105	2	sharkers
smackers	16	31	871	2	smackers
smirkers	14	31	635	2	smirkers
sparkers	14	41	1131	2	sparkers
starkers	12	37	1239	2	starkers
tackers	13	43	1962	2	tackers
takers	10	39	2374	2	ta_kers
talkers	11	35	1321	2	talkers
tankers	11	34	1691	2	tankers
variers	10	37	1266	2	variers
wakers	13	48	2249	2	wa_kers
walkers	14	34	1147	2	walkers
wankers	14	45	1471	2	wankers
warders	11	34	1681	2	warders
warmers	12	45	1429	2	warmers
warners	10	33	1556	2	warners
warpers	12	34	1358	2	warpers
workers	14	46	1269	2	workers
yakkers	13	30	427	2	yakkers
yarders	11	32	1159	2	yarders
yarners	10	43	1220	2	yarners

Search took 8 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.470	380193.6
2	DLD Change Limit	107671	139	6.063	17758.7
3	Display Results	139	139	0.046	3021.7
	(SQL Overall)	178691	139	6.579	27160.8