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

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

65 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
shmooze	21	25	526	(None)
schmooze	24	25	501	1	schmooze
shmoozed	23	25	436	1	shmoozed
shmoozes	22	25	488	1	shmoozes
schmoose	15	29	597	2	schmoose
schmoozed	26	24	413	2	schmoozed
schmoozer	25	22	436	2	schmoozer
schmoozes	25	21	490	2	schmoozes
schmoozy	27	26	286	2	schmoozy
snooze	15	43	999	2	s_nooze
booze	16	47	1891	3	__booze
choose	11	51	1614	3	ch_oose
moose	7	63	2719	3	__moose
ooze	13	64	2060	3	___ooze
schmelze	24	4	315	3	schmelze
schmoe	13	32	833	3	schm_o_e
schmoos	14	34	751	3	schmoo_s
schmoosed	17	29	430	3	schmoosed
schmooses	16	27	563	3	schmooses
schmoozers	26	22	326	3	schmoozers
schmoozier	26	26	228	3	schmoozier
scrooge	10	3	718	3	scrooge
shmo	9	53	1810	3	shm_o__
shmoes	11	46	1210	3	shm_oes
shmoozing	24	4	361	3	shmoozing
shnook	13	6	634	3	shnoo_k
shnooks	14	8	558	3	shnooks
shoe	7	59	3344	3	sh__o_e
shone	8	37	2598	3	sh__one
shoo	7	59	2989	3	sh_oo__
shooed	10	39	1608	3	sh_ooed
shook	12	49	2016	3	sh_oo_k
shooks	13	45	1563	3	sh_ooks
shool	8	45	2315	3	sh_oo_l
shooled	11	52	1266	3	sh_ooled
shools	9	49	1901	3	sh_ools
shoon	8	40	2201	3	sh_oo_n
shoos	8	42	2636	3	sh_oo_s
shoot	8	42	3591	3	sh_oo_t
shooter	10	30	1399	3	sh_ooter
shoots	9	46	1936	3	sh_oots
shoppe	13	31	1032	3	sh_oppe
shore	8	54	3265	3	sh__ore
shote	8	55	2610	3	sh__ote
shove	11	44	2104	3	sh__ove
shrove	12	54	1223	3	sh_rove
simonize	19	4	781	3	simonize
simoom	10	3	750	3	simoo_m
simooms	11	3	557	3	simooms
simoon	8	5	806	3	simoo_n
simoons	9	3	794	3	simoons
smaze	16	50	1293	3	s_m_aze
smoke	11	50	1582	3	s_m_oke
smooch	13	26	680	3	s_mooch
smoosh	11	23	673	3	s_moosh
smooth	11	25	920	3	s_mooth
smote	7	58	2028	3	s_m_ote
snoozed	17	34	1013	3	s_noozed
snoozer	16	40	919	3	s_noozer
snoozes	16	28	978	3	s_noozes
snoozle	16	30	591	3	s_noozle
snoozy	18	51	723	3	s_noozy
someone	9	3	881	3	someone
stooge	7	38	1166	3	s_tooge
vamoose	12	3	586	3	vamoose

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	134027	0.406	440125.6
2	DLD Change Limit	134027	65	6.593	20328.7
3	Display Results	65	65	0.016	4062.5
	(SQL Overall)	178691	65	7.015	25472.7