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

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

47 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
hostly	12	42	1086	(None)
costly	11	40	1233	1	costly
ghostly	14	35	510	1	ghostly
hotly	11	58	1548	1	ho_tly
mostly	11	31	1094	1	mostly
cosily	11	36	1385	2	cosily
ghastly	14	35	456	2	ghastly
ghosty	13	46	721	2	ghost_y
hastily	13	30	1066	2	hastily
hasty	11	57	1876	2	hast_y
hokily	16	40	909	2	hokily
holily	12	36	1295	2	holily
holly	11	48	2443	2	ho_lly
holy	10	63	3343	2	ho__ly
homely	14	53	1318	2	homely
homily	14	47	1233	2	homily
honestly	14	35	593	2	honestly
hooly	11	50	2222	2	ho_oly
hooty	11	50	2244	2	hoot_y
horsily	13	3	884	2	horsily
hosel	8	60	2482	2	hosel_
hosels	9	42	1861	2	hosels
hosey	11	61	2702	2	hos_ey
host	7	78	5283	2	host__
hosta	8	59	1783	2	host_a
hostas	9	45	1583	2	hostas
hosted	10	50	2034	2	hosted
hostel	9	39	1415	2	hostel
hostelry	14	4	391	2	hostelry
hostels	10	37	1232	2	hostels
hostile	10	3	1255	2	hostile
hostler	10	34	1102	2	hostler
hosts	8	55	2670	2	host_s
hourly	12	36	962	2	hourly
hustle	9	31	1399	2	hustle
jostle	13	31	986	2	jostle
justly	16	30	725	2	justly
lastly	9	33	1087	2	lastly
moistly	12	3	661	2	moistly
nosily	9	37	1268	2	nosily
portly	11	47	1340	2	portly
poshly	14	3	772	2	poshly
rosily	9	39	1471	2	rosily
shortly	13	38	757	2	shortly
softly	12	45	776	2	softly
thistly	13	9	596	2	thistly
vastly	12	50	872	2	vastly

Search took 6 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	82551	0.750	238254.7
2	DLD Change Limit	82551	47	5.080	16250.2
3	Display Results	47	47	0.016	2937.5
	(SQL Overall)	178691	47	5.846	30566.4