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

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

87 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
jaspers	16	43	1046	(None)
aspers	8	62	2031	1	_aspers
gaspers	10	50	1413	1	gaspers
japers	15	46	1617	1	ja_pers
jasper	15	46	1038	1	jasper_
jaspery	19	40	525	1	jaspery
raspers	9	44	1592	1	raspers
apers	7	66	2913	2	_a_pers
askers	10	59	1540	2	_askers
aspens	8	50	1335	2	_aspens
asper	7	55	2043	2	_asper_
asperse	9	42	1066	2	_asperse
asters	6	56	3160	2	_asters
bashers	12	48	2083	2	bashers
basters	9	49	3031	2	basters
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
casters	9	47	2990	2	casters
claspers	12	44	1091	2	claspers
dampers	12	39	1569	2	dampers
dashers	11	50	1686	2	dashers
easters	7	51	2568	2	easters
gapers	9	45	2047	2	ga_pers
gasper	9	45	1554	2	gasper_
gassers	8	47	1463	2	gassers
gasters	8	56	2430	2	gasters
gawpers	13	44	831	2	gawpers
graspers	11	33	840	2	graspers
hampers	14	36	1695	2	hampers
harpers	12	49	1620	2	harpers
jabbers	18	36	1058	2	jabbers
jackers	20	42	1445	2	jackers
jaegers	15	30	710	2	jaegers
jagers	14	44	1572	2	ja_gers
jaggers	16	40	1289	2	jaggers
jailers	14	41	1404	2	jailers
jammers	18	37	1070	2	jammers
japer	14	62	1888	2	ja_per_
japery	18	43	914	2	ja_pery
japes	14	63	2282	2	ja_pe_s
jazzers	22	32	476	2	jazzers
jeepers	16	39	919	2	jeepers
jesters	14	41	1819	2	jesters
joshers	17	41	1159	2	joshers
jumpers	18	39	984	2	jumpers
justers	14	38	1573	2	justers
kashers	14	39	1402	2	kashers
lampers	11	38	1733	2	lampers
lappers	11	37	1746	2	lappers
lapsers	9	39	1105	2	lapsers
lasers	6	49	2570	2	las_ers
lashers	10	41	2183	2	lashers
lasters	7	56	2769	2	lasters
lispers	9	45	1432	2	lispers
mappers	13	33	1378	2	mappers
masers	8	46	2345	2	mas_ers
mashers	12	46	2105	2	mashers
maskers	13	39	1384	2	maskers
masters	9	46	2892	2	masters
nappers	11	42	1486	2	nappers
pampers	13	36	1593	2	pampers
papers	10	51	2532	2	pa_pers
passers	9	47	1775	2	passers
pasters	9	45	3173	2	pasters
paupers	11	43	1107	2	paupers
rapers	8	43	2718	2	ra_pers
rappers	11	36	1844	2	rappers
rasers	6	45	2678	2	ras_ers
rashers	10	40	2091	2	rashers
rasper	8	39	1733	2	rasper_
rasters	7	46	2902	2	rasters
sappers	11	35	1890	2	sappers
tampers	11	35	1674	2	tampers
tapers	8	40	2581	2	ta_pers
tappers	11	34	1654	2	tappers
tasters	7	42	2564	2	tasters
vampers	14	31	1162	2	vampers
vespers	12	3	903	2	vespers
warpers	12	34	1358	2	warpers
washers	13	45	1752	2	washers
wasters	10	40	2659	2	wasters
yappers	14	40	1225	2	yappers
yaupers	12	33	766	2	yaupers
yawpers	15	34	685	2	yawpers
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	87	3.326	32372.5
3	Display Results	87	87	0.033	2636.4
	(SQL Overall)	178691	87	3.735	47842.3