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

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

159 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
parkers	13	38	1687	(None)
barkers	13	43	1851	1	barkers
larkers	11	30	1451	1	larkers
markers	13	35	1610	1	markers
packers	15	38	1889	1	packers
parers	8	55	3074	1	par_ers
parker	12	41	2137	1	parker_
parsers	9	41	1815	1	parsers
porkers	13	43	1493	1	porkers
sparkers	14	41	1131	1	sparkers
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	3396	2	car_ers
carpers	11	45	2125	2	carpers
carters	9	53	2725	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	1823	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
makers	12	39	2173	2	ma_kers
marker	12	44	2039	2	marker_
markets	13	33	1403	2	markets
marrers	9	34	1431	2	marrers
maskers	13	39	1384	2	maskers
pacers	10	51	2454	2	pa_cers
packer	14	42	2340	2	packer_
packets	15	51	1477	2	packets
padders	11	33	1287	2	padders
pagers	9	44	2325	2	pa_gers
palmers	11	35	1362	2	palmers
palters	9	40	2168	2	palters
pampers	13	36	1593	2	pampers
panders	10	34	2373	2	panders
paniers	9	47	1733	2	paniers
panners	9	36	2127	2	panners
panzers	18	40	1201	2	panzers
papers	10	51	2532	2	pa_pers
paraders	11	31	1311	2	paraders
parcels	11	37	1266	2	parcels
pardners	11	26	919	2	pardners
pareos	8	70	2377	2	par_eos
parer	7	58	3990	2	par_er_
pares	7	71	6448	2	par_e_s
pareus	8	54	2074	2	par_eus
parges	9	45	2954	2	parge_s
pargets	10	52	1519	2	pargets
paries	8	47	4251	2	parie_s
parkas	12	50	1802	2	park_as
parked	13	44	2514	2	parke_d
parks	11	61	3446	2	park__s
parles	8	63	3440	2	parle_s
parleys	12	52	1237	2	parleys
parlors	9	3	1291	2	parlors
parrels	9	47	1349	2	parrels
parriers	10	36	1290	2	parriers
parrs	7	59	2867	2	par__rs
parsecs	11	42	992	2	parsecs
parser	8	48	2237	2	parser_
parses	8	55	3470	2	parse_s
partakers	15	3	656	2	partakers
partiers	10	35	1424	2	partiers
partners	10	27	1113	2	partners
partyers	13	27	776	2	partyers
parures	9	5	1269	2	parures
passers	9	47	1775	2	passers
pasters	9	45	3173	2	pasters
paters	8	49	3583	2	pa_ters
patters	9	48	2519	2	patters
patzers	18	42	1057	2	patzers
paupers	11	43	1107	2	paupers
pausers	9	41	1322	2	pausers
pavers	11	50	2182	2	pa_vers
pawers	11	48	1878	2	pa_wers
pawners	12	43	1107	2	pawners
payers	11	46	2182	2	pa_yers
pearlers	10	3	903	2	pearlers
peckers	15	33	1267	2	peckers
pickers	15	37	1809	2	pickers
pikers	12	47	1739	2	p_ikers
pinkers	13	41	1860	2	pinkers
pokers	12	46	1792	2	p_okers
porker	12	49	1754	2	porker_
porters	9	37	2270	2	porters
praters	9	49	2165	2	praters
prayers	12	42	1285	2	prayers
priers	8	45	2119	2	p_riers
pryers	11	50	1224	2	p_ryers
puckers	15	35	1467	2	puckers
punkers	13	37	1485	2	punkers
purgers	10	47	1400	2	purgers
pursers	9	39	1609	2	pursers
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
sharkers	15	40	1105	2	sharkers
spankers	14	36	986	2	spankers
sparers	9	45	1961	2	spar_ers
spargers	11	38	973	2	spargers
sparker	13	39	1436	2	sparker_
sparklers	15	31	564	2	sparklers
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 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.140	1276364.3
2	DLD Change Limit	107671	159	3.440	31299.7
3	Display Results	159	159	0.060	2650.0
	(SQL Overall)	178691	159	3.640	49090.9