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

66 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
autobiography246307(None) 
autobiographer2262562autobiographer
autobiographic2462782autobiographic
arteriography2263383arteriography
autobiographers2372043autobiographers
autobiographies2362333autobiographies
autography1947623aut___ography
autoradiography25152473autoradiography
angiography2154514a__ngiography
aortography2046404a__ortography
autograph1548894aut___ograph_
autographs1648734aut___ographs
autoradiograph21112584autoradiograph_
autoradiographs22142454autoradiographs
biography2046224____biography
historiography2672334historiography
tomography2177794__to_mography
topography2177094__to_pography
altigraph1554405alt__i_graph_
altigraphs1654315alt__i_graphs
antipornography26111345antipornography
arteriographic2272815arteriographic
autographed1856155aut___ographed
autographic1948045aut___ographic
autotrophy1875185aut___otrophy
bibliography2553035_bibliography
biogeography2453715_biogeography
cardiography2454245_cardiography
cartography2246785cart___ography
choreography2656005_choreography
chorography2548455_cho_rography
chronography26125745chro_nography
cosmography2445595__cosmography
ethnography2355145_et_hnography
fluorography2453265fluo_rography
hagiography2445505__hagiography
holography2278615__ho_lography
iconography2245455_ico_nography
lithography2365375lit__hography
metallography2462945metallography
mythography2854405myt__hography
nomography2166805__no_mography
orography1847955___o_rography
orthography2355175ort__hography
paleogeography2682205paleogeography
petrography2247545pet__rography
phlebography2853615phleb_ography
phonography2568305_pho_nography
photography25410075_pho_tography
physiography2954495_physiography
phytogeography3262735phytogeography
pornography2246215__pornography
psychobiography3671855psychobiography
radiography2165945__radiography
sonography1947205__so_nography
stenography2045605_st_enography
stereography2154975_stereography
stylography2354535_st_ylography
tomograph1788715__to_mograph_
tomographs1889085__to_mographs
topograph1787485__to_pograph_
topographs1888045__to_pographs
typography2495895__t_ypography
uranography2054185_u_ranography
zoogeography3152975_zoogeography
zoography2745665__zo__ography

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.390458182.1
2DLD Change Limit124790668.61014493.6
3Display Results66660.0461434.8
 (SQL Overall)178691669.04619753.6
 
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.