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

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

56 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
ruffled	14	36	915	(None)
muffled	16	37	778	1	muffled
raffled	14	42	908	1	raffled
riffled	14	33	860	1	riffled
ruffed	13	43	1274	1	ruff_ed
ruffle	12	41	1167	1	ruffle_
ruffler	13	36	972	1	ruffler
ruffles	13	35	1227	1	ruffles
truffled	15	6	399	1	truffled
baffled	16	41	806	2	baffled
buffed	15	43	1314	2	buff_ed
coffled	16	29	736	2	coffled
cuffed	15	43	1121	2	cuff_ed
duffle	13	36	853	2	duffle_
duffles	14	30	892	2	duffles
gruffed	15	4	494	2	gruff_ed
huffed	16	37	1015	2	huff_ed
luffed	13	38	1082	2	luff_ed
muffed	15	42	1059	2	muff_ed
muffle	14	33	964	2	muffle_
muffler	15	39	834	2	muffler
muffles	15	39	1045	2	muffles
piffled	16	36	640	2	piffled
puffed	15	35	1060	2	puff_ed
purfled	13	24	873	2	purfled
raffle	12	39	1070	2	raffle_
raffler	13	33	922	2	raffler
raffles	13	36	1184	2	raffles
reffed	13	47	1251	2	reff_ed
refiled	11	43	1865	2	refiled
riffed	13	38	1156	2	riff_ed
riffle	12	42	1023	2	riffle_
riffler	13	32	835	2	riffler
riffles	13	39	1116	2	riffles
rifled	10	41	1500	2	r_ifled
rubbled	12	46	1162	2	rubbled
ruckled	14	41	1103	2	ruckled
ruddled	10	30	1087	2	ruddled
ruffe	11	47	1381	2	ruff_e_
ruffes	12	41	1242	2	ruff_es
rufflers	14	34	719	2	rufflers
rufflier	14	3	401	2	rufflier
ruffly	15	33	667	2	ruffl_y
ruled	6	58	2252	2	ru__led
rumbled	12	45	1459	2	rumbled
rumpled	12	38	1001	2	rumpled
runkled	12	39	901	2	runkled
rustled	8	33	1132	2	rustled
scuffled	17	25	620	2	scuffled
shuffled	18	29	624	2	shuffled
snuffled	15	27	703	2	snuffled
souffled	15	27	619	2	souffled
truffle	13	8	489	2	truffle_
truffles	14	8	559	2	truffles
unruffled	16	7	292	2	unruffled
waffled	17	35	752	2	waffled

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.376	475242.0
2	DLD Change Limit	107671	56	2.936	36672.7
3	Display Results	56	56	0.033	1697.0
	(SQL Overall)	178691	56	3.345	53420.3