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

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

144 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
videographies235442(None) 
ideographies1955771_ideographies
videographer2254322videograph_er
videographers2353402videographers
biogeographies2353353biogeographies
biographies1996493bi__ographies
demographies2156413__demographies
discographies2284583discographies
filmographies2454303filmographies
geographies1856613__geographies
hydrographies2675803hydrographies
ideographic2056873_ideographi_c
ideographs1746783_ideograph__s
lithographies2295273lithographies
paleographies2155733paleographies
pictographies2355633pictographies
radiographies2055823radiographies
venographies2165673v_enographies
videography2454433videograph__y
angiographies2054364angiographies
aortographies1955734aortographies
autographies1856954_autographies
bibliographies2463384bibliographies
biographees19124534bi__ographees
cacographies2255724_cacographies
cardiographies2353714cardiographies
cartographies2156044cartographies
chirographies2465904chirographies
choreographies2555274choreographies
chorographies2487434chorographies
cosmographies2355054cosmographies
demographics2355764__demographics
ethnographies2254934ethnographies
flexographies2953544flexographies
hagiographies2354924hagiographies
holographies2148124_holographies
iconographies2155054iconographies
ideograph1646484_ideograph___
ideography2046214_ideograph__y
idiographic2046794_idiographi_c
kymographies2754484_kymographies
mammographies2253564mammographies
micrographics2555644micrographics
mimeographed2353734mimeograph_ed
mimeographing2462274mimeographing
mimeographs2184764mimeograph__s
mythographies2754554mythographies
nomographies20126604_nomographies
orographies1767794__orographies
orthographies2255104orthographies
petrographies2157144petrographies
phlebographies2763304phlebographies
phonographies2447474phonographies
photographies2459414photographies
planographies2164884planographies
pornographies2165964pornographies
renographies1866534_renographies
reprographies2196094reprographies
scenographies21124524scenographies
seismographies2253344seismographies
sonographies1846614_sonographies
stenographies19125314stenographies
stereographies2054244stereographies
stylographies2254354stylographies
telegraphies1854774tele_graphies
tomographies20127364_tomographies
topographies20116934_topographies
typographies23105664_typographies
uranographies1954244uranographies
videophiles2052704video___philes
videotapes16172734video_tap__es
xerographies2586714_xerographies
xylographies2855264_xylographies
zoogeographies301864574zoogeographies
zoographies2645804__zoographies
arteriographies2172745arteriographies
biogeographer2273585biogeograph_er
biogeographers2382915biogeographers
biogeographic2453955biogeographi_c
biographee18155545bi__ograph_ee
biographer18126515bi__ograph_er
biographers19155115bi__ographers
biographic2047445bi__ographi_c
calligraphies2153195calligraphies
chronographies2574935chronographies
cryptographies2754085cryptographies
demographer2046375__demograph_er
demographers2154565__demographers
demographic2247865__demographi_c
discographer2154165discograph_er
discographers2253195discographers
discographic2354665discographi_c
epigraphies1954935__epigraphies
fluorographies2392875fluorographies
geographer1746165__geograph_er
geographers1854785__geographers
geographic1947755__geographi_c
hydrographer2555805hydrograph_er
hydrographers2654165hydrographers
hydrographic2756365hydrographi_c
ideogramic1652395_ideogra_mi_c
ideogrammic1961905_ideogrammi_c
ideograms1344805_ideogra___ms
idiopathies1752275_idio_pathies
isographs1546725_i_sograph__s
lexicographies2962645lexicographies
lithographed2254385lithograph_ed
lithographer2155025lithograph_er
lithographers2253905lithographers
lithographic2355695lithographi_c
lithographing2362815lithographing
lithographs2065645lithograph__s
lymphographies3062645lymphographies
micrographed2365945micrograph_ed
micrographic2467125micrographi_c
micrographing2463735micrographing
micrographs2147785micrograph__s
mimeograph2054545mimeograph___
oceanographies2263055oceanographies
odographs1667345_od_ograph__s
oleographs1647855_oleograph__s
oscillographies2381775oscillographies
paleographer20115735paleograph_er
paleographers21114245paleographers
paleographic2276555paleographi_c
physiographies2854195physiographies
pictographic2456385pictographi_c
pictographs2146555pictograph__s
polarographies2253535polarographies
radiographed2065125radiograph_ed
radiographic2156365radiographi_c
radiographing2173465radiographing
radiographs1856525radiograph__s
reprographics2395175reprographics
scintigraphies2261695scintigraphies
serigraphies18114765_serigraphies
shadowgraphies2761505shadowgraphies
supergraphics2362055supergraphics
thermographies2554695thermographies
videophile1952875video___phile
videophones2053075video___phones
videotape15152725video_tap__e_
videotaped17132105video_tap__ed
videotaping1851705video_tap_ing

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901449.42313243.1
3Display Results1441440.0931548.4
 (SQL Overall)1786911449.65618505.7
 
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.