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

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

88 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
schmears	15	8	410	(None)
schmear	14	8	404	1	schmear_
schmeers	15	7	483	1	schmeers
shmears	12	7	707	1	s_hmears
schemas	14	6	816	2	schema_s
schemers	15	7	671	2	schemers
schmeared	17	4	305	2	schmeared
schmeer	14	7	536	2	schmeer_
scholars	13	3	668	2	scholars
scimetars	13	4	401	2	scimetars
shears	9	38	2090	2	s_h_ears
shmear	11	7	693	2	s_hmear_
smears	8	47	1443	2	s__mears
besmears	12	3	454	3	besmears
cameras	11	3	1336	3	_cameras
chadars	13	3	829	3	_chadars
chars	10	59	3664	3	_ch__ars
cheaps	13	46	1368	3	_ch_eaps
cheats	11	45	1954	3	_ch_eats
cheers	11	45	1891	3	_ch_eers
chimars	14	40	1059	3	_chimars
chimeras	15	38	883	3	_chimeras
chimers	14	45	1514	3	_chime_rs
chukars	16	3	428	3	_chukars
clears	8	41	1656	3	_c_lears
comers	10	53	2808	3	_come_rs
cymars	13	59	915	3	_cym_ars
echoers	12	45	969	3	echoe_rs
eschars	12	3	718	3	esch__ars
escheats	13	4	625	3	esch_eats
hears	8	67	3737	3	__h_ears
ochers	11	39	1530	3	och_e_rs
rehears	10	33	1277	3	reh_ears
sambars	11	51	1384	3	s_ambars
scalars	9	37	1190	3	sc_alars
scalers	9	38	1726	3	scale_rs
scammers	14	33	977	3	scammers
scampers	14	36	1103	3	scampers
scarers	9	46	1851	3	scare_rs
scars	7	54	3353	3	sc___ars
schavs	14	3	649	3	sch__avs
schema	13	8	837	3	schema__
schemata	15	4	500	3	schemata
schemer	14	7	796	3	schemer_
schemes	14	8	966	3	sch_emes
schlepps	17	6	256	3	schlepps
schleps	14	4	548	3	schle_ps
schmalz	23	4	529	3	schm_alz
schmearing	18	4	286	3	schmearing
schmeered	17	4	327	3	schmeered
schmelze	24	4	315	3	schmelze
schmelzes	25	4	267	3	schmelzes
schmoes	14	30	854	3	schm_oes
schmoos	14	34	751	3	schm_oos
schmos	13	37	915	3	schm__os
schmucks	21	4	276	3	schmucks
schnaps	14	4	370	3	sch_naps
scholar	12	3	695	3	scholar_
schwas	14	39	698	3	sch_wa_s
scimetar	12	4	404	3	scimetar_
scimitars	13	4	317	3	scimitars
scleras	9	4	822	3	sc_leras
scorers	9	41	1532	3	score_rs
scoters	9	33	1381	3	scote_rs
screaks	13	46	936	3	sc_reaks
screams	11	48	1062	3	sc_reams
scumbags	15	4	320	3	scumbags
scummers	14	27	778	3	scummers
seamers	9	47	1943	3	seame_rs
sears	5	47	4491	3	s___ears
seemers	9	38	1433	3	seeme_rs
sheafs	12	49	1288	3	s_h_eafs
sheals	9	44	2064	3	s_h_eals
shear	8	54	2483	3	s_h_ear_
sheas	8	63	3179	3	s_h_ea_s
sheers	9	43	2240	3	s_h_eers
shiers	9	49	2175	3	s_hie_rs
shikars	14	3	618	3	s_hikars
shoers	9	45	1833	3	s_hoe_rs
shofars	13	3	583	3	s_hofars
shyers	12	47	1220	3	s_hye_rs
simars	8	49	1693	3	s_im_ars
simmers	11	33	1461	3	simme_rs
smear	7	44	1639	3	s__mear_
smeary	11	41	1080	3	s__meary
spears	8	40	1947	3	s__pears
summers	11	36	1650	3	summe_rs
swears	9	41	1407	3	s__wears

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.423	422437.4
2	DLD Change Limit	146162	88	6.233	23449.7
3	Display Results	88	88	0.033	2666.7
	(SQL Overall)	178691	88	6.689	26714.2