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

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

37 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
proofers	13	11	836	(None)
proffers	16	12	659	1	proffers
proofer	12	14	910	1	proofer_
roofers	10	50	1390	1	_roofers
brooders	11	26	1024	2	brooders
crooners	10	39	1139	2	crooners
groomers	11	38	848	2	groomers
groovers	12	33	712	2	groovers
hoofers	13	45	1333	2	_hoofers
poofters	13	3	692	2	p_oofters
poolers	9	42	1742	2	p_oolers
prefers	12	37	1333	2	pr_efers
probers	11	35	1458	2	pr_obers
prodders	12	3	746	2	prodders
profess	12	3	771	2	pr_ofess
proffer	15	12	693	2	proffer_
proggers	12	25	816	2	proggers
promoters	13	3	1009	2	promoters
proofed	13	13	872	2	proofe_d
proofs	11	45	1168	2	proof__s
propers	11	36	1903	2	pr_opers
proposers	13	22	852	2	proposers
prosers	9	42	1964	2	pr_osers
prospers	12	30	1226	2	prospers
provers	12	38	1779	2	pr_overs
provokers	18	9	420	2	provokers
prowlers	13	32	893	2	prowlers
rolfers	10	40	1181	2	_rolfers
roofer	9	44	1528	2	_roofer_
roomers	9	54	1641	2	_roomers
roosers	7	42	1788	2	_roosers
rooters	7	45	2293	2	_rooters
spoofers	13	30	732	2	spoofers
troffers	14	12	543	2	troffers
troopers	10	28	944	2	troopers
uprooters	11	6	425	2	uprooters
woofers	13	38	1058	2	_woofers

Search took 5 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.376	475242.0
2	DLD Change Limit	121059	37	3.936	30756.9
3	Display Results	37	37	0.016	2312.5
	(SQL Overall)	178691	37	4.328	41287.2