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

Here are the results of your fuzzy-string dictionary search for “advertiser” with Change Limit: [1] [2] [3] [4]

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.

21 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
advertiser	14	4	361	(None)
advertise	13	4	610	1	advertise_
advertised	15	4	409	1	advertised
advertisers	15	5	254	1	advertisers
advertises	14	4	591	1	advertises
advertize	22	4	538	2	advertize_
advertized	24	4	379	2	advertized
advertizes	23	4	467	2	advertizes
advective	18	4	523	3	advective_
adventive	16	4	581	3	adventive_
adventives	17	4	512	3	adventives
adventurer	14	4	297	3	adventurer
adverse	11	4	595	3	adver__se_
adverted	13	3	610	3	advert__ed
adverting	14	3	722	3	adverti_ng
advertising	16	14	361	3	advertising
adverts	11	30	851	3	advert_s__
adviser	11	13	578	3	adv___iser
appetiser	13	4	444	3	appe_tiser
averter	10	24	1055	3	a_vert__er
unadvertised	17	5	155	3	unadvertised

Search took 7 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	140603	0.406	440125.6
2	DLD Change Limit	140603	21	5.970	23551.6
3	Display Results	21	21	0.013	1615.4
	(SQL Overall)	178691	21	6.389	27968.5