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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

112 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
cartography224678(None) 
aortography2046402aortography
autography1947622_autography
cacography2345832ca_cography
cardiography2454242cardiography
cartographer2096112cartographer
cartographic2266752cartographic
autograph1548893_autograph_
autographs1648733_autographs
barograph1746963bar_ograph_
barographs1847073bar_ographs
calligraphy2262563calligraphy
cardiograph2054763cardiograph_
cardiographs2164543cardiographs
cartogram1445503cartogra__m
cartograms1545113cartogra_ms
cartographers2194463cartographers
cartographies2156043cartographies
chirography2546133chirography
choreography2656003choreography
chorography2548453chorography
chronography26125743chronography
cosmography2445593cosmography
cryptography2854563cryptography
hagiography2445503hagiography
mammography2353813mammography
orography1847953_or_ography
orthography2355173_orthography
paleography2246173paleography
pantograph1847063pantograph_
pantographs1946573pantographs
petrography2247543petrography
photography25410073photography
pictography2446073pictography
pornography2246213pornography
radiography2165943radiography
uranography2054183uranography
xerography2647173xer_ography
allograph1547534_allograph_
allographs1648064_allographs
altigraph1554404_altigraph_
altigraphs1654314_altigraphs
angiography2154514angiography
aortographic2056454aortographic
arteriography2263384_arteriography
autographed1856154_autographed
autographic1948044_autographic
autotrophy1875184_autotrophy
barographic2146564bar_ographic
biography2046224__biography
cardiographic2454214cardiographic
cartographical2463344cartographical
choreograph2256154choreograph_
choreographs2356194choreographs
chromatography30134384chromatography
chronograph22146074chronograph_
chronographs23145844chronographs
coronograph19124934coronograph_
coronographs20124924coronographs
cryptograph2454644cryptograph_
cryptographs2554574cryptographs
cymograph2296844c_ymograph_
cymographs2397004c_ymographs
demography2246974_demography
discography2354094discography
ergograph1646074_ergograph_
ergographs1746364_ergographs
ethnography2355144ethnography
filmography2554174filmography
flexography3053444flexography
geography1946454__geography
hectograph2146264hectograph_
hectographs2256204hectographs
holography2278614_holography
hydrography2746194hydrography
iconography2245454iconography
ideography2046214_ideography
kymography28114894_kymography
lithography2365374lithography
mythography2854404mythography
nomography2166804_nomography
oceanography2353414oceanography
pantographic2256584pantographic
paragraph1745014par_agraph_
paragraphs1844844par_agraphs
phonography2568304phonography
photograph21411014photograph_
photographs22411474photographs
pictograph2046654pictograph_
pictographs2146554pictographs
planography2255164planography
polarography2353904polar_ography
radiograph1756384radiograph_
radiographs1856524radiographs
renography1947024_renography
reprography2246524reprography
scenography2254844scenography
scintigraphy2361994scintigraphy
serigraphy1954564ser_igraphy
sonography1947204_sonography
stenography2045604stenography
stereography2154974stereography
stratigraphy2162614stratigraphy
stylography2354534stylography
thermography2655334thermography
tomography2177794_tomography
topography2177094_topography
typography2495894_typography
venography2245764_venography
videography2454434videography
xylography2945004_xylography
zoography2745664__zoography

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 Filter1786911488190.423422437.4
2DLD Change Limit1488191129.03016480.5
3Display Results1121120.0631777.8
 (SQL Overall)1786911129.51618778.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.