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

Here are the results of your fuzzy-string dictionary search for “plasher” 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
plasher	12	42	1503	(None)
clasher	12	46	1551	1	clasher
flasher	13	39	1406	1	flasher
lasher	9	48	2453	1	_lasher
plashed	13	37	1264	1	plashed
plashers	13	38	1345	1	plashers
plashes	12	44	1739	1	plashes
plashier	13	3	761	1	plashier
plaster	9	33	1869	1	plaster
plusher	12	40	1038	1	plusher
slasher	10	45	1532	1	slasher
splasher	13	3	565	1	splasher
basher	11	51	2381	2	_basher
blaster	9	40	1730	2	blaster
blather	12	53	1420	2	blather
blusher	12	41	1311	2	blusher
brasher	12	45	1523	2	brasher
clashed	13	36	1401	2	clashed
clashers	13	42	1399	2	clashers
clashes	12	40	1728	2	clashes
clasper	11	38	1186	2	clasper
classer	9	36	1461	2	classer
crasher	12	46	1615	2	crasher
dasher	10	43	1898	2	_dasher
flashed	14	41	1218	2	flashed
flashers	14	39	1265	2	flashers
flashes	13	39	1610	2	flashes
flashier	14	3	710	2	flashier
flesher	13	36	1092	2	flesher
flusher	13	30	1227	2	flusher
gasher	10	43	2037	2	_gasher
kasher	13	49	1503	2	_kasher
laser	5	46	3332	2	_las_er
lashed	10	56	2521	2	_lashed
lashers	10	41	2183	2	_lashers
lashes	9	48	3100	2	_lashes
laster	6	48	3063	2	_laster
lather	9	51	2435	2	_lather
lusher	9	38	1876	2	_lusher
masher	11	41	2320	2	_masher
pashed	12	59	2314	2	p_ashed
pashes	11	58	2839	2	p_ashes
passer	8	47	2103	2	p_asser
paster	8	57	3437	2	p_aster
peacher	14	42	1607	2	peacher
piaster	9	30	1288	2	piaster
pilaster	10	3	816	2	pilaster
pisher	11	43	1775	2	p_isher
placer	10	51	1774	2	pla_cer
plaguer	10	32	827	2	plaguer
plainer	9	38	1198	2	plainer
plaister	10	6	801	2	plaister
plaiter	9	36	1539	2	plaiter
planer	8	41	2265	2	pla_ner
planisher	14	9	585	2	planisher
planner	9	35	1162	2	planner
planter	9	40	1780	2	planter
plash	10	46	1656	2	plash__
plashy	14	44	887	2	plash_y
plasters	10	35	1813	2	plasters
plastery	13	27	970	2	plastery
plater	8	44	2769	2	pla_ter
platier	9	37	1629	2	platier
platter	9	39	1741	2	platter
player	11	52	1521	2	pla_yer
pleaser	9	39	1234	2	pleas_er
pleather	13	5	665	2	pleather
plushes	12	43	1367	2	plushes
plushier	13	7	519	2	plushier
poacher	14	39	1232	2	poacher
polisher	13	8	807	2	polisher
posher	11	50	1816	2	p_osher
pusher	11	43	1828	2	p_usher
quasher	19	19	862	2	quasher
rasher	9	50	2411	2	_rasher
slashed	11	41	1485	2	slashed
slashers	11	33	1360	2	slashers
slashes	10	36	1910	2	slashes
slather	10	38	1606	2	slather
smasher	12	39	1101	2	smasher
splashed	14	3	559	2	splashed
splashers	14	4	527	2	splashers
splashes	13	3	750	2	splashes
splashier	14	4	359	2	splashier
swasher	13	40	1150	2	swasher
trasher	10	44	1612	2	trasher
washer	12	47	2039	2	_washer

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.123	1452772.4
2	DLD Change Limit	107671	87	3.190	33752.7
3	Display Results	87	87	0.030	2900.0
	(SQL Overall)	178691	87	3.343	53452.3