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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

43 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
paleogeographic2691791paleogeographic_
paleogeography2682203paleogeograph__y
paleographic2276554pal___eographic_
paleographical2463664pal___eographical
phytogeographic3292244phytogeographic_
biogeographic2453955__biogeographic_
biogeographical2682735__biogeographical
logographic2047065__l_og_ographic_
paleographies2155735pal___eographies
phlebographic2853655phle__bographic_
zoogeographic3153185__zoogeographic_
zoogeographical332134495__zoogeographical
allographic1947436_al___lographic_
angiographic2155256_a__ngiographic_
aortographic2056456_a__ortographic_
autobiographic2462786_autobiographic_
biogeographies2353356__biogeographies
choreographic2655876__choreographic_
flexographic3063996_fle__xographic_
fluorographic24113226_fluo_rographic_
geographic1947756_____geographic_
geographical2164536_____geographical
hagiographic2495726ha___giographic_
hagiographical2663226ha___giographical
lexicographic3062806__lexicographic_
lexicographical3292216__lexicographical
paleographer20115736pal___eograph_er
paleographers21114246pal___eographers
paleography2246176pal___eograph__y
pantographic2256586pa___ntographic_
petrographic2278026p__e_trographic_
petrographical2463896p__e_trographical
phlebographies2763306phle__bographies
phonographic2548436p__ho_nographic_
photographic25410316p__ho_tographic_
phytogeographer3072376phytogeograph_er
phytogeography3262736phytogeograph__y
planographic2255466p_l__anographic_
pleomorphic2255036p_leo_mo_r_phic_
polarographic2394136pol__arographic_
pornographic2286656p___ornographic_
stereographic2154886_ste_reographic_
zoogeographies301864576__zoogeographies

Search took 5 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 Filter178691658740.313570897.8
2DLD Change Limit65874434.37315063.8
3Display Results43430.0301433.3
 (SQL Overall)178691434.71637890.4
 
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.