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

82 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
biographers1915511(None) 
biographees19124531biographees
biographer18126511biographer_
biographee18155542biographe_e
biographies1996492biographies
geographers1854782geographers
bibliographers2462533bibliographers
biogeographers2382913biogeographers
biographic2047443biograph_ic
biography2046223biograph__y
chirographers2494693chirographers
demographers2154563demographers
discographers2253193discographers
epigraphers1953403epigraphers
geographer1746163geographer_
hagiographers2353743hagiographers
holographers2166223holographers
lithographers2253903lithographers
topographers2055073topographers
typographers2354073typographers
videographers2353403videographers
xylographers2853813xylographers
autobiographers2372044autobiographers
barographs1847074barograph__s
bibliographer2362944bibliographer_
biogases1136144biog_a_se_s
biogasses1244004biog_asse_s
biogeographer2273584biogeographer_
biographical2254514biographical
biomarkers1842654bio_markers
biosphere1664784bio__sphere
biospheres1765144bio__spheres
bolographs1867534bolograph__s
broachers16328154bro__achers
cartographers2194464cartographers
chirographer23106064chirographer_
chorographers24106124chorographers
cosmographers2353594cosmographers
demographer2046374demographer_
diagraphs1644544diagraph__s
digraphs15105754di_graph__s
discographer2154164discographer_
disgracers1444734disgra_cers
dognapers1343074_dognap_ers
dognappers1642054_dognappers
epigrapher1854064epigrapher_
ethnographers2293584ethnographers
forgathers1743554_forgathers
geographies1856614geographies
hagiographer2255014hagiographer_
holographer2088394holographer_
hydrographers2654164hydrographers
iconographers2153634iconographers
ingathers1344454_ing_athers
isographs1546724isograph__s
lexicographers29172194lexicographers
lithographer2155024lithographer_
myographs2085704myograph__s
mythographers2793634mythographers
odographs1667344odograph__s
orographies1767794orographies
paleographers21114244paleographers
paragraphers2093034paragraphers
petrographers2155074petrographers
phonographers2465804phonographers
photographers2457174photographers
physiographers2863404physiographers
polygraphers2353404polygraphers
pornographers2164494pornographers
programers1584404progra_mers
programmers1893534programmers
reprographers2154664reprographers
scenographers2173634scenographers
seismographers22142684seismographers
serigraphers1853574serigraphers
stenographers19104094stenographers
telegraphers1853794telegraphers
topographer1946694topographer_
typographer2255344typographer_
videographer2254324videographer_
xylographer2754834xylographer_
zoographies2645804zoographies

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 Filter1786911488190.436409841.7
2DLD Change Limit148819828.86016796.7
3Display Results82820.0461782.6
 (SQL Overall)178691829.34219127.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.