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

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

70 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
plashers	13	38	1345	(None)
clashers	13	42	1399	1	clashers
flashers	14	39	1265	1	flashers
lashers	10	41	2183	1	_lashers
plasher	12	42	1503	1	plasher_
plashes	12	44	1739	1	plashe_s
plasters	10	35	1813	1	plasters
slashers	11	33	1361	1	slashers
splashers	14	4	528	1	splashers
bashers	12	48	2083	2	_bashers
blasters	10	41	1614	2	blasters
blathers	13	47	1379	2	blathers
blushers	13	39	1129	2	blushers
clasher	12	46	1551	2	clasher_
clashes	12	40	1728	2	clashe_s
claspers	12	44	1091	2	claspers
classers	10	41	1183	2	classers
crashers	13	40	1323	2	crashers
dashers	11	50	1686	2	_dashers
flasher	13	39	1406	2	flasher_
flashes	13	39	1610	2	flashe_s
fleshers	14	33	944	2	fleshers
flushers	14	27	973	2	flushers
kashers	14	39	1402	2	_kashers
lasers	6	49	2570	2	_las_ers
lasher	9	48	2453	2	_lasher_
lashes	9	48	3100	2	_lashe_s
lasters	7	56	2769	2	_lasters
lathers	10	43	2188	2	_lathers
mashers	12	46	2105	2	_mashers
pashes	11	58	2839	2	p_ashe_s
passers	9	47	1775	2	p_assers
pasters	9	45	3173	2	p_asters
peachers	15	32	1384	2	peachers
piasters	10	29	1281	2	piasters
pilasters	11	3	822	2	pilasters
pishers	12	38	1575	2	p_ishers
placers	11	45	1526	2	pla_cers
plaguers	11	28	650	2	plaguers
plaisters	11	3	781	2	plaisters
plaiters	10	35	1263	2	plaiters
planers	9	45	1794	2	pla_ners
planishers	15	8	477	2	planishers
planners	10	39	993	2	planners
planters	10	29	1532	2	planters
plashed	13	37	1264	2	plashe_d
plashier	13	3	761	2	plashier_
plaster	9	33	1869	2	plaster_
plastery	13	27	970	2	plastery
platers	9	39	2409	2	pla_ters
platters	10	34	1528	2	platters
players	12	43	1376	2	pla_yers
pleasers	10	40	1029	2	pleas_ers
pleathers	14	4	645	2	pleathers
plusher	12	40	1038	2	plusher_
plushes	12	43	1367	2	plushe_s
poachers	15	29	1076	2	poachers
polishers	14	7	760	2	polishers
pushers	12	38	1450	2	p_ushers
quashers	20	18	681	2	quashers
rashers	10	40	2091	2	_rashers
slasher	10	45	1533	2	slasher_
slashes	10	36	1911	2	slashe_s
slathers	11	39	1478	2	slathers
smashers	13	33	959	2	smashers
splasher	13	3	566	2	splasher_
splashes	13	3	750	2	splashe_s
swashers	14	38	953	2	swashers
trashers	11	30	1364	2	trashers
washers	13	45	1752	2	_washers

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	121059	0.406	440125.6
2	DLD Change Limit	121059	70	3.453	35059.1
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	3.889	45947.8