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

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

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.

69 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
happier	14	33	1204	(None)
gappier	12	36	984	1	gappier
hippier	14	32	1210	1	hippier
hoppier	14	31	1070	1	hoppier
nappier	11	44	1117	1	nappier
pappier	10	35	1160	1	pappier
sappier	11	36	1312	1	sappier
zappier	20	45	837	1	zappier
applier	11	3	790	2	_applier
campier	13	33	1327	2	campier
capper	12	44	2198	2	capp_er
chappie	16	29	866	2	chappie_
chappies	17	26	1010	2	chappies
chippier	17	29	767	2	chippier
choppier	17	28	665	2	choppier
crappier	14	28	814	2	crappier
cuppier	13	6	832	2	cuppier
dapper	11	40	1663	2	dapp_er
dippier	12	31	1139	2	dippier
flappier	15	4	430	2	flappier
hairier	10	31	1105	2	hairier
hammier	14	35	1065	2	hammier
hamper	13	45	1865	2	hamp_er
handier	11	38	1744	2	handier
happed	14	48	2010	2	happ_ed
happen	13	48	1219	2	happ_en
happiest	15	24	1168	2	happiest
happily	17	4	576	2	happily
happing	15	38	1723	2	happing
hardier	11	47	2154	2	hardier
harper	11	50	1840	2	harp_er
harpies	12	38	1832	2	harpies
harrier	10	44	1776	2	harrier
hastier	10	39	1662	2	hastier
haulier	10	5	994	2	haulier
hazier	18	47	1240	2	ha_zier
hempier	14	31	900	2	hempier
hepper	13	34	1266	2	hepp_er
hipper	13	38	1802	2	hipp_er
hippie	13	28	1124	2	hippie_
hippies	14	28	1375	2	hippies
hopper	13	42	1848	2	hopp_er
humpier	14	31	1072	2	humpier
lapper	10	43	1995	2	lapp_er
lippier	11	27	1057	2	lippier
loppier	11	36	972	2	loppier
mapper	12	45	1609	2	mapp_er
napper	10	37	1828	2	napp_er
nappie	10	41	1226	2	nappie_
nappies	11	46	1340	2	nappies
nippier	11	31	983	2	nippier
pappies	10	32	1483	2	pappies
peppier	10	26	832	2	peppier
rapier	8	40	1999	2	ra_pier
rapper	10	46	2157	2	rapp_er
raspier	9	31	1064	2	raspier
sapper	10	38	2235	2	sapp_er
snappier	12	6	622	2	snappier
soppier	11	27	1158	2	soppier
tapper	10	44	1961	2	tapp_er
tippier	11	32	1054	2	tippier
unhappier	16	4	240	2	unhappier
vampier	14	30	823	2	vampier
waspier	12	25	905	2	waspier
whapper	17	34	827	2	whapp_er
whippier	18	26	582	2	whippier
yapper	13	37	1451	2	yapp_er
zapper	19	34	1402	2	zapp_er
zippier	20	30	819	2	zippier

Search took 5 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	107671	0.500	357382.0
2	DLD Change Limit	107671	69	3.623	29718.7
3	Display Results	69	69	0.030	2300.0
	(SQL Overall)	178691	69	4.153	43027.0