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

Here are the results of your fuzzy-string dictionary search for “gawpers” 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
gawpers	13	44	831	(None)
gapers	9	45	2047	1	ga_pers
gaspers	10	50	1413	1	gaspers
gawkers	15	34	745	1	gawkers
gawper	12	49	969	1	gawper_
yawpers	15	34	685	1	yawpers
apers	7	66	2913	2	_a_pers
aspers	8	62	2031	2	_aspers
bawlers	12	44	1273	2	bawlers
campers	13	42	2029	2	campers
capers	10	54	2814	2	ca_pers
cappers	13	44	1940	2	cappers
carpers	11	45	2125	2	carpers
dampers	12	39	1569	2	dampers
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
gaper	8	61	2512	2	ga_per_
gapes	8	60	3082	2	ga_pe_s
garners	8	38	1598	2	garners
garters	8	42	1823	2	garters
gasper	9	45	1554	2	gasper_
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
gawker	14	55	935	2	gawker_
gawped	13	50	907	2	gawpe_d
gawps	11	59	1101	2	gawp__s
gazers	16	45	1630	2	ga_zers
gippers	12	32	1208	2	gippers
gnawers	11	35	639	2	gnaw_ers
graspers	11	33	840	2	graspers
gripers	10	40	1146	2	gripers
gropers	10	48	1385	2	gropers
gulpers	10	29	901	2	gulpers
gyppers	15	23	550	2	gyppers
hampers	14	36	1695	2	hampers
harpers	12	49	1620	2	harpers
hawkers	17	42	1033	2	hawkers
hawsers	13	40	948	2	hawsers
japers	15	46	1617	2	ja_pers
jaspers	16	43	1046	2	jaspers
lampers	11	38	1733	2	lampers
lappers	11	37	1746	2	lappers
lawyers	13	37	715	2	lawyers
mappers	13	33	1378	2	mappers
nappers	11	42	1486	2	nappers
pampers	13	36	1593	2	pampers
papers	10	51	2532	2	pa_pers
paupers	11	43	1107	2	paupers
pawers	11	48	1878	2	paw_ers
pawners	12	43	1107	2	pawners
rapers	8	43	2718	2	ra_pers
rappers	11	36	1844	2	rappers
raspers	9	44	1592	2	raspers
sappers	11	35	1890	2	sappers
sawers	9	46	2016	2	saw_ers
sawyers	13	31	753	2	sawyers
tampers	11	35	1674	2	tampers
tapers	8	40	2581	2	ta_pers
tappers	11	34	1654	2	tappers
tawers	9	41	1860	2	taw_ers
vampers	14	31	1162	2	vampers
warpers	12	34	1358	2	warpers
yappers	14	40	1225	2	yappers
yaupers	12	33	766	2	yaupers
yawners	13	36	718	2	yawners
yawper	14	43	795	2	yawper_
zappers	20	39	1163	2	zappers

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	81	2.873	37476.9
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	3.282	54445.8