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

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

58 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
swappers	15	35	808	(None)
sappers	11	35	1890	1	s_appers
slappers	12	37	1094	1	slappers
snappers	12	35	1017	1	snappers
swampers	15	31	747	1	swampers
swapper	14	35	970	1	swapper_
cappers	13	44	1940	2	_cappers
clappers	14	33	1083	2	clappers
crappers	14	40	1102	2	crappers
flappers	15	38	838	2	flappers
knappers	16	31	564	2	knappers
lappers	11	37	1746	2	_lappers
mappers	13	33	1378	2	_mappers
nappers	11	42	1486	2	_nappers
rappers	11	36	1844	2	_rappers
sapper	10	38	2235	2	s_apper_
scalpers	12	37	1086	2	scalpers
scampers	14	36	1103	2	scampers
scarpers	12	47	1251	2	scarpers
scaupers	12	37	817	2	scaupers
scrappers	15	4	586	2	scrappers
scuppers	14	4	654	2	scuppers
shapers	12	40	1689	2	sha_pers
sharpers	13	38	1094	2	sharpers
shippers	15	30	1231	2	shippers
shoppers	15	30	1076	2	shoppers
sippers	11	31	1775	2	s_ippers
skippers	16	31	820	2	skippers
slapper	11	35	1246	2	slapper_
slippers	12	37	1123	2	slippers
snapper	11	35	1207	2	snapper_
snippers	12	29	972	2	snippers
soapers	9	37	1592	2	soa_pers
stampers	12	42	1160	2	stampers
staplers	10	31	1120	2	staplers
steppers	12	28	928	2	steppers
stoppers	12	39	1059	2	stoppers
strappers	13	4	674	2	strappers
suppers	11	33	1470	2	s_uppers
swabbers	15	31	674	2	swabbers
swagers	11	42	1102	2	swa_gers
swaggers	13	40	722	2	swaggers
swamper	14	34	931	2	swamper_
swapped	15	42	914	2	swappe_d
swarmers	13	4	632	2	swarmers
swashers	14	38	953	2	swashers
swathers	14	45	1208	2	swathers
swatters	11	39	1179	2	swatters
swayers	13	39	885	2	swa_yers
sweepers	13	34	816	2	sweepers
swoopers	13	31	752	2	swoopers
tappers	11	34	1654	2	_tappers
trappers	12	37	1104	2	trappers
warpers	12	34	1358	2	_warpers
whappers	18	27	674	2	whappers
wrappers	15	30	693	2	wrappers
yappers	14	40	1225	2	_yappers
zappers	20	39	1163	2	_zappers

Search took 5 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	121059	0.406	440125.6
2	DLD Change Limit	121059	58	3.610	33534.3
3	Display Results	58	58	0.013	4461.5
	(SQL Overall)	178691	58	4.029	44351.2