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

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

63 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
smashed	13	37	1122	(None)
mashed	12	53	2504	1	_mashed
sashed	10	56	2294	1	s_ashed
slashed	11	41	1485	1	slashed
smasher	12	39	1101	1	smasher
smashes	12	39	1461	1	smashes
smushed	13	36	823	1	smushed
stashed	11	38	1248	1	stashed
swashed	14	43	1136	1	swashed
abashed	13	5	766	2	abashed
amassed	10	38	862	2	amassed
ashed	9	78	2977	2	__ashed
bashed	12	62	2570	2	_bashed
cashed	12	51	2435	2	_cashed
clashed	13	36	1401	2	clashed
crashed	13	42	1420	2	crashed
dashed	11	59	2056	2	_dashed
deashed	12	34	1130	2	deashed
fashed	13	67	2025	2	_fashed
flashed	14	41	1218	2	flashed
gashed	11	63	2197	2	_gashed
gnashed	12	31	752	2	gnashed
hashed	13	60	2194	2	_hashed
lashed	10	56	2521	2	_lashed
leashed	11	32	1116	2	leashed
masher	11	41	2320	2	_masher
mashes	11	50	3000	2	_mashes
masked	13	43	1652	2	_masked
massed	9	44	2132	2	_massed
masted	9	40	2580	2	_masted
meshed	12	44	1593	2	_meshed
moshed	12	45	1749	2	_moshed
mushed	12	44	2084	2	_mushed
pashed	12	59	2314	2	_pashed
plashed	13	37	1264	2	plashed
quashed	20	20	797	2	quashed
sashes	9	47	2848	2	s_ashes
sassed	7	61	1617	2	s_assed
scathed	13	40	1264	2	scathed
shushed	14	34	849	2	shushed
slasher	10	45	1532	2	slasher
slashes	10	36	1910	2	slashes
sloshed	11	32	982	2	sloshed
slushed	11	36	1124	2	slushed
smacked	16	37	1099	2	smacked
smarted	10	50	1261	2	smarted
smash	10	48	1443	2	smash__
smashers	13	33	958	2	smashers
smashup	14	4	345	2	smashup
smooshed	14	18	599	2	smooshed
smushes	12	37	1009	2	smushes
snashes	10	52	1475	2	snashes
spasmed	12	29	699	2	spasmed
spathed	13	40	1318	2	spathed
splashed	14	3	559	2	splashed
squashed	21	21	598	2	squashed
stashes	10	39	1616	2	stashes
swasher	13	40	1150	2	swasher
swashes	13	47	1440	2	swashes
swathed	14	46	1193	2	swathed
swished	14	41	884	2	swished
trashed	11	35	1469	2	trashed
washed	13	55	2150	2	_washed

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.140	1276364.3
2	DLD Change Limit	107671	63	3.470	31029.1
3	Display Results	63	63	0.013	4846.2
	(SQL Overall)	178691	63	3.623	49321.3