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

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

22 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
lambkill	16	4	232	(None)
lambkills	17	4	182	1	lambkills
lambkin	15	4	524	2	lambki_n
lambkins	16	6	498	2	lambkins
cambial	13	40	1076	3	camb_ial
hawkbill	20	4	222	3	hawkbill
labial	8	47	1434	3	la_b_ial
labile	8	3	1522	3	la_b_ile
lambie	10	32	1367	3	lamb_i_e
lambier	11	36	1164	3	lamb_ier
lambies	11	30	1511	3	lamb_ies
lambing	12	34	1241	3	lamb_ing
lamblike	16	3	615	3	lamblike
lambskin	16	5	344	3	lambski_n
lambskins	17	5	324	3	lambskins
landfill	12	5	388	3	landfill
lankily	14	3	712	3	la_nkily
limekiln	14	4	186	3	limekiln
playbill	15	4	337	3	playb_ill
sawbill	12	5	529	3	sawb_ill
waxbill	19	4	313	3	waxb_ill
waybill	15	4	372	3	wayb_ill

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.436	409841.7
2	DLD Change Limit	146162	22	6.656	21959.4
3	Display Results	22	22	0.013	1692.3
	(SQL Overall)	178691	22	7.105	25150.0