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

Here are the results of your fuzzy-string dictionary search for “hawkers” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
Check this box to automatically increase the Change Limit after seconds.

95 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
hawkers	17	42	1033	(None)
gawkers	15	34	745	1	gawkers
hackers	16	46	1904	1	hackers
hankers	14	42	1813	1	hankers
hawker	16	48	1266	1	hawker_
hawkeys	20	41	470	1	hawkeys
hawsers	13	40	948	1	hawsers
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
barkers	13	43	1851	2	barkers
bawlers	12	44	1273	2	bawlers
calkers	13	44	1469	2	calkers
cankers	13	44	1875	2	cankers
chawers	15	44	1203	2	chaw_ers
dackers	14	34	1704	2	dackers
daikers	12	40	1031	2	daikers
fakers	13	42	1953	2	fa_kers
fawners	13	38	849	2	fawners
gawker	14	55	935	2	gawker_
gawpers	13	44	831	2	gawpers
hackees	16	50	1410	2	hackees
hacker	15	48	2269	2	hacker_
hacklers	17	37	1030	2	hacklers
hafters	13	46	1433	2	hafters
hailers	10	40	1726	2	hailers
hakes	12	60	3430	2	ha_ke_s
halers	9	49	2691	2	ha_lers
halters	10	46	1980	2	halters
halvers	13	33	1142	2	halvers
hammers	14	42	1605	2	hammers
hampers	14	36	1694	2	hampers
handers	11	42	2433	2	handers
hangers	11	31	2081	2	hangers
hanker	13	46	2209	2	hanker_
harkens	14	41	1286	2	harkens
harmers	12	41	1659	2	harmers
harpers	12	49	1620	2	harpers
haters	9	49	3039	2	ha_ters
hatters	10	42	2152	2	hatters
haulers	10	40	1244	2	haulers
havers	12	47	2148	2	ha_vers
hawked	17	47	1267	2	hawke_d
hawkey	19	50	763	2	hawke_y
hawkies	17	33	1124	2	hawkies
hawks	15	54	1570	2	hawk__s
hawser	12	59	1084	2	hawser_
hawses	12	51	1399	2	hawse_s
hayers	12	44	1594	2	ha_yers
hazers	18	46	1595	2	ha_zers
hewers	12	37	1527	2	hew_ers
hikers	13	50	1435	2	h_ikers
hockers	16	39	1591	2	hockers
honkers	14	33	1523	2	honkers
hookers	14	49	1651	2	hookers
howlers	13	33	1235	2	howlers
hunkers	14	33	1433	2	hunkers
huskers	14	35	1003	2	huskers
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
lawyers	13	37	715	2	lawyers
makers	12	39	2173	2	ma_kers
markers	13	35	1610	2	markers
maskers	13	39	1383	2	maskers
packers	15	38	1889	2	packers
parkers	13	38	1687	2	parkers
pawers	11	48	1878	2	paw_ers
pawners	12	43	1107	2	pawners
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
sawers	9	46	2016	2	saw_ers
sawyers	13	31	753	2	sawyers
shakers	14	40	1556	2	sha_kers
sharkers	15	40	1105	2	sharkers
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
tawers	9	41	1860	2	taw_ers
thankers	15	29	783	2	thankers
thawers	13	42	848	2	thaw_ers
wakers	13	48	2249	2	wa_kers
walkers	14	34	1147	2	walkers
wankers	14	45	1471	2	wankers
whackers	20	32	654	2	whackers
yakkers	13	30	427	2	yakkers
yawners	13	36	718	2	yawners
yawpers	15	34	685	2	yawpers

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	95	3.513	30649.3
3	Display Results	95	95	0.033	2878.8
	(SQL Overall)	178691	95	3.686	48478.3