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

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

70 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
innkeepers	16	5	173	(None)
innkeeper	15	5	168	1	innkeeper_
barkeepers	18	4	289	3	barkeepers
beekeepers	18	5	235	3	beekeepers
inbreeders	13	4	233	3	inbreeders
keepers	13	34	1098	3	___keepers
timekeepers	19	5	191	3	timekeepers
zookeepers	25	5	219	3	zookeepers
annealers	9	4	456	4	ann_ealers
barkeeper	17	4	293	4	barkeeper_
beekeeper	17	4	224	4	beekeeper_
beepers	11	36	1238	4	___beepers
bleepers	12	37	749	4	__bleepers
bookkeepers	18	5	182	4	bookkeepers
cheepers	15	32	901	4	__cheepers
creepers	12	31	863	4	__creepers
crowkeepers	22	5	181	4	crowkeepers
doorkeepers	18	6	181	4	doorkeepers
gamekeepers	20	5	194	4	gamekeepers
gatekeepers	18	5	195	4	gatekeepers
goalkeepers	18	12	170	4	goalkeepers
greenkeepers	19	6	171	4	greenkeepers
hankerers	16	22	671	4	hank_erers
inbreeder	12	4	274	4	inbreeder_
incenters	11	25	1030	4	i_ncenters
increasers	12	4	331	4	increasers
indenters	10	27	1003	4	i_ndenters
indexers	16	32	637	4	i_n_dexers
indwellers	14	7	235	4	indwellers
inexpert	17	4	608	4	i_n_expert
inexperts	18	4	297	4	i_n_experts
infecters	14	25	758	4	i_nfecters
inferrers	12	22	658	4	i_nferrers
infesters	12	23	771	4	i_nfesters
infielders	14	4	262	4	infielders
inkers	10	40	1883	4	i_nk___ers
innateness	10	4	689	4	innateness
innerness	9	4	691	4	inn_erness
inners	6	39	1935	4	inn____ers
innerves	11	5	801	4	inn_erve_s
inserters	9	22	1028	4	i_nserters
insetters	9	18	713	4	i_nsetters
integers	9	3	778	4	i_n_tegers
intenders	10	21	937	4	i_ntenders
inventers	12	26	953	4	i_nventers
inverters	12	23	975	4	i_nverters
jeepers	16	39	919	4	___jeepers
junketeers	21	5	174	4	junketeers
junketers	20	4	293	4	junk_eters
keeners	11	36	1078	4	___keeners
keeper	12	38	1192	4	___keeper_
kneelers	12	22	621	4	_kn_eelers
lockkeepers	18	5	173	4	lockkeepers
minesweepers	19	9	112	4	minesweepers
needers	8	41	1190	4	__n_eeders
peepers	11	37	1367	4	___peepers
shopkeepers	22	5	178	4	shopkeepers
skeeters	12	29	896	4	__skeeters
sleepers	10	31	1011	4	__sleepers
sneerers	8	30	980	4	_sn_eerers
sneezers	17	24	614	4	_sn_eezers
steepers	10	30	1137	4	__steepers
sunseekers	14	4	221	4	sunseekers
sweepers	13	34	816	4	__sweepers
timekeeper	18	5	192	4	timekeeper_
tinkerers	13	9	542	4	tink_erers
unreelers	9	15	474	4	_unreelers
veneerers	12	4	452	4	ven_eerers
weepers	12	35	1197	4	___weepers
zookeeper	24	5	230	4	zookeeper_

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	161450	0.436	409841.7
2	DLD Change Limit	161450	70	9.050	17839.8
3	Display Results	70	70	0.046	1521.7
	(SQL Overall)	178691	70	9.532	18746.4