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 “photogrammetrica” with Change Limit: [1] [2] [3] [4] [5] [6] [7] [8]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

44 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
photogrammetric277871photogrammetric_
photogrammetry2771233photogrammetr__y
phonogrammic2452685phonogramm___ic_
photometric2058605photo____metric_
homogametic2153286_homog_a_met_ic_
logogrammatic2171486_logogrammat_ic_
monogrammatic1962636_monogrammat_ic_
phonogramic2154576phonogra_m___ic_
photographer2349696photographe_r___
photographers2457176photographe_r__s
photographic25410316photogra___phic_
photometries1968336photo____metries
programmatic2163146p__rogrammat_ic_
colorimetric1853097_colo_r_imetric_
hygrometric2254707_h__ygr_ometric_
ideogrammatic2181537_ideogrammat_ic_
monogrammer1553027_monogramme_r___
monogrammers1652607_monogramme_r__s
nongrammatical2192277_no_ngrammat_ical
nonparametric1962187_nonpara_metric_
parametric1646937p____ara_metric_
phonographer2347867phonographe_r___
phonographers2465807phonographe_r__s
phonographic2548437phonogra___phic_
photoelectric2263837photo__electric_
photogenic1848297photog____e_nic_
photogram1748237photogra_m______
photograms1848197photogra_m_____s
photographed2458667photographe____d
photographies2459417photogra___phies
photographing2565987photogra___phing
photogravure2182327photogra__vur__e
photogravures2272197photogra__vur_es
photokinetic2374347photo__kinet_ic_
photometrically2764077photo____metrically
photometry2056467photo____metr__y
photospheric2455137photo__sphe_ric_
photostatic1857117photosta___t_ic_
photosynthetic2792707photosynthet_ic_
phototactic2055297photo_ta__ct_ic_
polarimetric1862657p_o_lar_imetric_
potentiometric2071267p_otentiometric_
programmer1794117p__rogramme_r___
programmers1893537p__rogramme_r__s

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 Filter178691950240.360496363.9
2DLD Change Limit95024448.95310613.6
3Display Results44440.046956.5
 (SQL Overall)178691449.35919093.0
 
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.