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 “cinematographic” 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.

75 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
cinematographic277210(None) 
cinematograph2372692cinematograph__
cinematographer25122062cinematographer
cinematographs2472562cinematograph_s
cinematography2772652cinematograph_y
chromatographic3073443chromatographic
cartographic2266755c___artographic
chromatograph26134555chromatograph__
chromatographed29163365chromatographed
chromatographer28213585chromatographer
chromatographs27134375chromatograph_s
chromatography30134385chromatograph_y
cosmographic2455785c_osm__ographic
cryptographic2864465c__ryptographic
demographic2247865__dem__ographic
ideographic2056875_ide___ographic
nomographic2147925__nom__ographic
nonphotographic28141925nonphotographic
oceanographic2353405_oce_anographic
pantographic2256585pan___tographic
pictographic2456385pi___ctographic
scintigraphic23101775scin___tigraphic
anemograph1855376_anem__ograph__
anemographs1955416_anem__ograph_s
angiographic2155256_an__giographic
aortographic2056456___aortographic
arteriographic2272816arte_riographic
autographic1948046____autographic
barographic2146566____barographic
bibliographic2553296bi__bliographic
biogeographic2453956bi__ogeographic
biographic2047446bi_____ographic
cardiographic2454226c__ardiographic
chirographic2556376c___hirographic
choreographic2655876c__horeographic
chorographic2548556c___horographic
chronographic2655516c__hronographic
cinematic1546386cinemat______ic
demographics2355766__dem__ographics
dermatoglyphic2871276_dermatoglyphic
discographic2354666di___scographic
ethnographic2355316___ethnographic
flexographic3063996_fle__xographic
geographic1947756__ge___ographic
heliographic2356946__he_liographic
historiographic2672046historiographic
homographic24410076__hom__ographic
iconographic2255616_i__conographic
idiographic2046796_i___diographic
kymographic2845736__kym__ographic
lexicographic3062806__lexicographic
lithographic2355696li___thographic
lymphographic3153106__lymphographic
mammographic2354186____mammographic
metallographic2462416__metallographic
micrographic2467126mi___crographic
monographic2148556____monographic
paleogeographic2691796paleogeographic
paleographic2276556pale___ographic
petrographic2278026__pe_trographic
phlebographic2853656phle__bographic
photographic25410316___photographic
planographic2255466___planographic
polarographic2394136__polarographic
renographic1947406__re__nographic
reprographic2296656__re_prographic
scenographic2275196_sce__nographic
seismographic2373786__seismographic
spectrographic2662876_spectrographic
stenographic2055906_ste__nographic
stereographic2154886_ste_reographic
stratigraphic2162196__stratigraphic
thermographic2655656_the_rmographic
tomographic2148776__tom__ographic
xerographic2667926__xe__rographic

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 Filter178691950240.360496363.9
2DLD Change Limit95024758.03311829.2
3Display Results75750.0461630.4
 (SQL Overall)178691758.43921174.4
 
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.