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

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

81 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
schnozes	22	4	449	(None)
schnozzes	22	4	230	1	schnozzes
schmoes	14	30	854	2	schmo_es
schmoozes	25	21	490	2	schmoozes
schnooks	17	5	424	2	schnooks
schnoz	20	3	565	2	schnoz__
schnozz	20	4	273	2	schnoz_z
schnozzles	23	5	126	2	schnozzles
achiotes	13	3	900	3	achiotes
acnodes	10	3	783	3	ac_nodes
canoes	8	47	2588	3	_cano_es
cenotes	9	28	1454	3	_cenotes
chaoses	12	47	1512	3	_chaoses
chinones	13	5	1047	3	_chinones
chintzes	22	3	597	3	_chintzes
chokes	15	49	1738	3	_ch_okes
chooses	12	57	1742	3	_chooses
chores	11	48	2802	3	_ch_ores
choses	11	58	2513	3	_ch_oses
chromes	14	29	1493	3	_chromes
clozes	17	49	1556	3	_c_lozes
cozes	16	60	3324	3	_c__ozes
crozes	17	44	1766	3	_c_rozes
echoes	11	47	1552	3	ech_o_es
ethnoses	11	4	608	3	ethnoses
ichnites	13	4	574	3	ichnites
scanties	10	32	1542	3	scanties
scenes	8	45	2035	3	scen__es
schappes	17	3	604	3	schappes
schemes	14	8	966	3	sch_emes
scherzos	22	4	370	3	scherzos
schizos	21	11	543	3	sch_izos
schlocks	19	24	569	3	schlocks
schmalzes	25	4	316	3	schmalzes
schmelzes	25	4	267	3	schmelzes
schmoe	13	32	833	3	schmo_e_
schmoos	14	34	751	3	schmo_os
schmoose	15	29	597	3	schmoose
schmooses	16	27	563	3	schmooses
schmooze	24	25	501	3	schmooze_
schmoozed	26	24	413	3	schmoozed
schmoozer	25	22	436	3	schmoozer
schmoozers	26	22	326	3	schmoozers
schmos	13	37	915	3	schmo__s
schnapps	17	5	203	3	schnapps
schnaps	14	4	370	3	schn_aps
schnauzer	23	4	175	3	schnauzer
schnauzers	24	4	135	3	schnauzers
schnitzel	23	5	168	3	schnitzel
schnitzels	24	5	101	3	schnitzels
schnook	16	5	448	3	schno_ok
schnorkel	18	4	219	3	schnorkel
schnorkels	19	5	177	3	schnorkels
schnorrer	14	4	270	3	schnorrer
schnorrers	15	4	257	3	schnorrers
schnozzle	22	5	145	3	schnozzle
schooled	14	4	705	3	schooled
schools	12	4	911	3	sch_ools
schooner	13	3	662	3	schooner
schooners	14	4	566	3	schooners
schorls	12	4	835	3	sch_orls
schrods	13	3	743	3	schro_ds
schusses	13	3	421	3	schusses
sconces	11	38	1145	3	scon_ces
scones	8	45	2130	3	sc__ones
scopes	10	47	1959	3	sc__opes
scores	8	47	2592	3	sc__ores
scrooges	11	3	716	3	scrooges
scuzzes	17	3	440	3	sc_uzzes
senhores	11	28	1099	3	senhores
senores	7	32	1811	3	s_enores
shmoes	11	46	1210	3	s_hmo_es
shmoozes	22	25	488	3	shmoozes
shnooks	14	8	558	3	s_hnooks
shoes	8	54	2966	3	s_h_o_es
shores	9	48	3041	3	s_h_ores
shotes	9	53	2191	3	s_h_otes
shoves	12	49	1942	3	s_h_oves
snoozes	16	28	978	3	s_noozes
snores	6	43	2432	3	s__nores
stenoses	8	3	1044	3	stenoses

Search took 9 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.420	425454.8
2	DLD Change Limit	146162	81	7.593	19249.6
3	Display Results	81	81	0.033	2454.5
	(SQL Overall)	178691	81	8.046	22208.7