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

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

142 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
phytogeographic3292241phytogeographic_
phytogeographer3072373phytogeograph_er
phytogeography3262733phytogeograph__y
paleogeographic2691794paleogeographic_
biogeographic2453955__biogeographic_
biogeographical2682735__biogeographical
choreographic2655875ch__oreographic_
phonographic2548435ph__o_nographic_
photographic25410305ph__o_tographic_
physiographic2954645phy__siographic_
physiographical3172855phy__siographical
zoogeographic3153185__zoogeographic_
zoogeographical332134495__zoogeographical
autobiographic2462786_autobiographic_
biogeographies2353356__biogeographies
choreographies2555276ch__oreographies
choreographing2663286ch__oreographing
chorographic2548556ch__o_rographic_
chronographic2655516ch_ro_nographic_
geographic1947756_____geographic_
geographical2164536_____geographical
hagiographic2495726_h__agiographic_
hagiographical2663216_h__agiographical
historiographic2672046historiographic_
holographic2269526_h__o_lographic_
homographic24410076_h__o_mographic_
hydrographic2756356_hy__drographic_
logographic2047066___log_ographic_
paleogeography2682206paleogeograph__y
paleographic2276556p___aleographic_
paleographical2463656p___aleographical
pantographic2256576pant___ographic_
petrographic2278026p_et__rographic_
petrographical2463876p_et__rographical
phlebographic2853656ph__lebographic_
phonographies2447466ph__o_nographies
photographies2459386ph__o_tographies
photographing2565976ph__o_tographing
physiographies2854196phy__siographies
pictographic2456386pict___ographic_
pornographic2286656p___ornographic_
stereographic2154886__stereographic_
tomographic2148776___to_mographic_
topographic2167716___to_pographic_
topographical2354216___to_pographical
zoogeographies301864576__zoogeographies
angiographic2155257___angiographic_
aortographic2056457___aortographic_
arteriographic2272817_arteriographic_
autobiographies2362337_autobiographies
autographic1948047_aut___ographic_
biogeographer2273587__biogeograph_er
biogeographers2382917__biogeographers
biogeography2453717__biogeograph__y
cartographic2266757cart___ographic_
cartographical2463337cart___ographical
chirographic2556377ch___irographic_
chirographical2783507ch___irographical
choreograph2256157ch__oreograph___
choreographed25104827ch__oreograph_ed
choreographer2495747ch__oreograph_er
choreographers2594537ch__oreographers
choreographs2356197ch__oreograph__s
choreography2656007ch__oreograph__y
chorographies2487437ch__o_rographies
chromatographic3073437chromatographic_
chronographies2574927ch_ro_nographies
cosmographic2455787___cosmographic_
cosmographical2693327___cosmographical
cryptographic2864467cry__ptographic_
ethnographic2355317__et_hnographic_
ethnographical2563207__et_hnographical
fluorographic24113227_fluo_rographic_
geographies1856617_____geographies
hagiographies2354927_h__agiographies
heliographic2356947_h__eliographic_
holographies2148117_h__o_lographies
holographing2275047_h__o_lographing
hydrographies2675777_hy__drographies
hygrograph2355447_hy__grograph___
hygrographs2455507_hy__grograph__s
hypomorphic2854827_hypo_mo_r_phic_
iconographic2255617__ico_nographic_
iconographical2463287__ico_nographical
ideographic2056877____ideographic_
kymographic2845737_ky___mographic_
lithographic2355697_lit__hographic_
lymphographic3153097_ly_mphographic_
metallographic2462417_metallographic_
monographic2148557___mo_nographic_
mythographies2754557_myt__hographies
nomographic2147927___no_mographic_
orographic1849077____o_rographic_
orographical2054397____o_rographical
orthographic2355637_ort__hographic_
orthographical2563057_ort__hographical
paleographies2155737p___aleographies
petrographies2157147p_et__rographies
phlebographies2763307ph__lebographies
phonogramic2154567ph__o_nogra_mic_
phonogrammic2452677ph__o_nogrammic_
phonograph2148807ph__o_nograph___
phonographer2347867ph__o_nograph_er
phonographers2465797ph__o_nographers
phonographs2248907ph__o_nograph__s
phonography2568307ph__o_nograph__y
photoengraving24112117photo_engra_ving
photogeologic2263687photogeo__logic_
photogeological2463057photogeo__logical
photograph21411017ph__o_tograph___
photographed2458657ph__o_tograph_ed
photographer2349687ph__o_tograph_er
photographers2457167ph__o_tographers
photographs22411467ph__o_tograph__s
photography25410077ph__o_tograph__y
phototelegraphy2981697phototelegraph__y
physiographer2754347phy__siograph_er
physiographers2863407phy__siographers
physiography2954497phy__siograph__y
pictographies2355637pict___ographies
planographic2255467p___lanographic_
polarographic2394137p__olarographic_
polygraphic2464717p___o_lygraphic_
pornographies2165967p___ornographies
prosopographies2262087proso_pographies
spectrographic2662877spect__rographic_
sphygmograph2962107sphy__gmograph___
sphygmographs3061997sphy__gmograph__s
stenographic2055907__st_enographic_
stereographies2054247__stereographies
stereographing21112427__stereographing
telegraphic1954937___tele_graphic_
thermographic2655657th__ermographic_
tomographies20127357___to_mographies
topographies20116937___to_pographies
typographic2456457___t_ypographic_
typographical2663897___t_ypographical
xylographic2946107_xy___lographic_
xylographical3163577_xy___lographical
zoogeographer2962787__zoogeograph_er
zoogeographers3062377__zoogeographers
zoogeography3152977__zoogeograph__y

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 Filter178691950240.1231452772.4
2DLD Change Limit950241428.70310918.5
3Display Results1421420.1101290.9
 (SQL Overall)1786911428.93619996.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.