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

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

81 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
gawkers	15	34	745	(None)
gawker	14	55	935	1	gawker_
gawpers	13	44	831	1	gawpers
hawkers	17	42	1033	1	hawkers
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
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
gabbers	12	46	1283	2	gabbers
gadders	10	36	1150	2	gadders
gaffers	14	42	871	2	gaffers
gagers	8	40	2133	2	ga_gers
gaggers	10	34	1366	2	gaggers
gainers	8	42	1459	2	gainers
gaiters	8	35	1654	2	gaiters
gamers	9	44	2083	2	ga_mers
gammers	12	32	1456	2	gammers
ganders	9	35	2170	2	ganders
gangers	9	44	1860	2	gangers
gaolers	8	35	1156	2	gaolers
gapers	9	45	2047	2	ga_pers
garners	8	38	1598	2	garners
garters	8	42	1823	2	garters
gaskets	12	34	815	2	gaskets
gaspers	10	50	1413	2	gaspers
gassers	8	47	1463	2	gassers
gasters	8	56	2429	2	gasters
gaters	7	47	2864	2	ga_ters
gathers	11	43	1507	2	gathers
gaugers	9	42	1171	2	gaugers
gawked	15	46	876	2	gawke_d
gawkier	15	32	652	2	gawkier_
gawkies	15	42	912	2	gawkies
gawks	13	68	1163	2	gawk__s
gawper	12	49	969	2	gawper_
gazers	16	45	1630	2	ga_zers
gnawers	11	35	639	2	gnaw_ers
hackers	16	46	1904	2	hackers
hankers	14	42	1813	2	hankers
hawker	16	48	1266	2	hawker_
hawkeys	20	41	470	2	hawkeys
hawsers	13	40	948	2	hawsers
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	1384	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
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
wakers	13	48	2249	2	wa_kers
walkers	14	34	1147	2	walkers
wankers	14	45	1471	2	wankers
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.390	458182.1
2	DLD Change Limit	107671	81	3.346	32179.0
3	Display Results	81	81	0.013	6230.8
	(SQL Overall)	178691	81	3.749	47663.6