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

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
filmography255417(None) 
bibliography2553033bibliography
biography2046223bi__ography
cosmography2445593cosmography
demography2246973_demography
discography2354093discography
filmographies2454303filmographies
flexography3053443flexography
holography2278613hol_ography
ideography2046213_ideography
kymography28114893_kymography
lithography2365373lithography
mammography2353813mammography
nomography2166803_nomography
paleography2246173paleography
pictography2446073pictography
seismography23133883seismography
tomography2177793_tomography
videography2454433videography
xylography2945003xyl_ography
allograph1547534_allograph_
allographs1648064_allographs
anemograph1855374anemograph_
anemographs1955414anemographs
angiography2154514angiography
aortography2046404aortography
autography1947624_autography
biogeography2453714biogeography
bolograph1767294bol_ograph_
bolographs1867534bol_ographs
cacography2345834_cacography
calligraphy2262564calligraphy
cartography2246784cartography
chirography2546134chirography
chorography2548454chorography
cymograph2296844_cymograph_
cymographs2397004_cymographs
ethnography2355144ethnography
fluorography2453264fluorography
geography1946454__geography
hagiography2445504hagiography
heliograph1946904heliograph_
heliographs2047124heliographs
holograph1879664hol_ograph_
holographs1979984hol_ographs
homograph20810424_homograph_
homographs21710554_homographs
hydrography2746194hydrography
iconography2245454iconography
ideograph1646484_ideograph_
ideographs1746784_ideographs
isograph1446704_i_sograph_
isographs1546724_i_sographs
kymograph24115404_kymograph_
kymographs25115544_kymographs
lithograph1965634lithograph_
lithographs2065644lithographs
micrograph2047564micrograph_
micrographs2147784micrographs
mimeograph2054544mimeograph_
mimeographs2184764mimeographs
mythography2854404mythography
nomograph1787544_nomograph_
nomographs1877804_nomographs
oleograph1547364_oleograph_
oleographs1647854_oleographs
orography1847954__orography
orthography2355174orthography
oscillography2482154oscillography
petrography2247544petrography
phlebography2853614phlebography
phonography2568304phonography
photography25410074photography
pictograph2046654pictograph_
pictographs2146554pictographs
planography2255164planography
polarography2353904polarography
pornography2246214pornography
radiography2165944radiography
renography1947024_renography
reprography2246524reprography
scenography2254844scenography
seismograph19123844seismograph_
seismographs20123914seismographs
sonography1947204_sonography
stenography2045604stenography
stylography2354534stylography
telegraphy1954374tel_egraphy
thermography2655334thermography
tomograph1788714_tomograph_
tomographs1889084_tomographs
topography2177094_topography
typography2495894_typography
uranography2054184uranography
venography2245764_venography
xerography2647174_xerography
xylograph2545134xyl_ograph_
xylographs2645664xyl_ographs
zoography2745664__zoography

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 Filter1786911488190.420425454.8
2DLD Change Limit148819998.25018038.7
3Display Results99990.0462152.2
 (SQL Overall)178691998.71620501.5
 
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.