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

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

110 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
mappers	13	33	1378	(None)
cappers	13	44	1940	1	cappers
lappers	11	37	1746	1	lappers
mapper	12	45	1609	1	mapper_
moppers	13	34	1246	1	moppers
nappers	11	42	1486	1	nappers
rappers	11	36	1844	1	rappers
sappers	11	35	1890	1	sappers
tappers	11	34	1654	1	tappers
yappers	14	40	1225	1	yappers
zappers	20	39	1163	1	zappers
apers	7	66	2913	2	_a_pers
appears	11	30	895	2	_appears
appels	10	43	1279	2	_appels
aspers	8	62	2031	2	_aspers
boppers	13	39	1192	2	boppers
campers	13	42	2029	2	campers
capers	10	54	2814	2	ca_pers
capper	12	44	2198	2	capper_
carpers	11	45	2125	2	carpers
clappers	14	33	1083	2	clappers
coppers	13	35	1975	2	coppers
crappers	14	40	1102	2	crappers
cuppers	13	37	1221	2	cuppers
dampers	12	39	1569	2	dampers
dapper	11	40	1663	2	dapper_
dippers	12	36	1518	2	dippers
flappers	15	38	838	2	flappers
gapers	9	45	2047	2	ga_pers
gaspers	10	50	1413	2	gaspers
gawpers	13	44	831	2	gawpers
gippers	12	32	1208	2	gippers
gyppers	15	23	550	2	gyppers
hampers	14	36	1695	2	hampers
happens	14	35	917	2	happens
harpers	12	49	1620	2	harpers
hoppers	14	31	1514	2	hoppers
japers	15	46	1617	2	ja_pers
jaspers	16	43	1046	2	jaspers
kippers	15	32	1143	2	kippers
knappers	16	31	564	2	knappers
lampers	11	38	1733	2	lampers
lapper	10	43	1995	2	lapper_
lappets	11	32	912	2	lappets
lapsers	9	39	1105	2	lapsers
lippers	11	34	1644	2	lippers
loppers	11	30	1410	2	loppers
macers	10	53	2127	2	ma_cers
madders	11	35	1321	2	madders
mailers	9	44	2033	2	mailers
maimers	11	38	1304	2	maimers
makers	12	39	2173	2	ma_kers
mammers	10	46	1569	2	mammers
mamzers	20	40	916	2	mamzers
mangers	10	35	2126	2	mangers
manners	9	34	1783	2	manners
maples	10	48	1942	2	maple_s
mapped	13	40	1588	2	mappe_d
markers	13	35	1610	2	markers
marrers	9	34	1431	2	marrers
masers	8	46	2345	2	ma_sers
mashers	12	46	2105	2	mashers
maskers	13	39	1384	2	maskers
masters	9	46	2892	2	masters
maters	8	50	3239	2	ma_ters
matters	9	44	2175	2	matters
maulers	9	42	1330	2	maulers
mazers	17	39	1709	2	ma_zers
mopers	10	42	2037	2	m_opers
mopper	12	62	1500	2	mopper_
moppets	13	30	716	2	moppets
mumpers	13	33	1137	2	mumpers
napper	10	37	1828	2	napper_
nappes	10	45	1562	2	nappe_s
nippers	11	30	1262	2	nippers
pampers	13	36	1593	2	pampers
papers	10	51	2532	2	pa_pers
paupers	11	43	1107	2	paupers
peppers	10	33	1144	2	peppers
poppers	10	34	1486	2	poppers
rapers	8	43	2718	2	ra_pers
rapiers	9	50	1287	2	rapiers
rappees	11	36	1145	2	rappees
rappels	11	44	880	2	rappels
rapper	10	46	2157	2	rapper_
raspers	9	44	1592	2	raspers
rippers	11	41	1503	2	rippers
sapper	10	38	2235	2	sapper_
sippers	11	31	1775	2	sippers
slappers	12	37	1094	2	slappers
snappers	12	35	1017	2	snappers
suppers	11	33	1470	2	suppers
swappers	15	35	808	2	swappers
tampers	11	35	1674	2	tampers
tapers	8	40	2581	2	ta_pers
tapper	10	44	1961	2	tapper_
tappets	11	36	1001	2	tappets
tippers	11	34	1435	2	tippers
toppers	11	39	1460	2	toppers
trappers	12	37	1104	2	trappers
uppers	10	29	1229	2	_uppers
vampers	14	31	1162	2	vampers
warpers	12	34	1358	2	warpers
whappers	18	27	674	2	whappers
wrappers	15	30	693	2	wrappers
yapper	13	37	1451	2	yapper_
yaupers	12	33	766	2	yaupers
yawpers	15	34	685	2	yawpers
zapper	19	34	1402	2	zapper_
zippers	20	33	1038	2	zippers

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.373	479064.3
2	DLD Change Limit	107671	110	3.360	32044.9
3	Display Results	110	110	0.033	3333.3
	(SQL Overall)	178691	110	3.766	47448.5