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

119 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
biographical225451(None) 
biographic2047442biographic__
biographically2764412biographically
geographical2164532geographical
orographical2054392orographical
bibliographical2772463bibliographical
biogeographical2682733biogeographical
biographies1996493biographi_es
cacographical2263413cacographical
chirographical2783503chirographical
demographical2454173demographical
discographical2562833discographical
epigraphical2263583epigraphical
graphical1745883___graphical
hagiographical2663223hagiographical
nonbiographical2572233nonbiographical
topographical2354213topographical
typographical2663893typographical
xylographical3163573xylographical
barographic2146564barographic__
bioethical1753744bio__ethical
biographee18155544biograph__ee
biographees19124534biograph_ees
biographer18126514biograph__er
biographers19155114biograph_ers
biography2046224biograph___y
biradical14105324bi__ra_dical
cartographical2463344cartographical
cosmographical2693324cosmographical
digraphic1845514di_graphic__
digraphically2564274di_graphically
ethnographical2563214ethnographical
geographic1947754geographic__
geographically2664584geographically
iconographical2463284iconographical
idiographic2046794idiographic__
lexicographical3292214lexicographical
orographic1849074orographic__
orphical1546734__o_r_phical
orthographical2563054orthographical
paleographical2463664paleographical
petrographical2463894petrographical
physiographical3172864physiographical
agraphia1445245__agraphi_a_
agraphias1545075__agraphi_as
agraphic1646185__agraphic__
allographic1947435allographic__
angiographic2155255angiographic__
autographic1948045autographic__
autographically2663805autographically
bibliographic2553295bibliographic__
biochemical2254355bio_chemical
biogeochemical2672225biogeochemical
biogeographic2453955biogeographic__
biological15128885bio__logical
biomedical1753815bio__medical
biometrical1755485bio_metrical
biomorphic2154955biomorphic__
biophysical2362915bio_physical
biotechnical2162865biotechnical
biotical1248865bio____tical
bipyramidal216945bipyra_midal
biracial12107975bi__ra_ci_al
biradial1167715bi__ra_di_al
biradicals15103645bi__ra_dicals
botanical1366075b_o_ta_nical
brachial15219305b___rachi_al
chirographic2556375chirographic__
demographic2247865demographic__
demographically2963885demographically
demographics2355765demographic_s
discographic2354665discographic__
dogmatical1674725_dogma_tical
epigraphic2055335epigraphic__
epigraphically2763275epigraphically
geographies1856615geographi_es
graphic1537355___graphic__
graphically2256225___graphically
graphics1645655___graphic_s
hagiographic2495725hagiographic__
heliographic2356945heliographic__
hierarchical2262215hi_erarchical
hieroglyphical2871565hieroglyphical
holographic2269525holographic__
holographically2973965holographically
homographic24410075homographic__
ideographic2056875ideographic__
ideographically27113715ideographically
impractical1953085_impractical
intrathecal1652925_intrathecal
kymographic2845735kymographic__
lithographic2355695lithographic__
logographic2047065logographic__
logographically2773475logographically
micrographic2467125micrographic__
micrographics2555645micrographic_s
monarchical2053565_monarchical
monographic2148555monographic__
nomographic2147925nomographic__
oceanographical2572245oceanographical
oligarchical2061905oligarchical
orographies1767795orographi_es
pictographic2456385pictographic__
piratical1348675pi__ra_tical
radiographic2156375radiographic__
renographic1947405renographic__
timocratical1862945timocra_tical
tomographic2148775tomographic__
topographic2167715topographic__
topographically28143695topographically
triglyphical2361105triglyphical
trigraphic1854765trigraphic__
typographic2456455typographic__
typographically31133725typographically
xerographic2667925xerographic__
xerographically3363645xerographically
xylographic2946105xylographic__
zoogeographical332134495zoogeographical
zoographies2645805zoographi_es

Search took 14 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 Limit14881911912.69011727.3
3Display Results1191190.0761565.8
 (SQL Overall)17869111913.18613551.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.