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

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

53 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
proofed	13	13	872	(None)
proofer	12	14	910	1	proofer
roofed	10	52	1474	1	_roofed
brooded	11	35	1093	2	brooded
brooked	14	36	1003	2	brooked
broomed	12	41	1105	2	broomed
crooked	14	39	1094	2	crooked
crooned	10	38	1334	2	crooned
drooled	9	36	920	2	drooled
drooped	11	36	843	2	drooped
goofed	11	49	1138	2	_goofed
groomed	11	37	950	2	groomed
grooved	12	34	725	2	grooved
hoofed	13	46	1489	2	_hoofed
pooed	8	52	2624	2	p_oo_ed
poohed	12	39	1252	2	p_oohed
pooled	9	46	1981	2	p_ooled
pooped	11	39	1594	2	p_ooped
poufed	12	44	971	2	p_oufed
probed	11	41	1482	2	pr_obed
proceed	12	3	1055	2	proceed
prodded	12	5	773	2	prodded
proffer	15	12	693	2	proffer
progged	12	40	980	2	progged
prologed	12	18	921	2	prologed
promoed	12	3	1008	2	promoed
promoted	13	3	1054	2	promoted
pronged	11	39	1239	2	pronged
proof	10	52	2153	2	proof__
proofers	13	11	836	2	proofers
proofread	15	4	211	2	proofread
proofs	11	45	1168	2	proof_s
proponed	13	24	1203	2	proponed
proposed	13	20	1107	2	proposed
propped	11	33	1195	2	propped
prosed	9	49	2109	2	pr_osed
proved	12	50	1603	2	pr_oved
provoked	18	7	505	2	provoked
prowled	13	30	991	2	prowled
reroofed	12	3	587	2	reroofed
rolfed	10	45	1052	2	_rolfed
roofer	9	44	1528	2	_roofer
rooked	11	49	1814	2	_rooked
roomed	9	52	1854	2	_roomed
roosed	7	56	2159	2	_roosed
rooted	7	54	2400	2	_rooted
spoofed	13	39	910	2	spoofed
trooped	10	40	1072	2	trooped
unroofed	12	10	677	2	unroofed
uprooted	11	8	639	2	uprooted
vroomed	13	36	643	2	vroomed
whoofed	17	37	451	2	whoofed
woofed	13	45	1120	2	_woofed

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	53	3.530	30501.7
3	Display Results	53	53	0.016	3312.5
	(SQL Overall)	178691	53	3.922	45561.2