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

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

85 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
shmoozed	23	25	436	(None)
schmoozed	26	24	413	1	schmoozed
shmooze	21	25	526	1	shmooze_
shmoozes	22	25	488	1	shmoozes
schmoosed	17	29	430	2	schmoosed
schmooze	24	25	501	2	schmooze_
schmoozer	25	22	436	2	schmoozer
schmoozes	25	21	490	2	schmoozes
shooed	10	39	1608	2	sh_oo_ed
shooled	11	52	1266	2	sh_ooled
snoozed	17	34	1013	2	s_noozed
boozed	18	48	1383	3	__boozed
hooded	11	46	1674	3	_h_ooded
hoofed	13	46	1489	3	_h_oofed
hooked	14	53	2055	3	_h_ooked
hooped	12	55	1818	3	_h_ooped
hooted	10	44	2266	3	_h_ooted
hooved	13	47	1312	3	_h_ooved
mooed	8	51	2398	3	__moo_ed
mooned	9	42	1664	3	__mooned
moored	9	38	1417	3	__moored
mooted	9	41	2037	3	__mooted
oozed	15	42	1426	3	___oozed
samoyed	13	3	589	3	sam_oyed
schmoose	15	29	597	3	schmoose_
schmooses	16	27	563	3	schmooses
schmoozers	26	22	326	3	schmoozers
schmoozier	26	26	228	3	schmoozier
schmoozy	27	26	286	3	schmooz_y
schooled	14	4	705	3	schooled
scooped	12	46	1175	3	s_cooped
scooted	10	36	1228	3	s_cooted
scrooped	13	5	641	3	scrooped
shadowed	16	4	448	3	shadowed
shamoyed	17	4	404	3	shamoyed
shampooed	17	4	294	3	shampooed
shmoes	11	46	1210	3	shm_o_es
shmoozing	24	4	361	3	shmoozing
shoaled	11	38	1097	3	sh_oaled
shocked	17	46	1181	3	sh_ocked
shoed	9	57	2301	3	sh__o_ed
shogged	13	39	796	3	sh_ogged
shooter	10	30	1399	3	sh_ooter
shopped	15	35	1221	3	sh_opped
shored	10	57	2365	3	sh__ored
shorted	11	36	1440	3	sh_orted
shotted	11	39	1240	3	sh_otted
shouted	11	39	1155	3	sh_outed
shoved	13	42	1428	3	sh__oved
showed	13	50	1697	3	sh__owed
shroffed	18	4	256	3	shroffed
shrouded	13	3	360	3	shrouded
simonized	21	4	652	3	simonized
smocked	16	39	822	3	s_mocked
smoked	13	43	1172	3	s_m_oked
smooched	16	18	598	3	s_mooched
smooshed	14	18	599	3	s_mooshed
smoothed	14	23	647	3	s_moothed
snooded	9	41	1036	3	s_nooded
snooked	12	37	1149	3	s_nooked
snooled	8	45	1394	3	s_nooled
snooped	10	37	1181	3	s_nooped
snooted	8	42	1328	3	s_nooted
snooze	15	43	999	3	s_nooze_
snoozer	16	40	919	3	s_noozer
snoozes	16	28	978	3	s_noozes
snoozled	18	34	449	3	s_noozled
sooted	7	39	2259	3	s__ooted
spoofed	13	39	910	3	s_poofed
spooked	14	45	1047	3	s_pooked
spooled	10	46	1352	3	s_pooled
spooned	10	34	1244	3	s_pooned
spoored	10	44	1129	3	s_poored
stooged	9	43	1073	3	s_tooged
stooked	12	43	1230	3	s_tooked
stooled	8	43	1389	3	s_tooled
stooped	10	38	1383	3	s_tooped
summoned	13	4	572	3	summoned
swooned	11	36	859	3	s_wooned
swooped	13	41	875	3	s_wooped
symboled	16	4	449	3	symboled
unmoored	11	3	733	3	unmoored
vamoosed	14	4	392	3	vamoosed
whoofed	17	37	451	3	wh_oofed
whooped	16	32	693	3	wh_ooped

Search took 7 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.406	440125.6
2	DLD Change Limit	146162	85	6.280	23274.2
3	Display Results	85	85	0.046	1847.8
	(SQL Overall)	178691	85	6.732	26543.5