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

99 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
nonphotographic28141921nonphotographic_
photographic25410314___photographic_
nonbiographical2572225non__biographical
phonographic2548435___phonographic_
photographies2459415___photographies
photographing2565985___photographing
rephotographing2772015_rephotographing
aortographic2056456ao___rtographic_
chorographic2548556___chorographic_
cinematographic2772106cinematographic_
cryptographic2864466cryp__tographic_
holographic2269526____holographic_
homographic24410076____homographic_
lymphographic3153106lymph__ographic_
monographic2148556mon____ographic_
nomographic2147926__n__omographic_
orthographic2355636_orth__ographic_
orthographical2563056_orth__ographical
pantographic2256576___pantographic_
phonographies2447476___phonographies
photograph21411016___photograph___
photographed2458666___photograph_ed
photographer2349696___photograph_er
photographers2457176___photographers
photographs22411476___photograph__s
photography25410076___photograph__y
pictographic2456386___pictographic_
rephotograph2364186_rephotograph___
rephotographed2663226_rephotograph_ed
rephotographs2464036_rephotograph__s
topographic2167716to_p___ographic_
topographical2354216to_p___ographical
angiographic2155257_an__giographic_
aortographies1955737ao___rtographies
autographic1948047____autographic_
cartographic2266757___cartographic_
cartographical2463337___cartographical
chirographic2556377___chirographic_
chirographical2783507___chirographical
choreographic2655877___choreographic_
chorographies2487437___chorographies
chromatographic3073447chromatographic_
chronographic2655517__chronographic_
cosmographic2455787co___smographic_
cosmographical2693327co___smographical
cryptographies2754087cryp__tographies
ethnographic2355317__eth_nographic_
ethnographical2563217__eth_nographical
fluorographic24113227__fluorographic_
gonadotrophic2262117gonadot__rophic_
holographies2148127____holographies
holographing2275047____holographing
iconographic2255617___iconographic_
iconographical2463287___iconographical
lithographic2355697_lith__ographic_
logographic2047067____logographic_
lymphographies3062647lymph__ographies
monographing2154317mon____ographing
monomorphic2255157mon__omo_r_phic_
nomographies20126607__n__omographies
oceanographic2353407_o_ceanographic_
oceanographical2572247_o_ceanographical
orographic1849077_____orographic_
orographical2054397_____orographical
orthographies2255107_orth__ographies
oscillographic2481987_oscillographic_
paleographic2276557___paleographic_
paleographical2463657___paleographical
petrographic2278027___petrographic_
petrographical2463887___petrographical
phlebographic2853657___phlebographic_
phonogramic2154577___phonogra_mic_
phonogrammic2452687___phonogrammic_
phonograph2148817___phonograph___
phonographer2347867___phonograph_er
phonographers2465807___phonographers
phonographs2248907___phonograph__s
phonography2568307___phonograph__y
phototropic2058207___phototrop_ic_
physiographic2954647___physiographic_
physiographical3172857___physiographical
pictographies2355637___pictographies
planographic2255467___planographic_
polarographic2394137po__larographic_
polygraphic2464717___p_olygraphic_
pornographic2286657___pornographic_
prototrophic2154847___prototrophic_
renographic1947407ren____ographic_
reprographic2296657_rep__rographic_
reprographics2395177_rep__rographics
sonographies1846617son____ographies
spectrographic2662877__spectrographic_
telephotography2981737telephotograph__y
tomographic2148777____tomographic_
topographies20116937to_p___ographies
typographic2456457_typ___ographic_
typographical2663897_typ___ographical
zoogeographic3153187zo__ogeographic_
zoogeographical332134497zo__ogeographical

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.1101624463.6
2DLD Change Limit95024999.23310291.8
3Display Results99990.0801237.5
 (SQL Overall)178691999.42318963.3
 
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.