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]

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

46 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_
photographic25410315ph__o_tographic_
physiographic2954645phy__siographic_
physiographical3172855phy__siographical
zoogeographic3153185__zoogeographic_
zoogeographical332134495__zoogeographical
autobiographic2462786_autobiographic_
biogeographies2353356__biogeographies
choreographies2555276ch__oreographies
choreographing2663296ch__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_
hydrographic2756366_hy__drographic_
logographic2047066___log_ographic_
paleogeography2682206paleogeograph__y
paleographic2276556p___aleographic_
paleographical2463656p___aleographical
pantographic2256576pant___ographic_
petrographic2278026p_et__rographic_
petrographical2463886p_et__rographical
phlebographic2853656ph__lebographic_
phonographies2447476ph__o_nographies
photographies2459416ph__o_tographies
photographing2565986ph__o_tographing
physiographies2854196phy__siographies
pictographic2456386pict___ographic_
pornographic2286656p___ornographic_
stereographic2154886__stereographic_
tomographic2148776___to_mographic_
topographic2167716___to_pographic_
topographical2354216___to_pographical
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.0931921408.6
2DLD Change Limit65874464.40614951.0
3Display Results46460.0461000.0
 (SQL Overall)178691464.54539316.0
 
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.