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

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

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.

75 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
sloppiness	14	4	375	(None)
floppiness	17	4	286	1	floppiness
soppiness	13	3	654	1	s_oppiness
choppiness	19	7	356	2	choppiness
lippiness	13	3	541	2	_lippiness
loopiness	11	13	654	2	_loopiness
sappiness	13	3	744	2	s_appiness
sleepiness	12	4	513	2	sleepiness
sloppiest	13	4	598	2	sloppi_est
sloppinesses	16	4	405	2	sloppinesses
snappiness	14	4	383	2	snappiness
soapiness	11	3	829	2	s_oapiness
bloodiness	13	4	435	3	bloodiness
blowiness	14	3	562	3	blo_winess
cloudiness	13	4	411	3	cloudiness
dippiness	14	3	597	3	_dippiness
dopiness	11	28	997	3	_do_piness
floppies	15	4	682	3	floppi_e_s
floppiest	16	5	478	3	floppi_est
floppinesses	19	4	295	3	floppinesses
gloominess	13	4	383	3	gloominess
gloppiest	14	4	483	3	gloppi_est
glossiness	11	28	498	3	glossiness
happiness	16	3	600	3	_happiness
hippiness	16	3	546	3	_hippiness
loaminess	11	3	749	3	_loaminess
loftiness	12	3	657	3	_loftiness
loginess	9	3	1016	3	_lo_giness
looniness	9	13	757	3	_looniness
loppiest	12	24	1011	3	_loppi_est
lousiness	9	21	903	3	_lousiness
lowliness	12	3	640	3	_lowliness
lumpiness	13	3	648	3	_lumpiness
mopiness	12	25	906	3	_mo_piness
nappiness	13	3	523	3	_nappiness
nippiness	13	3	471	3	_nippiness
peppiness	12	3	518	3	_peppiness
preppiness	13	4	442	3	preppiness
ropiness	10	23	1107	3	_ro_piness
scaloppines	17	5	160	3	scaloppine_s
scrappiness	17	5	229	3	scrappiness
shoddiness	15	4	356	3	shoddiness
shoppings	17	29	507	3	shoppin_gs
showiness	15	7	607	3	sho_winess
skimpiness	18	4	286	3	skimpiness
slanginess	11	4	627	3	slanginess
slatiness	9	25	1136	3	sl_atiness
sleaziness	19	10	470	3	sleaziness
sliminess	11	3	742	3	sl_iminess
slinkiness	14	4	515	3	slinkiness
slipperiness	16	5	194	3	slipperiness
slippiest	13	4	647	3	slippi_est
sloppier	12	5	571	3	sloppi_e_r
slopping	13	38	1142	3	sloppin__g
slouchiness	16	4	265	3	slouchiness
slowness	11	3	501	3	slo__wness
slushiness	13	4	464	3	slushiness
smokiness	15	3	554	3	smo_kiness
snootiness	10	8	583	3	snootiness
snottiness	10	5	559	3	snottiness
snowiness	12	9	624	3	sno_winess
sogginess	11	3	618	3	s_ogginess
sootiness	9	9	983	3	s_ootiness
soppiest	12	25	1194	3	s_oppi_est
soppinesses	15	6	684	3	s_oppinesses
sorriness	9	3	958	3	s_orriness
sponginess	13	4	459	3	sponginess
spookiness	16	4	443	3	spookiness
sportiness	12	7	823	3	sportiness
spottiness	12	8	576	3	spottiness
stockiness	16	4	524	3	stockiness
stodginess	12	4	389	3	stodginess
stoniness	9	3	834	3	sto_niness
storminess	12	4	521	3	storminess
swampiness	17	7	335	3	swampiness

Search took 7 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	140603	0.436	409841.7
2	DLD Change Limit	140603	75	5.640	24929.6
3	Display Results	75	75	0.030	2500.0
	(SQL Overall)	178691	75	6.106	29264.8