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

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

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.

50 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
landscapers	16	5	230	(None)
landscaper	15	5	299	1	landscaper_
landscapes	15	4	411	1	landscape_s
landscape	14	4	399	2	landscape__
landscaped	16	5	284	2	landscape_d
handicappers	22	7	130	3	handicappers
landlopers	13	4	367	3	land_lopers
landscaping	17	5	229	3	landscaping
landscapist	16	5	220	3	landscapist
landscapists	17	6	133	3	landscapists
relandscapes	17	6	152	3	relandscape_s
sandpapers	15	11	371	3	sand_papers
airscapes	13	4	502	4	_airscape_s
bandagers	13	3	588	4	band__agers
bandleaders	15	5	271	4	bandleaders
cardsharpers	20	16	130	4	cardsharpers
cloudscapes	18	13	146	4	cloudscape_s
endpapers	14	4	364	4	_end_papers
escapers	12	33	741	4	___escapers
glasspapers	16	5	155	4	gla_sspapers
hanapers	13	4	696	4	han___apers
handcars	14	3	762	4	hand_ca__rs
handicapper	21	6	156	4	handicapper_
handicaps	17	4	408	4	handicap__s
handshakes	21	4	356	4	handshake_s
inscapes	12	3	781	4	_in_scape_s
lancers	9	36	1664	4	lan__c__ers
lanciers	10	30	854	4	lan__c_iers
landers	8	40	2621	4	land____ers
landgraves	15	4	267	4	landgrave_s
landholders	16	5	325	4	landholders
landlers	9	43	1283	4	land___lers
landloper	12	4	388	4	land_loper_
landlubbers	16	5	108	4	landlubbers
landowners	14	4	348	4	land_owners
landsides	11	11	674	4	lands_ide_s
landskips	16	8	327	4	landskip__s
landslides	12	8	418	4	landslide_s
landslips	12	8	401	4	landslip__s
lascars	9	7	901	4	la__sca__rs
manducates	15	4	559	4	manducate_s
manslayers	15	4	268	4	man_slayers
ransackers	16	4	334	4	ran_sackers
relandscape	16	8	147	4	relandscape__
relandscaped	18	8	124	4	relandscape_d
sandpaper	14	12	428	4	sand_paper_
sandpapery	18	11	212	4	sand_papery
sandpipers	15	9	285	4	sand_pipers
sandsoaps	12	4	368	4	sandsoap__s
sandspurs	12	4	258	4	sands__purs

Search took 10 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	148819	0.156	1145455.1
2	DLD Change Limit	148819	50	9.703	15337.4
3	Display Results	50	50	0.030	1666.7
	(SQL Overall)	178691	50	9.889	18069.7