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

92 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
paleogeographic269179(None) 
paleogeography2682202paleogeograph_y
paleographic2276553pal___eographic
phytogeographic3292243phytogeographic
biogeographic2453954__biogeographic
logographic2047064__l_og_ographic
phlebographic2853654phle__bographic
zoogeographic3153184__zoogeographic
allographic1947435_al___lographic
angiographic2155255_a__ngiographic
aortographic2056455_a__ortographic
autobiographic2462785_autobiographic
choreographic2655875__choreographic
flexographic3063995_fle__xographic
fluorographic24113225_fluo_rographic
geographic1947755_____geographic
hagiographic2495725ha___giographic
lexicographic3062805__lexicographic
paleographer20115735pal___eographer
paleographical2463655pal___eographical
paleographies2155735pal___eographies
paleography2246175pal___eograph_y
pantographic2256575pa___ntographic
petrographic2278025p__e_trographic
phonographic2548435p__ho_nographic
photographic25410305p__ho_tographic
phytogeographer3072375phytogeographer
phytogeography3262735phytogeograph_y
planographic2255465p_l__anographic
pleomorphic2255035p_leo_mo_r_phic
polarographic2394135pol__arographic
pornographic2286655p___ornographic
stereographic2154885_ste_reographic
allomorphic2054676_allo_mo_r_phic
arteriographic2272816_arteriographic
autographic1948046_a___utographic
barographic2146566ba____rographic
biogeographer2273586__biogeographer
biogeographical2682736__biogeographical
biogeographies2353356__biogeographies
biogeography2453716__biogeograph_y
calligraphic2252876cal___ligraphic
cardiographic2454216ca__rdiographic
cartographic2266756ca___rtographic
chorographic2548556__cho_rographic
chronographic2655516_chro_nographic
cinematographic2772106cinematographic
cosmographic2455786___cosmographic
demographic2247866__de__mographic
ethnographic2355316___ethnographic
halomorphic2354386hal_o_mo_r_phic
heliographic2356946__he_liographic
historiographic2672046historiographic
holographic2269526___ho_lographic
homographic24410076___ho_mographic
iconographic2255616__ico_nographic
ideographic2056876____ideographic
lithographic2355696__l_ithographic
logograph1646586__l_og_ograph__
logographs1746926__l_og_ograph_s
lymphographic3153096__lymphographic
mammographic2354186ma___mmographic
monographic2148556___mo_nographic
nomographic2147926___no_mographic
oceanographic2353406_oce_anographic
orographic1849076____o_rographic
paedomorphic2463926pa_edomo_r_phic
paleobotanic1861716paleo_bo_ta_nic
paleographers21114246pal___eographers
paragraphic2154186pa____ragraphic
phlebographies2763306phle__bographies
phlebography2853616phle__bograph_y
physiographic2954646p__hysiographic
pictographic2456386p___ictographic
polygraphic2464716p___o_lygraphic
radiographic2156366ra___diographic
renographic1947406__re__nographic
reprographic2296656__re_prographic
scenographic2275196_sce__nographic
seismographic2373786__seismographic
spectrographic2662876_spectrographic
stenographic2055906_ste__nographic
telegraphic1954936__te_le_graphic
thermographic2655656_the_rmographic
tomographic2148776___to_mographic
topographic2167716___to_pographic
xerographic2667926__xe__rographic
xylographic2946106xyl____ographic
zoogeographer2962786__zoogeographer
zoogeographical332134496__zoogeographical
zoogeographies301864576__zoogeographies
zoogeography3152976__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 Limit95024928.32611412.9
3Display Results92920.0801150.0
 (SQL Overall)178691928.52920951.0
 
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.