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

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

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
bioherms	15	4	421	(None)
bioherm	14	3	465	1	bioherm_
bashers	12	48	2083	3	basher_s
bathers	12	47	2036	3	bather_s
becharms	17	4	534	3	becharms
berms	9	53	2366	3	b___erms
bibbers	10	39	1135	3	bibber_s
bickers	15	43	1655	3	bicker_s
bidders	11	40	1231	3	bidder_s
biders	9	48	2280	3	bi_der_s
biers	7	62	2522	3	bi__er_s
bigheads	15	14	565	3	bigheads
bighorns	14	4	525	3	bighorns
bikers	12	45	1755	3	bi_ker_s
bilkers	13	47	1186	3	bilker_s
billers	9	47	2083	3	biller_s
binders	10	39	2074	3	binder_s
biners	8	50	2363	3	bi_ner_s
bingers	10	45	1999	3	binger_s
biofilms	15	4	277	3	biofilms
biogens	10	3	896	3	bioge_ns
biomes	10	38	1525	3	biome__s
biospheres	17	6	514	3	biospheres
biotechs	15	12	385	3	biotechs
birders	10	39	1326	3	birder_s
birlers	9	38	1300	3	birler_s
bisters	9	39	2261	3	bister_s
biters	8	39	2524	3	bi_ter_s
bitterns	10	42	895	3	bitterns
bitters	9	49	2036	3	bitter_s
blithers	13	47	1123	3	blither_s
blowers	12	43	1359	3	blower_s
boheas	11	40	1321	3	b_ohe_as
boilers	9	34	1706	3	boiler_s
boleros	9	3	1029	3	b_oleros
boners	8	48	2543	3	b_oner_s
boogers	10	45	1463	3	booger_s
bookers	13	40	1661	3	booker_s
boomers	11	41	1591	3	boomer_s
boozers	18	39	1244	3	boozer_s
borers	8	51	2268	3	b_orer_s
bothers	12	43	1775	3	bother_s
bowers	11	55	2370	3	b_ower_s
boxers	15	50	1348	3	b_oxer_s
brokers	13	31	1191	3	broker_s
brothers	13	34	1083	3	brother_s
bushers	12	40	1880	3	busher_s
ciphers	14	37	999	3	cipher_s
citherns	13	33	887	3	citherns
cithers	12	43	1577	3	cither_s
coheres	12	29	1769	3	_coheres
dishelms	14	4	472	3	dishelms
dithers	11	40	1615	3	dither_s
exoderms	18	6	449	3	exoderms
fishers	13	47	1472	3	fisher_s
herms	10	56	2643	3	___herms
inheres	10	3	1517	3	_inheres
isotherms	14	4	408	3	isotherms
midterms	13	28	486	3	midterms
misterms	12	37	1135	3	misterms
mithers	12	35	1673	3	mither_s
pishers	12	38	1575	3	pisher_s
rioters	7	36	1551	3	rioter_s
sighers	11	37	1218	3	sigher_s
therms	11	59	1487	3	__therms
tithers	10	42	1673	3	tither_s
wishers	13	32	1521	3	wisher_s
withers	13	44	1775	3	wither_s
zitherns	20	37	613	3	zitherns
zithers	19	39	1197	3	zither_s

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.153	1167915.0
2	DLD Change Limit	146162	70	7.893	18517.9
3	Display Results	70	70	0.030	2333.3
	(SQL Overall)	178691	70	8.076	22126.2