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

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

28 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
cinematographic2772101cinematographic_
cinematograph2372693cinematograph___
cinematographer25122063cinematograph_er
cinematographs2472563cinematograph__s
cinematography2772653cinematograph__y
chromatographic3073444chromatographic_
cacographical2263416c____acographical
cartographic2266756c___artographic_
cartographical2463346c___artographical
chromatograph26134556chromatograph___
chromatographed29163366chromatograph_ed
chromatographer28213586chromatograph_er
chromatographs27134376chromatograph__s
chromatography30134386chromatograph__y
cosmographic2455786c_osm__ographic_
cosmographical2693326c_osm__ographical
cryptographic2864466c__ryptographic_
demographic2247866__dem__ographic_
demographical2454176__dem__ographical
demographics2355766__dem__ographics
ideographic2056876_ide___ographic_
nomographic2147926__nom__ographic_
nonphotographic28141926nonphotographic_
oceanographic2353406_oce_anographic_
oceanographical2572246_oce_anographical
pantographic2256586pan___tographic_
pictographic2456386pi___ctographic_
scintigraphic23101776scin___tigraphic_

Search took 7 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 Filter178691658740.313570897.8
2DLD Change Limit65874285.65611646.7
3Display Results28280.030933.3
 (SQL Overall)178691285.99929786.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.