Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

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

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

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

117 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 WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
spectrometers195307(None) 
spectrometer1853431spectrometer_
electrometers1765802electrometers
spectrometry2162362spectromet_ry
electrometer1656273electrometer_
hectometers1846063_hect_ometers
penetrometers1752773_penetrometers
psychrometers2563233psychrometers
spectrometric21103053spectrometric
spectrometries2062823spectrometries
speedometers1752773spe_edometers
spherometers1954003sp_herometers
spirometers1545803sp__irometers
aerometers1249484_ae__rometers
hectometer1746414_hect_ometer_
micrometers1749074_mic_rometers
optometers1456744op__t_ometers
pedometers1547214_pe__dometers
penetrometer1652994_penetrometer_
pentameters1544494_pent_ameters
perimeters1448594_pe__rimeters
photometers1848444_phot_ometers
picometers1648284_pic__ometers
potometers1449064_p_ot_ometers
psychrometer2453774psychrometer_
pycnometers2044454_pyc_nometers
pyrometers1748334_p__yrometers
saccharometers2381784saccharometers
sclerometers1654034s_clerometers
seismometers1663004s_eismometers
speedometer1653064spe_edometer_
spherometer1854154sp_herometer_
spirometer1445764sp__irometer_
tetrameters1354624_te_trameters
accelerometers2081265accelerometers
actinometers1653915__actinometers
aerometer11410205_ae__rometer_
anemometers1544655ane__mometers
atmometers1445875___atmometers
barometers14198515___barometers
ceilometers1545515_ce_ilometers
centimeters1544605_cent_imeters
centromeres1553885_centromere_s
cryometers1746005___cryometers
cyclometers2045185_cyc_lometers
decameters15156595_dec__ameters
decimeters15156685_dec__imeters
dilatometers1553115dilat_ometers
durometers1356375___durometers
ectomeres1346255__ect_omere_s
electioneers1453695electione_ers
electrocutes1655305electrocute_s
electrojets2055255electrojet__s
electrolytes1755935electrolyte_s
electrotypers2063635electrotypers
ergometers1345785__e_rgometers
eudiometers1444145__eudiometers
fluorometers17113025_fluorometers
geometers1238195_ge___ometers
hectoliters1652135_hect_oliters
heliometers1646025_he_liometers
heptameters1853275_hept_ameters
hydrometers2095945__hydrometers
hygrometers2084455__hygrometers
hypermeters2155585hype__r_meters
micrometer16410145_mic_rometer_
nephelometers2072415nephelometers
octameters1444835__oct_ameters
olfactometers20142015olfact_ometers
optometer1347295op__t_ometer_
orometers11310425____orometers
parameters1448125_p__arameters
pedometer1447735_pe__dometer_
pentameter1445205_pent_ameter_
perimeter1349555_pe__rimeter_
photometer1749225_phot_ometer_
picometer1548915_pic__ometer_
picometres1647225_pic__ometres
piezometers2443835_p_iezometers
polarimeters16132665_polarimeters
potentiometers1861555potentiometers
potometer1349845_p_ot_ometer_
promoters13310095_p___romoters
prompters1537555_p___rompters
psychrometry2762935psychromet_ry
pycnometer1944375_pyc_nometer_
pyrometer1648885_p__yrometer_
reflectometers21142865reflect_ometers
respirometers1772115respirometers
rheometers1545755rhe___ometers
saccharimeters2391535saccharimeters
saccharometer2292005saccharometer_
salinometers1453525s_alinometers
salometers1258075s___alometers
sclerometer1554225s_clerometer_
secreter1038505s_ec_r__eter_
secretes10410475s_ec_r__ete_s
secretors1145835s_ec_r__etors
seismometer1563075s_eismometer_
sensitometers15133075sensitometers
spectates13228815spect___ate_s
spectators1444535spect___ators
specters122811065spec_____ters
spectres12268685spectr____e_s
spectrograms1952635spectro_grams
spectrographs23113385spectrographs
spectroscopes2163385spectroscopes
spectrums1543175spectrum____s
spirometry1753965sp__iromet_ry
tachometers1855075_tac_hometers
tellurometers15101875tellurometers
tenderometers1652715tenderometers
tensiometers1453865_tensiometers
tetrameter1255205_te_trameter_
thermometers1964915the_rmometers
trimeters1139215____trimeters
viscometers1854945visc__ometers

Search took 10 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911247900.1401276364.3
2DLD Change Limit1247901178.79614187.1
3Display Results1171170.0631857.1
 (SQL Overall)1786911178.99919856.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.