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

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

63 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
micropipets	19	5	468	(None)
micropipet	18	5	780	1	micropipet_
micropipette	20	6	297	2	micropipette
micropipettes	21	8	263	2	micropipettes
microliters	15	4	580	3	microliters
micronizes	23	4	900	3	micronize_s
micropores	16	6	1018	3	micropore_s
micropyles	19	4	696	3	micropyle_s
croppers	14	33	1148	4	__crop_pers
croppies	14	31	1113	4	__croppie_s
liripipes	13	4	279	4	li_ripipe_s
macrophytes	23	5	571	4	macrophytes
micrifies	16	11	867	4	micrifi_e_s
microampere	19	5	348	4	microampere
microamperes	20	5	320	4	microamperes
microbes	14	3	940	4	micro__be_s
microbrews	19	5	390	4	micro_brews
microbursts	17	5	379	4	microbursts
microbuses	16	4	620	4	microbuse_s
microchips	21	4	512	4	microchip__s
microclines	17	4	630	4	microcline_s
microcodes	17	4	737	4	microcode_s
microcopies	19	11	785	4	microcopies
microcytes	19	4	842	4	microcyte_s
microdots	14	4	688	4	micro__dots
microfiches	23	5	453	4	microfiches
microfilmers	21	5	298	4	microfilmers
microfilms	19	13	504	4	microfi_lms
microgamete	18	5	534	4	microgamete
microgametes	19	6	479	4	microgametes
microinjects	25	6	269	4	microinjects
microliter	14	4	742	4	microlite_r
microlith	16	4	692	4	microli__th
microliths	17	4	569	4	microli_ths
microluces	16	4	632	4	microluce_s
microluxes	21	4	501	4	microluxe_s
micromeres	16	4	848	4	micromere_s
micrometers	17	4	907	4	micrometers
microminis	16	4	667	4	micromi_nis
micromoles	16	4	842	4	micromole_s
micronize	22	4	890	4	micronize__
micronized	24	4	701	4	micronize_d
microphages	21	5	691	4	microphages
microphones	20	4	876	4	microphones
microphylls	23	5	472	4	microphylls
micropore	15	7	930	4	micropore__
microporous	17	5	614	4	microporous
microprisms	19	5	541	4	microprisms
microprobes	19	5	651	4	microprobes
micropyle	18	4	626	4	micropyle__
microscopes	19	11	909	4	microscope_s
microsomes	16	4	915	4	microsome_s
microspores	17	4	741	4	microspore_s
microstates	15	4	744	4	microstates
microtomes	16	4	905	4	microtome_s
microtones	14	4	980	4	microtone_s
microvillus	18	5	321	4	microvillus
microvolts	17	6	549	4	micro_volts
microwatts	17	5	504	4	micro_watts
microwaves	20	4	536	4	microwave_s
miscopies	15	4	961	4	miscopi_e_s
moppets	13	30	716	4	m___op_pets
wicopies	15	4	598	4	wic_opi_e_s

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.420	425454.8
2	DLD Change Limit	148819	63	9.423	15793.2
3	Display Results	63	63	0.046	1369.6
	(SQL Overall)	178691	63	9.889	18069.7