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

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

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.

38 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
weatherperson	21	6	172	(None)
weatherpersons	22	7	159	1	weatherpersons
weatherproof	23	6	204	3	weatherp_roof
gentleperson	15	6	124	4	gentle_person
weathermen	18	4	450	4	weatherme___n
weatherproofs	24	6	177	4	weatherp_roofs
weatherworn	20	5	261	4	weatherwor__n
anchorperson	19	6	144	5	_anchorperson
blatherers	15	17	534	5	blather_ers__
cameraperson	18	6	133	5	_ca_meraperson
chairperson	18	5	152	5	cha__irperson
featherbeds	20	19	357	5	featherbeds__
featherbrain	20	12	234	5	feather_brain
featherier	16	4	580	5	featherier___
featheriest	17	4	568	5	featherie_s_t
featherless	17	4	391	5	featherle_s_s
gatherers	13	15	688	5	_gather_ers__
gentlepersons	16	10	114	5	gentle_persons
latherers	12	15	885	5	_lather_ers__
salesperson	13	5	190	5	_sa_lesperson
superperson	15	5	459	5	__superperson
waitperson	15	6	208	5	w_a__itperson
waterers	11	23	1278	5	w_at_er_ers__
watermelon	15	5	222	5	w_at_erme_lon
waterproof	18	5	353	5	w_at_erp_roof
weathercast	19	27	366	5	weather_cas_t
weathercasts	20	25	250	5	weather_casts
weathered	16	16	851	5	weather_e___d
weatherglass	19	6	158	5	weatherglas_s
weatherings	18	9	526	5	weatherings__
weatherization	29	5	414	5	weatherization
weatherizes	26	4	594	5	weatherizes__
weatherman	18	5	424	5	weath___erman
weatherproofed	26	7	134	5	weatherp_roofed
weatherproofing	27	7	116	5	weatherp_roofing
weathers	14	34	1283	5	weath___ers__
westerners	13	4	446	5	west_erners__
witherers	15	14	684	5	w_ither_ers__

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	124790	0.406	440125.6
2	DLD Change Limit	124790	38	9.390	13289.7
3	Display Results	38	38	0.016	2375.0
	(SQL Overall)	178691	38	9.812	18211.5