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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
lymphographies306264(None) 
lymphographic3153102lymphographi_c
kymographies2754483kym__ographies
lithographies2295273l_ithographies
lymphography3153023lymphograph__y
mythographies2754553my_thographies
typographies23105663ty_p_ographies
cryptographies2754084cryptographies
demographies2156414dem__ographies
hydrographies2675804hy_drographies
lexicographies2962644lexicographies
lymphograms2452574lymphogra___ms
mammographies2253564mam_mographies
nomographies20126604nom__ographies
orthographies2255104_orthographies
reprographies2196094_reprographies
tomographies20127364tom__ographies
topographies20116934_top_ographies
xylographies2855264xy__lographies
angiographies2054365_angiographies
aortographies1955735_aortographies
autographies1856955__autographies
bibliographies2463385bibliographies
biogeographies2353355biogeographies
biographies1996495___biographies
cacographies2255725__cacographies
cardiographies2353715cardiographies
cartographies2156045_cartographies
chirographies2465905_chirographies
choreographies2555275choreographies
chorographies2487435_chorographies
chronographies2574935chronographies
cosmographies2355055_cosmographies
cymographs2397005cym__ograph__s
demographics2355765dem__ographics
discographies2284585_discographies
epigraphies1954935__ep_igraphies
ethnographies2254935_ethnographies
filmographies2454305_filmographies
flexographies2953545_flexographies
fluorographies2392875fluorographies
geographies1856615___geographies
hagiographies2354925_hagiographies
holographies2148125__holographies
iconographies2155055_iconographies
ideographies1955775__ideographies
kymographic2845735kym__ographi_c
kymographs25115545kym__ograph__s
lithographed2254385l_ithograph_ed
lithographer2155025l_ithograph_er
lithographers2253905l_ithographers
lithographic2355695l_ithographi_c
lithographing2362815l_ithographing
lithographs2065645l_ithograph__s
lymphogram2352795lymphogra____m
lymphomatoses2561955lympho_matoses
mythographer26124515my_thograph_er
mythographers2793635my_thographers
nympholepsies257925nympho_lepsies
oceanographies2263055oceanographies
orographies1767795___orographies
paleographies2155735_paleographies
petrographies2157145_petrographies
phlebographies2763305phlebographies
phonographies2447475_phonographies
photographies2459415_photographies
physiographies2854195physiographies
pictographies2355635_pictographies
planographies2164885_planographies
polarographies2253535polarographies
pornographies2165965_pornographies
radiographies2055825_radiographies
renographies1866535__renographies
reprographics2395175_reprographics
scenographies21124525_scenographies
seismographies2253345seismographies
sonographies1846615__sonographies
stenographies19125315_stenographies
stereographies2054245stereographies
stylographies2254355_stylographies
thermographies2554695thermographies
typographed2354685ty_p_ograph_ed
typographer2255345ty_p_ograph_er
typographers2354075ty_p_ographers
typographic2456455ty_p_ographi_c
typographing2453355ty_p_ographing
typographs2196485ty_p_ograph__s
uranographies1954245_uranographies
venographies2165675__venographies
videographies2354425_videographies
xerographies2586715__xerographies
zoogeographies301864575zoogeographies
zoographies2645805___zoographies

Search took 7 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.343520965.0
2DLD Change Limit95024935.64016848.2
3Display Results93930.0631476.2
 (SQL Overall)178691936.04629555.2
 
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.