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

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

60 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
waterlessnesses	17	5	472	(None)
waterlessness	16	5	385	2	waterlessne_s_s
agelessnesses	13	8	762	3	_age_lessnesses
airlessnesses	12	11	799	3	_a_irlessnesses
carelessnesses	15	4	772	3	care_lessnesses
cheerlessnesses	19	5	454	3	cheerlessnesses
facelessnesses	18	4	732	3	face_lessnesses
hairlessnesses	16	12	663	3	ha_irlessnesses
namelessnesses	15	7	705	3	name_lessnesses
pathlessnesses	18	5	595	3	pat_hlessnesses
powerlessnesses	19	5	449	3	powerlessnesses
statelessnesses	13	5	586	3	state_lessnesses
tastelessnesses	13	5	527	3	taste_lessnesses
waterishnesses	20	5	316	3	water_ishnesses
witlessnesses	15	4	723	3	wit__lessnesses
aimlessnesses	14	8	746	4	_a_imlessnesses
artlessnesses	12	4	766	4	_a_rtlessnesses
blamelessnesses	18	6	571	4	blame_lessnesses
ceaselessnesses	15	9	616	4	cease_lessnesses
colorlessnesses	16	6	509	4	colorlessnesses
dauntlessnesses	15	5	481	4	dauntlessnesses
deathlessnesses	18	8	517	4	deat_hlessnesses
faithlessnesses	20	7	497	4	faithlessnesses
faultlessnesses	17	5	493	4	faultlessnesses
fearlessnesses	16	6	674	4	_fearlessnesses
gracelessnesses	17	5	590	4	grace_lessnesses
gutlessnesses	13	4	694	4	gut__lessnesses
haplessnesses	17	4	725	4	ha__plessnesses
harmlessnesses	18	7	641	4	ha_rmlessnesses
heedlessnesses	17	13	622	4	_heedlessnesses
homelessnesses	18	13	747	4	home_lessnesses
hopelessnesses	18	14	701	4	hope_lessnesses
humorlessnesses	19	5	418	4	humorlessnesses
landlessnesses	14	5	668	4	la_ndlessnesses
lawlessnesses	15	4	638	4	la__wlessnesses
lifelessnesses	16	4	665	4	life_lessnesses
lovelessnesses	16	4	699	4	love_lessnesses
movelessnesses	18	4	674	4	move_lessnesses
needlessnesses	14	11	569	4	_needlessnesses
painlessnesses	15	4	674	4	pa_inlessnesses
pitilessnesses	15	7	575	4	pit_ilessnesses
raylessnesses	15	4	650	4	ra__ylessnesses
ruthlessnesses	16	6	538	4	rut_hlessnesses
saplessnesses	13	4	727	4	sa__plessnesses
sexlessnesses	18	4	674	4	__sexlessnesses
shamelessnesses	18	18	651	4	shame_lessnesses
shapelessnesses	18	15	629	4	shape_lessnesses
sleeplessnesses	15	5	468	4	sleeplessnesses
tactlessnesses	15	4	655	4	ta_ctlessnesses
timelessnesses	15	4	702	4	time_lessnesses
tirelessnesses	13	5	701	4	__tirelessnesses
tonelessnesses	13	13	765	4	tone_lessnesses
toplessnesses	14	4	658	4	__toplessnesses
uselessnesses	11	4	731	4	_use_lessnesses
valuelessnesses	17	6	479	4	valuelessnesses
waterinesses	15	6	719	4	water___inesses
winglessnesses	17	6	546	4	w_inglessnesses
wordlessnesses	17	7	587	4	w_ordlessnesses
worklessnesses	20	12	548	4	w_orklessnesses
worthlessnesses	20	5	455	4	worthlessnesses

Search took 3 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	43548	0.280	638182.1
2	DLD Change Limit	43548	60	1.940	22447.4
3	Display Results	60	60	0.046	1304.3
	(SQL Overall)	178691	60	2.266	78857.5