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

51 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
cinematographer2512206(None) 
cinematograph2372692cinematograph__
cinematographic2772102cinematographic
cinematographs2472562cinematograph_s
cinematography2772652cinematograph_y
chromatographer28213583chromatographer
chromatographed29163364chromatographed
cartographer2096115c___artographer
chromatograph26134555chromatograph__
chromatographic3073445chromatographic
chromatographs27134375chromatograph_s
chromatography30134385chromatograph_y
cosmographer2254885c_osm__ographer
cryptographer2663745c__ryptographer
demographer2046375__dem__ographer
oceanographer2162965_oce_anographer
videographer2254325vide___ographer
anemograph1855376_anem__ograph__
anemographs1955416_anem__ograph_s
bibliographer2362946bi__bliographer
biogeographer2273586bi__ogeographer
biographer18126516bi_____ographer
cartographers2194466c___artographers
chirographer23106066c___hirographer
choreographer2495746c__horeographer
chorographer23118246c___horographer
cinemagoer1552036cinema__g___oer
cosmographers2353596c_osm__ographers
cryptographers2762916c__ryptographers
demographers2154566__dem__ographers
discographer2154166di___scographer
ethnographer2184786___ethnographer
geographer1746166__ge___ographer
hectographed2454546__he_ctographed
historiographer2471936historiographer
iconographer2054896_i__conographer
lexicographer28152576__lexicographer
lithographer2155026li___thographer
metallographer2262336__metallographer
mimeographed2353736mi__m_eographed
mythographer26124516____mythographer
oceanographers2262296_oce_anographers
paleographer20115736pale___ographer
petrographer2057286__pe_trographer
photographer2349696___photographer
reprographer2056256__re_prographer
scenographer2064696_sce__nographer
seismographer21143406__seismographer
stenographer1875306_ste__nographer
thermographer2464886_the_rmographer
videographers2353406vide___ographers

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.1231452772.4
2DLD Change Limit95024518.79610803.1
3Display Results51510.0331545.5
 (SQL Overall)178691518.95219961.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.