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

126 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
biogeographic245395(None) 
biogeographer2273582biogeographer
biogeographical2682732biogeographical
biogeographies2353352biogeographies
biogeography2453712biogeograph_y
zoogeographic3153182zoogeographic
bibliographic2553293bibliographic
biogeographers2382913biogeographers
biographic2047443bi___ographic
choreographic2655873choreographic
geographic1947753___geographic
ideographic2056873_i_deographic
logographic2047063_log_ographic
angiographic2155254_angiographic
aortographic2056454_aortographic
barographic2146564b__arographic
biomorphic2154954bio_mo_r_phic
chorographic2548554cho_rographic
cosmographic2455784_cosmographic
discographic2354664di_scographic
hagiographic2495724_hagiographic
holographic2269524_ho_lographic
homographic24410074_ho_mographic
iconographic2255614_iconographic
idiographic2046794_i_diographic
lithographic2355694li_thographic
micrographic2467124mi_crographic
monographic2148554_mo_nographic
nomographic2147924_no_mographic
orographic1849074__o_rographic
paleogeographic2691794paleogeographic
paleographic2276554_paleographic
phonographic2548434pho_nographic
photographic25410314pho_tographic
phytogeographic3292244phytogeographic
pictographic2456384pi_ctographic
pornographic2286654_pornographic
stereographic2154884stereographic
tomographic2148774_to_mographic
topographic2167714_to_pographic
zoogeographer2962784zoogeographer
zoogeographical332134494zoogeographical
zoogeographies301864574zoogeographies
zoogeography3152974zoogeograph_y
allographic1947435__allographic
autobiographic2462785autobiographic
autographic1948045__autographic
bibliographer2362945bibliographer
bibliographical2772465bibliographical
bibliographies2463385bibliographies
bibliography2553035bibliograph_y
biographee18155545bi___ographee
biographer18126515bi___ographer
biographical2254515bi___ographical
biographies1996495bi___ographies
biography2046225bi___ograph_y
bolograph1767295b_o_lograph__
bolographs1867535b_o_lograph_s
cardiographic2454215cardiographic
cartographic2266755_cartographic
chirographic2556375_chirographic
choreograph2256155choreograph__
choreographed25104825choreographed
choreographer2495745choreographer
choreographies2555275choreographies
choreographing2663295choreographing
choreographs2356195choreograph_s
choreography2656005choreograph_y
chronographic2655515chronographic
cryptographic2864465cryptographic
demographic2247865__demographic
diageotropic1861515diageotrop_ic
digraphic1845515di____graphic
ethnographic2355315_ethnographic
flexographic3063995_flexographic
fluorographic24113225fluorographic
geographer1746165___geographer
geographical2164535___geographical
geographies1856615___geographies
geography1946455___geograph_y
heliographic2356945_heliographic
historiographic2672045historiographic
hydrographic2756365_hydrographic
ideogramic1652395_i_deogra_mic
ideogrammic1961905_i_deogrammic
ideograph1646485_i_deograph__
ideographies1955775_i_deographies
ideographs1746785_i_deograph_s
ideography2046215_i_deograph_y
kymographic2845735__kymographic
lexicographic3062805lexicographic
logograph1646585_log_ograph__
logographs1746925_log_ograph_s
lymphographic3153105lymphographic
mammographic2354185_mammographic
micrographics2555645mi_crographics
mimeograph2054545mi_meograph__
mimeographed2353735mi_meographed
mimeographing2462275mi_meographing
mimeographs2184765mi_meograph_s
oceanographic2353405oceanographic
oleograph1547365__oleograph__
oleographs1647855__oleograph_s
orthographic2355635_orthographic
pantographic2256585_pantographic
petrographic2278025_petrographic
phlebographic2853655phlebographic
physiographic2954645physiographic
planographic2255465_planographic
polarographic2394135polarographic
polygraphic2464715_po_lygraphic
radiographic2156365_radiographic
renographic1947405__renographic
reprographic2296655_reprographic
scenographic2275195_scenographic
seismographic2373785seismographic
stenographic2055905_stenographic
telegraphic1954935_tele_graphic
thermographic2655655thermographic
typographic2456455__typographic
videographer2254325vi_deographer
videographies2354425vi_deographies
videography2454435vi_deograph_y
xerographic2667925__xerographic
xylographic2946105__xylographic
zoogeographers3062375zoogeographers

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 Filter1786911247900.390458182.1
2DLD Change Limit1247901268.25015126.1
3Display Results1261260.0931354.8
 (SQL Overall)1786911268.73320461.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.