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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

148 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
flightiness	18	4	389	(None)
almightiness	18	5	191	2	almightiness
flightiest	17	4	450	2	flighti_est
flightinesses	20	5	313	2	flightinesses
flightless	17	7	339	2	flight_less
flintiness	13	4	589	2	fli_ntiness
lightness	13	10	743	2	_light_ness
mightiness	16	4	509	2	_mightiness
slightness	14	5	480	2	slight_ness
weightiness	18	4	326	2	weightiness
blighties	15	4	622	3	blighti_e_s
brightness	16	4	457	3	bright_ness
doughtiness	16	4	270	3	doughtiness
feistiness	13	4	507	3	fei_stiness
fidgetiness	16	5	191	3	fidgetiness
fightings	17	27	650	3	f_ightin_gs
filthiness	16	4	371	3	filth_iness
fishiness	15	3	734	3	f_ish_iness
flashiness	16	10	528	3	flash_iness
fleshiness	16	10	429	3	flesh_iness
flightier	16	4	442	3	flighti_e_r
flighting	17	3	610	3	flightin__g
flimsiness	15	4	345	3	fli_msiness
haughtiness	18	4	223	3	haughtiness
knightliness	20	5	273	3	knightliness
lighteners	14	4	498	3	_lighteners
lightings	14	27	772	3	_lightin_gs
lightless	13	8	607	3	_light_less
naughtiness	15	4	238	3	naughtiness
rightness	13	11	735	3	_right_ness
sightliness	15	7	456	3	_sightliness
tightness	13	8	660	3	_tight_ness
alighting	14	4	641	4	alightin__g
alightments	17	9	276	4	alightments
almightinesses	20	5	183	4	almightinesses
bittiness	11	22	833	4	_bi_ttiness
blighters	15	5	574	4	blight__ers
blighting	16	3	573	4	blightin__g
brighteners	17	5	286	4	brighteners
daintiness	11	4	596	4	dai_ntiness
delightedness	19	5	338	4	delightedness
dirtiness	10	3	947	4	_di_rtiness
droughtiness	17	5	191	4	droughtiness
eighties	12	7	1080	4	_eighti_e_s
faintness	12	3	583	4	fai_nt_ness
fattiness	12	23	937	4	f__attiness
faultiness	13	4	482	4	f_aultiness
fieriness	12	3	862	4	f_i_eriness
fighters	15	26	940	4	f_ight__ers
fighting	16	27	1008	4	f_ightin__g
figulines	13	4	504	4	f_iguline_s
figurines	13	4	450	4	f_igurine_s
filminess	14	3	598	4	f_i_lminess
finiteness	13	4	711	4	f_initeness
firstness	12	4	501	4	f_irst_ness
fishlines	15	24	684	4	f_ishline_s
fitness	10	29	939	4	f_i__t_ness
flabbiness	17	4	252	4	fl_abbiness
flagstones	14	4	400	4	flagstone_s
flakiness	16	3	647	4	fl__akiness
flatness	11	3	815	4	fl__at_ness
fleetness	12	4	475	4	fl_eet_ness
flichters	17	7	417	4	flicht__ers
flighted	16	4	697	4	flight__e_d
flightily	19	4	335	4	flighti__ly
flights	14	33	1098	4	flight____s
flintiest	12	4	843	4	fli_nti_est
flintinesses	15	4	632	4	fli_ntinesses
flirtiest	12	3	619	4	fli_rti_est
floppiness	17	4	286	4	fl_oppiness
floweriness	17	4	307	4	floweriness
fluffiness	15	4	260	4	fl_uffiness
flukiness	16	3	545	4	fl__ukiness
flushness	15	4	489	4	flush__ness
fogginess	14	3	497	4	f_og_giness
frightened	18	4	324	4	frightene_d
frightens	16	5	539	4	fright__ens
frightfulness	23	6	320	4	frightfulness
frighting	17	3	602	4	frightin__g
frigidness	15	4	311	4	frig_idness
friskiness	17	4	445	4	fri_skiness
frizziness	21	4	271	4	fri_zziness
frostiness	13	3	656	4	f_rostiness
frothiness	16	4	572	4	froth_iness
fruitiness	13	4	599	4	f_ruitiness
fustiness	12	19	1024	4	f__ustiness
grittiness	11	4	516	4	gri_ttiness
guiltiness	11	4	419	4	gui_ltiness
highness	15	3	605	4	_high__ness
legginess	11	3	503	4	_leg_giness
lengthiness	15	5	232	4	lengthiness
licitness	11	4	537	4	_licit_ness
lightened	14	4	602	4	_lightene_d
lightener	13	4	569	4	_lightene_r
lightens	12	25	1000	4	_light__ens
lighters	12	31	1139	4	_light__ers
lightest	12	14	1035	4	_light__est
lighting	13	28	1183	4	_lightin__g
lightish	15	5	662	4	_lighti__sh
lightnesses	15	4	614	4	_light_nesses
lightnings	15	26	380	4	_lightnings
ligroines	10	4	499	4	_ligroine_s
liminess	10	5	1064	4	_li__miness
lippiness	13	3	541	4	_li_ppiness
liteness	8	22	1321	4	_li__teness
litheness	12	4	736	4	_lith_eness
liveliness	13	4	563	4	_liveliness
loftiness	12	3	657	4	_l_oftiness
loginess	9	3	1016	4	_log__iness
lustiness	9	20	1045	4	_l_ustiness
mightiest	15	4	644	4	_mighti_est
mightinesses	18	4	438	4	_mightinesses
mistiness	11	19	1163	4	_mi_stiness
niftiness	12	3	636	4	_ni_ftiness
nighness	12	3	610	4	_nigh__ness
nightdress	15	5	298	4	_nightdress
nighties	12	10	1138	4	_nighti_e_s
nightless	13	8	607	4	_night_less
pigginess	13	7	545	4	_pig_giness
pithiness	14	3	756	4	_pith_iness
pliantness	12	6	364	4	pliant_ness
plighters	15	4	553	4	plight__ers
plighting	16	3	556	4	plightin__g
plushiness	15	4	409	4	plush_iness
righties	12	7	1157	4	_righti_e_s
shiftiness	16	4	479	4	shi_ftiness
sightings	14	25	653	4	_sightin_gs
sightless	13	8	592	4	_sight_less
sightlines	14	6	575	4	_sightline_s
slatiness	9	25	1136	4	sl__atiness
slighters	13	4	671	4	slight__ers
slightest	13	13	694	4	slight__est
slighting	14	3	637	4	slightin__g
slightingly	19	5	226	4	slightingly
slightnesses	16	5	462	4	slight_nesses
sliminess	11	3	742	4	sli__miness
slinkiness	14	4	515	4	sli_nkiness
slushiness	13	4	464	4	slush_iness
sprightliness	19	6	209	4	sprightliness
thirstiness	14	4	269	4	thirstiness
tighteners	14	4	404	4	_tighteners
unsightliness	17	6	251	4	unsightliness
uprightness	17	5	285	4	upright_ness
uptightness	17	5	214	4	uptight_ness
weightiest	17	4	342	4	weighti_est
weightinesses	20	5	290	4	weightinesses
weightless	17	4	271	4	weight_less
wittiness	12	19	722	4	_wi_ttiness

Search took 9 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.173	1032896.0
2	DLD Change Limit	148819	148	8.530	17446.5
3	Display Results	148	148	0.063	2349.2
	(SQL Overall)	178691	148	8.766	20384.6