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

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

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.

50 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
potentiometer	17	6	158	(None)
potentiometers	18	6	155	1	potentiometers
potentiometric	20	7	126	3	potentiometric
tensiometer	13	5	387	3	__tensiometer
centimeter	14	4	500	4	__centi_meter
extensometer	21	6	180	4	exten_someter
goniometer	13	4	493	4	go__n_iometer
penetrometer	16	5	299	4	p__enetrometer
pentameter	14	4	520	4	p__ent_ameter
potentiate	12	11	589	4	potenti__ate_
potentiated	14	9	436	4	potenti__ated
potentiates	13	11	486	4	potenti__ates
potentiator	13	5	349	4	potenti__ator
potometer	13	4	984	4	po___t_ometer
tensiometers	14	5	386	4	__tensiometers
actinometer	15	5	421	5	actin__ometer
centimeters	15	4	460	5	__centi_meters
conventioneer	18	15	262	5	conventione_er
densitometer	15	15	288	5	__densitometer
electrometer	16	5	628	5	_electrometer
eudiometer	13	4	416	5	___eudiometer
extensometers	22	6	159	5	exten_someters
goniometers	14	4	485	5	go__n_iometers
hectometer	17	4	641	5	__hect_ometer
heliometer	15	4	630	5	__he_liometer
magnetometer	17	8	267	5	magnet_ometer
monometer	13	4	993	5	mo__n__ometer
optometer	13	4	729	5	_o__pt_ometer
pedometer	14	4	773	5	p__e__dometer
penetrometers	17	5	277	5	p__enetrometers
pentameters	15	4	449	5	p__ent_ameters
perimeter	13	4	956	5	p__e_ri_meter
photometer	17	4	922	5	p__hot_ometer
piezometer	23	4	375	5	p_ie__zometer
planimeter	14	4	380	5	p_lan_i_meter
polarimeter	15	13	320	5	po_lari_meter
potentate	11	9	725	5	potent___ate_
potentates	12	10	633	5	potent___ates
potentialities	16	7	420	5	potentialities
potentiality	17	5	433	5	potentialit_y
potentiators	14	5	322	5	potenti__ators
potometers	14	4	906	5	po___t_ometers
pycnometer	19	4	437	5	p_ycn__ometer
pyrheliometer	23	6	86	5	pyrheliometer
sensitometer	14	15	323	5	__sensitometer
spectrometer	18	5	343	5	_spectrometer
tenderometer	15	5	284	5	__tenderometer
tensiometry	16	5	307	5	__tensiometry
tetrameter	12	5	520	5	__te_trameter
tonometer	11	4	829	5	__ton__ometer

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	124790	0.420	425454.8
2	DLD Change Limit	124790	50	8.593	14522.3
3	Display Results	50	50	0.033	1515.2
	(SQL Overall)	178691	50	9.046	19753.6