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

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

72 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
handsome	14	4	760	(None)
handsomer	15	4	545	1	handsomer
handsomely	19	5	263	2	handsomely
handsomest	16	5	426	2	handsomest
hansom	11	21	915	2	han_som_
hansoms	12	23	852	2	han_soms
unhandsome	16	5	142	2	unhandsome
anisole	7	10	1083	3	_anisole
awesome	12	4	557	3	_awesome
bandore	10	6	1163	3	band_ore
bandsmen	13	5	645	3	bands_men
darksome	15	4	404	3	darksome
endosome	11	4	680	3	_endosome
fandom	12	21	1089	3	fand_om_
fandoms	13	22	947	3	fand_oms
gamesome	13	4	522	3	gamesome
gladsome	12	4	425	3	gladsome
halidome	14	11	531	3	halidome
handbook	18	4	473	3	handbook
handhold	16	4	563	3	handhold
handle	10	42	1929	3	hand__le
handlike	16	3	915	3	handlike
handloom	14	4	461	3	handloom
handlooms	15	4	383	3	handlooms
handmade	15	4	596	3	handmade
handoff	17	5	648	3	hand_off
handout	11	3	1410	3	hand_out
handover	15	12	682	3	hand_over
hands	9	53	2738	3	hands___
handsaw	14	3	553	3	hands_aw
handsaws	15	4	587	3	handsaws
handsel	11	30	872	3	hands_el
handseled	14	4	440	3	handseled
handsels	12	31	724	3	handsels
handset	11	30	1682	3	hands_et
handsets	12	25	834	3	handsets
handsewn	15	4	362	3	handsewn
handsful	15	4	408	3	handsful
handshake	20	4	371	3	handshake
handspike	19	6	322	3	handspike
handstamp	17	5	287	3	handstamp
handwork	19	4	690	3	handwork
handwoven	19	4	321	3	handwoven
handwrote	16	4	412	3	handwrote
handymen	17	4	498	3	hand_ymen
hanse	8	57	2279	3	han_s__e
hardcore	14	4	605	3	hardcore
hardnose	12	4	572	3	hardnose
heartsome	14	4	400	3	heartsome
landside	10	14	744	3	landside
landsmen	11	5	660	3	lands_men
larksome	14	4	459	3	larksome
lonesome	10	4	747	3	lonesome
longsome	11	4	593	3	longsome
monosome	12	9	940	3	monosome
pandore	10	4	1185	3	pand_ore
phagosome	17	5	364	3	phagosome
radome	9	5	1187	3	ra_d_ome
random	9	25	1355	3	rand_om_
randoms	10	21	1243	3	rand_oms
ransom	8	24	1094	3	ran_som_
ransomed	11	4	693	3	ran_somed
ransomer	10	4	788	3	ran_somer
ransoms	9	24	1016	3	ran_soms
rhabdome	16	4	329	3	rhabd_ome
sandshoe	12	4	507	3	sandshoe
sandsoap	11	4	372	3	sandsoap
sandstone	10	4	564	3	sandstone
syndrome	14	4	429	3	syndrome
wagsome	13	4	521	3	wa_gsome
wailsome	13	4	449	3	wailsome
winsome	12	3	746	3	win_some

Search took 8 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	146162	0.453	394461.4
2	DLD Change Limit	146162	72	7.153	20433.7
3	Display Results	72	72	0.033	2181.8
	(SQL Overall)	178691	72	7.639	23391.9