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

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

52 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
shmoes	11	46	1210	(None)
schmoes	14	30	854	1	schmoes
shoes	8	54	2966	1	sh_oes
hoes	7	57	5573	2	_h_oes
homes	10	69	3881	2	_homes
schmoe	13	32	833	2	schmoe_
schmoos	14	34	751	2	schmoos
schmos	13	37	915	2	schmo_s
semes	7	57	3158	2	sem_es
shades	10	59	2453	2	shades
shakes	13	50	2459	2	shakes
shakoes	14	45	1002	2	shakoes
shales	9	47	3125	2	shales
shames	11	47	2622	2	shames
shammes	14	43	1283	2	shammes
shamois	12	32	1042	2	shamois
shamos	11	42	1698	2	shamo_s
shamoys	15	36	728	2	shamoys
shapes	11	51	2494	2	shapes
shares	9	52	3641	2	shares
shaves	12	52	2493	2	shaves
sheols	9	46	1416	2	sheols
shes	7	57	3435	2	sh__es
shies	8	61	3655	2	sh_ies
shines	9	50	2891	2	shines
shires	9	52	2557	2	shires
shives	12	49	2141	2	shives
shmo	9	53	1810	2	shmo__
shmoozes	22	25	488	2	shmoozes
shoe	7	59	3344	2	sh_oe_
shoed	9	57	2301	2	sh_oed
shoer	8	47	2216	2	sh_oer
shoers	9	45	1833	2	sh_oers
shogs	9	53	1971	2	sh_ogs
shooed	10	39	1608	2	shooed
shooks	13	45	1563	2	shooks
shools	9	49	1901	2	shools
shoos	8	42	2636	2	sh_oos
shoots	9	46	1936	2	shoots
shops	10	42	2290	2	sh_ops
shores	9	48	3041	2	shores
shotes	9	53	2191	2	shotes
shots	8	47	3085	2	sh_ots
shoves	12	49	1942	2	shoves
shows	11	53	2458	2	sh_ows
shutes	9	35	1822	2	shutes
sloes	5	47	2887	2	s_loes
smogs	8	51	1216	2	s_mogs
smokes	12	48	1434	2	s_mokes
sumos	7	57	2009	2	sumo_s
syboes	11	3	934	2	syboes
throes	9	75	1867	2	throes

Search took 3 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.343	520965.0
2	DLD Change Limit	82551	52	2.376	34743.7
3	Display Results	52	52	0.013	4000.0
	(SQL Overall)	178691	52	2.732	65406.7