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

Here are the results of your fuzzy-string dictionary search for “contrabands” with Change Limit: [1] [2] [3] [4] [5]

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.

46 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
contrabands	16	5	298	(None)
contraband	15	5	342	1	contraband_
contrabandist	18	6	217	2	contrabandist
contrabass	14	5	321	2	contraba_ss
contrabandists	19	7	146	3	contraband~~ist~~s
contrabasses	16	5	229	3	contrabasses
contrarians	13	4	635	3	contrarian_s
contravenes	16	5	563	3	contravenes
charabancs	19	5	261	4	c_harabancs
confirmands	19	5	285	4	confirmands
congregants	15	5	315	4	congregants
constrains	12	4	972	4	constra_in_s
constraints	13	4	620	4	constra_ints
contains	10	3	1653	4	cont_a_in_s
contends	11	28	1057	4	cont___ends
contestants	13	5	680	4	contestants
continuants	13	12	532	4	continuants
contrabassist	17	12	182	4	contrabassist
contracted	15	4	982	4	contracted_
contractors	15	4	916	4	contractors
contracts	13	22	1201	4	contr__acts
contradicts	16	5	458	4	contradicts
contrails	11	4	1054	4	contr__ails
contraltos	12	4	676	4	contra_ltos
contrarian	12	4	793	4	contrarian__
contraries	12	7	1193	4	contra_ries
contrariness	14	5	548	4	contrariness
contrarious	13	5	473	4	contrarious
contras	9	30	1562	4	contr__a__s
contrasted	13	4	857	4	contrasted_
contrasts	11	22	1104	4	contr__asts
contravene	15	4	509	4	contraven_e
contravened	17	5	355	4	contravened
contravener	16	5	342	4	contravener
contraveners	17	5	350	4	contraveners
contredanse	14	5	275	4	contredanse
contredanses	15	5	288	4	contredanses
contributes	15	6	534	4	contributes
contrivance	18	5	426	4	contrivance
contrivances	19	5	413	4	contrivances
corbans	11	3	1317	4	co__r_ban_s
corybants	16	4	443	4	co__rybants
countermands	17	4	623	4	countermands
honorands	13	4	502	4	honor__ands
interabangs	14	5	312	4	_interabangs
sarabands	12	4	559	4	__sarabands

Search took 10 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	148819	0.453	394461.4
2	DLD Change Limit	148819	46	8.953	16622.2
3	Display Results	46	46	0.033	1393.9
	(SQL Overall)	178691	46	9.439	18931.1