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

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

79 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
valiantness	14	5	231	(None)
pliantness	12	6	364	2	_pliantness
vacantness	15	6	251	2	va_cantness
valiantnesses	16	5	272	2	valiantnesses
alienness	9	4	537	3	_alien_ness
faintness	12	3	583	3	fa_i_ntness
militantness	14	5	190	3	militantness
vainness	11	3	606	3	va_i_n_ness
valiances	14	8	720	3	valian_ce_s
valiancies	15	4	528	3	valiancie_s
valiants	11	3	779	3	valiant___s
validness	13	12	536	3	vali__dness
alanines	8	3	1480	4	_al_anine_s
alertness	9	4	605	4	_al_ertness
alikeness	13	3	633	4	_ali_keness
aliveness	12	3	822	4	_ali_veness
aloneness	9	5	731	4	_al_oneness
amiantuses	12	9	270	4	_amiantuses
ancientness	13	5	335	4	ancientness
apartness	11	4	605	4	_a_partness
aviatress	12	4	243	4	_avia_tress
blandness	12	3	597	4	_bl_andness
blankness	15	4	467	4	_bl_ankness
blindness	12	3	534	4	_bli_ndness
bluntness	11	4	434	4	_bl_untness
cleanness	11	4	497	4	_clean_ness
clientless	12	7	249	4	_clientless
daintiness	11	4	596	4	da_i_ntiness
daringness	12	4	474	4	dari_ngness
darlingness	13	7	326	4	darli_ngness
distantness	12	5	433	4	distantness
flatness	11	3	815	4	_fl_a_tness
flintiness	13	4	589	4	_fli_ntiness
galantines	11	4	574	4	gal_antine_s
gauntness	10	4	420	4	ga__untness
giantess	9	3	389	4	__giant_ess
instantness	11	5	408	4	instantness
lankness	12	23	704	4	__l_ankness
leanness	8	3	737	4	__lean_ness
licitness	11	4	537	4	__licitness
lightness	13	10	743	4	__lightness
lintless	8	27	1001	4	__li_ntless
piquantness	22	5	152	4	piquantness
plainness	11	5	518	4	plai_n_ness
planeness	11	3	815	4	_pl_aneness
pliantnesses	14	4	445	4	_pliantnesses
quaintness	19	4	320	4	quai_ntness
raininess	9	4	927	4	ra_i_niness
saltness	8	26	1024	4	sal___tness
scantness	11	3	573	4	__scantness
silentness	10	4	457	4	sil_entness
slightness	14	5	480	4	_slightness
stalwartness	15	5	150	4	stalwartness
tacitness	11	3	487	4	taci__tness
taintless	9	3	573	4	ta_i_ntless
talentless	10	4	280	4	tal_entless
vacantnesses	17	4	297	4	va_cantnesses
valances	13	9	876	4	val_an_ce_s
valentines	13	4	495	4	val_entine_s
valiance	13	9	738	4	valian_ce__
valiant	10	3	1462	4	valiant____
valiantly	15	4	419	4	valiant__ly
validates	13	3	824	4	validat_e_s
validities	14	4	730	4	validitie_s
validnesses	15	7	602	4	validnesses
valines	10	45	2021	4	vali___ne_s
valuableness	17	5	478	4	valuableness
valuates	11	28	1120	4	valua_t_e_s
vapidness	15	14	442	4	vapi__dness
variableness	17	5	643	4	variableness
variances	14	11	736	4	varian_ce_s
variants	11	3	920	4	variant___s
variates	11	12	1498	4	varia_t_e_s
variousness	14	4	850	4	variousness
vastness	11	25	729	4	v___astness
venialness	13	4	460	4	venia_lness
villainess	13	4	385	4	villa_iness
vintners	11	3	457	4	v__i_ntners
warrantless	14	5	180	4	warrantless

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.423	422437.4
2	DLD Change Limit	148819	79	8.533	17440.4
3	Display Results	79	79	0.046	1717.4
	(SQL Overall)	178691	79	9.002	19850.1