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

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
thermographies255468(None) 
thermographer2464882thermograph_er
thermographers2553682thermographers
thermographic2655652thermographi_c
thermographs2355652thermograph__s
chirographies2465903chir_ographies
choreographies2555273choreographies
chorographies2487433chor_ographies
demographies2156413_de_mographies
stereographies2054243stereographies
thermograph2255493thermograph___
thermography2655323thermograph__y
tomographies20127353t__omographies
xerographies2586713_xer_ographies
aortographies1955724_aortographies
arteriographies2172744arteriographies
cartographies2156044_cartographies
chronographies2574924chronographies
cosmographies2355054_cosmographies
demographics2355764_de_mographics
ethnographies2254934eth__nographies
filmographies2454304_filmographies
flexographies2953544fle_xographies
geographies1856614_ge__ographies
hagiographies2354924_hagiographies
holographies2148124_h_olographies
hydrographies2675774_hydrographies
ideographies1955774ide__ographies
kymographies2754484__kymographies
mammographies2253564_mammographies
nomographies20126604__nomographies
oceanographies2263054oceanographies
orographies1767794__or_ographies
petrographies2157144_petrographies
phlebographies2763304phlebographies
phonographies2447474ph_onographies
photographies2459394ph_otographies
physiographies2854194physiographies
pornographies2165964_pornographies
renographies1866534_re_nographies
reprographies2196094_reprographies
scenographies21124524sce_nographies
seismographies2253344seismographies
serigraphies18114764_ser_igraphies
stenographies19125314ste_nographies
telegraphies1854774t_e_legraphies
thermograms1964484thermogra___ms
thermophiles2254264thermo___philes
topographies20116934t__opographies
typographies23105664t__ypographies
venographies2165674_ve_nographies

Search took 8 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.1101624463.6
2DLD Change Limit65874517.6738585.2
3Display Results51510.063809.5
 (SQL Overall)178691517.84622774.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.