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 “olfactometers” 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.
to automatically increase the Change Limit after seconds.

66 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
olfactometers2014201(None) 
olfactometer19162151olfactometer_
refractometers2182323refractometers
diffractometers2671444diffractometers
dilatometers1553114dila_tometers
electrometers1765804el_ectrometers
hectometers1846064__hectometers
hemacytometers2671414hemacytometers
octameters1444834o___ctameters
olfactories1653544olfacto_rie_s
optometers1456744o___ptometers
reflectometers21142864reflectometers
refractometer2072494refractometer_
tachometers1855074__tachometers
actinometers1653915___actinometers
aerometers1249485___aerometers
algometers1346005___algometers
alkalimeters1891755alka_limeters
altimeters1246355___altimeters
atmometers1445875___atmometers
barometers14198515__ba_rometers
blastomeres1583765bl_astomere_s
bolometers1447385bol____ometers
clinometers1544725cl__inometers
cyclometers2045185__cyclometers
densitometers16142845densitometers
diffractometer2571455diffractometer_
dilatometer1453265dila_tometer_
dynamometers2062505dyna_mometers
elastomers1244275el_astom__ers
electrometer1656275el_ectrometer_
fluorometers17113025fl_uorometers
galvanometers1961345galva_nometers
gasometers1346645__ga_someters
gradiometers1683465_gradiometers
hectometer1746415__hectometer_
hemacytometer25101595hemacytometer_
hemocytometers2671155hemocytometers
magnetometers1872245magnetometers
manometers1448025__ma_nometers
micrometers1749075__micrometers
nanometers1247125__na_nometers
octameter1355015o___ctameter_
odometers1247135o____dometers
olfactory1743085olfacto____ry
optometer1347295o___ptometer_
orometers11310425o____rometers
osmometers1444925o___smometers
photometers1848445__photometers
picometers1648285__pic_ometers
planimeters1543465pl_a_nimeters
polarimeters16132665pol_a_rimeters
potometers1449065___potometers
pycnometers2044455__pycnometers
radiometers1466175__radiometers
ratemeters1244995__ra_temeters
reflectometer20143185reflectometer_
refractometry2362315refractomet_ry
salometers1258075__sa_lometers
sensitometers15133075sensitometers
spectrometers1953075_spectrometers
tachometer1745365__tachometer_
variometers1645165__variometers
viscometers1854945_visc_ometers
voltmeters1554285vol___t_meters
wattmeters1543605__wa_ttmeters

Search took 9 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 Limit124790668.19015236.9
3Display Results66660.0302200.0
 (SQL Overall)178691668.36021374.5
 
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.