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

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

(Found more than 100 similar words, so Change Limit cannot be increased.)
Check this box to automatically search another random word after seconds.

137 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
ceilometers	15	4	551	(None)
ceilometer	14	4	543	1	ceilometer_
clinometers	15	4	472	2	clinometers
coulometers	15	4	511	2	coulometers
cyclometers	20	4	518	2	cyclometers
heliometers	16	4	602	2	heliometers
kilometers	16	8	665	2	_kilometers
actinometers	16	5	391	3	actinometers
aerometers	12	4	949	3	ae_rometers
biometers	13	3	917	3	_bi_ometers
bolometers	14	4	738	3	_bolometers
centimeters	15	4	461	3	centimeters
clinometer	14	4	453	3	clinometer_
coulometer	14	4	544	3	coulometer_
cryometers	17	4	600	3	c_ryometers
cyclometer	19	4	541	3	cyclometer_
ergometers	13	4	578	3	_ergometers
geometers	12	3	819	3	ge__ometers
hectometers	18	4	606	3	hectometers
heliometer	15	4	630	3	heliometer_
kilometer	15	7	693	3	_kilometer_
kilometres	16	11	578	3	_kilometres
pedometers	15	4	721	3	pe_dometers
picometers	16	4	828	3	_picometers
piezometers	24	4	383	3	piezometers
salometers	12	5	807	3	_salometers
seismometers	16	6	300	3	seismometers
spirometers	15	4	580	3	spirometers
telemeters	12	4	668	3	te_lemeters
tiltmeters	12	4	412	3	_tiltmeters
urinometers	13	4	470	3	urinometers
acidimeters	16	5	250	4	acidimeters
actinometer	15	5	421	4	actinometer_
aerometer	11	4	1020	4	ae_rometer_
algometers	13	4	600	4	_algometers
anemometers	15	4	465	4	anemometers
atmometers	14	4	588	4	_atmometers
audiometers	14	4	450	4	audiometers
barometers	14	19	852	4	_barometers
billeters	11	3	687	4	_bil_leters
biometer	12	3	960	4	_bi_ometer_
bolometer	13	4	821	4	_bolometer_
calorimeters	16	5	263	4	c_alorimeters
ceilers	9	39	1253	4	ceil____ers
cellmates	13	4	751	4	ce_llmate_s
celotexes	18	4	361	4	ce_lotexe_s
cementers	13	3	831	4	ce___menters
cemetery	15	5	492	4	ce___metery
centimeter	14	4	500	4	centimeter_
chiropters	17	4	476	4	chiro_pters
chronometers	19	5	403	4	chronometers
cloisters	11	3	744	4	c__loisters
clouters	10	39	980	4	c__lo_uters
coelomates	14	9	757	4	coelomate_s
colorimeters	16	5	316	4	c_olorimeters
comethers	16	3	744	4	c___omethers
copromoters	17	5	399	4	copromoters
coulometry	17	5	376	4	coulomet_ry
coveters	13	24	1108	4	c___oveters
cricketers	18	4	390	4	cri_cketers
cryometer	16	4	643	4	c_ryometer_
decameters	15	15	659	4	de_cameters
decimeters	15	15	668	4	de_cimeters
deflowerers	18	5	162	4	deflowerers
dekameters	17	16	486	4	de_kameters
delimiters	13	4	510	4	de_limiters
densitometers	16	14	284	4	densitometers
depleters	12	32	754	4	depl__eters
diameters	12	4	760	4	_di_ameters
dilatometers	15	5	311	4	_dilatometers
dimeters	11	4	1109	4	_di__meters
durometers	13	5	637	4	_durometers
ergometer	12	4	615	4	_ergometer_
eudiometers	14	4	414	4	eudiometers
flowmeters	18	4	323	4	__flowmeters
gasometers	13	4	665	4	_gasometers
geometer	11	3	842	4	ge__ometer_
goniometers	14	4	485	4	goniometers
hectometer	17	4	641	4	hectometer_
heptameters	18	5	327	4	heptameters
hexameters	22	4	445	4	he_xameters
hydrometers	20	9	594	4	hydrometers
hygrometers	20	8	445	4	hygrometers
hypsometers	21	5	377	4	hypsometers
inclinometers	17	6	145	4	inclinometers
kiloliters	14	4	293	4	_kiloliters
kilometre	15	13	520	4	_kilomet_re
manometers	14	4	802	4	_manometers
micrometers	17	4	907	4	micrometers
millimeters	15	4	415	4	millimeters
monometers	14	4	936	4	_monometers
nanometers	12	4	712	4	_nanometers
nephelometers	20	7	241	4	nephelometers
odometers	12	4	713	4	__odometers
optometers	14	5	674	4	_optometers
orometers	11	3	1042	4	__orometers
osmometers	14	4	492	4	_osmometers
oximeters	18	5	514	4	oxi__meters
pedometer	14	4	773	4	pe_dometer_
pentameters	15	4	449	4	pentameters
perimeters	14	4	860	4	pe_rimeters
photometers	18	4	844	4	photometers
picometer	15	4	891	4	_picometer_
picometres	16	4	722	4	_picometres
piezometer	23	4	375	4	piezometer_
potometers	14	4	906	4	_potometers
pycnometers	20	4	445	4	pycnometers
pyrometers	17	4	833	4	_pyrometers
radiometers	14	6	618	4	radiometers
respirometers	17	7	211	4	respirometers
rheometers	15	4	575	4	_rheometers
salimeters	12	5	652	4	_salimeters
salinometers	14	5	352	4	salinometers
salometer	11	8	869	4	_salometer_
sclerometers	16	5	403	4	sclerometers
seismometer	15	6	307	4	seismometer_
sensitometers	15	13	307	4	sensitometers
speedometers	17	5	277	4	speedometers
spirometer	14	4	576	4	spirometer_
tachometers	18	5	507	4	tachometers
telemeter	11	4	728	4	te_lemeter_
tellurometers	15	10	187	4	tellurometers
telomeres	11	4	636	4	te_lomere_s
tensiometers	14	5	386	4	tensiometers
tetrameters	13	5	462	4	tetrameters
thermometers	19	6	491	4	thermometers
tiltmeter	11	4	434	4	_tiltmeter_
tonometers	12	4	811	4	_tonometers
trimeters	11	3	921	4	tri__meters
udometers	12	4	574	4	__udometers
urinometer	12	4	478	4	urinometer_
variometers	16	4	516	4	variometers
velocimeters	19	5	186	4	ve_locimeters
viscometers	18	5	494	4	viscometers
voltmeters	15	5	428	4	_voltmeters
volumeters	15	4	399	4	_volumeters
zymometers	26	198	693	4	_zymometers

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.436	409841.7
2	DLD Change Limit	148819	137	8.580	17344.9
3	Display Results	137	137	0.080	1712.5
	(SQL Overall)	178691	137	9.096	19645.0