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

97 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
phytogeographer307237(None) 
phytogeographic3292242phytogeographic
phytogeography3262732phytogeograph_y
biogeographer2273584__biogeographer
choreographer2495744ch__oreographer
phonographer2347864ph__o_nographer
photographer2349694ph__o_tographer
physiographer2754344phy__siographer
zoogeographer2962784__zoogeographer
autobiographer2262565_autobiographer
biogeographers2382915__biogeographers
choreographed25104825ch__oreographed
choreographers2594535ch__oreographers
chorographer23118245ch__o_rographer
geographer1746165_____geographer
hagiographer2255015_h__agiographer
historiographer2471935historiographer
holographer2088395_h__o_lographer
hydrographer2555805_hy__drographer
mythographer26124515_myt__hographer
paleogeographic2691795paleogeographic
paleogeography2682205paleogeograph_y
paleographer20115735p___aleographer
petrographer2057285p_et__rographer
phonographers2465805ph__o_nographers
photoengraver2282315photo_engra_ver
photographed2458665ph__o_tographed
photographers2457175ph__o_tographers
physiographers2863405phy__siographers
pornographer2056015p___ornographer
topographer1946695___to_pographer
zoogeographers3062375__zoogeographers
autobiographers2372046_autobiographers
biogeographic2453956__biogeographic
biogeographies2353356__biogeographies
biogeography2453716__biogeograph_y
cartographer2096116cart___ographer
chirographer23106066ch___irographer
choreograph2256156ch__oreograph__
choreographic2655876ch__oreographic
choreographies2555276ch__oreographies
choreographs2356196ch__oreograph_s
choreography2656006ch__oreograph_y
chorographers24106126ch__o_rographers
chromatographer28213586chromatographer
cosmographer2254886___cosmographer
cryptographer2663746cry__ptographer
ethnographer2184786__et_hnographer
geographers1854786_____geographers
glossographer2062166__glossographer
hagiographers2353746_h__agiographers
holographed21107626_h__o_lographed
holographers2166226_h__o_lographers
hydrographers2654166_hy__drographers
hygrograph2355446_hy__grograph__
hygrographs2455506_hy__grograph_s
iconographer2054896__ico_nographer
lithographer2155026_lit__hographer
metallographer2262336_metallographer
mythographers2793636_myt__hographers
paleographers21114246p___aleographers
petrographers2155076p_et__rographers
phonograph2148816ph__o_nograph__
phonographic2548436ph__o_nographic
phonographies2447476ph__o_nographies
phonographs2248906ph__o_nograph_s
phonography2568306ph__o_nograph_y
photoengrave2172816photo_engra_ve_
photoengraved2382136photo_engra_ved
photoengravers2391666photo_engra_vers
photoengraves2292706photo_engra_ves
photograph21411016ph__o_tograph__
photographic25410316ph__o_tographic
photographies2459416ph__o_tographies
photographs22411476ph__o_tograph_s
photography25410076ph__o_tograph_y
phototelegraphy2981696phototelegraph_y
physiographic2954646phy__siographic
physiographies2854196phy__siographies
physiography2954496phy__siograph_y
polygrapher2254066p___o_lygrapher
pornographers2164496p___ornographers
rechoreographed27102246rechoreographed
sphygmograph2962106sphy__gmograph__
sphygmographs3061996sphy__gmograph_s
stenographer1875306__st_enographer
stereographed2053906__stereographed
telegrapher1754506___tele_grapher
thermographer2464886th__ermographer
topographers2055076___to_pographers
typographer2255346___t_ypographer
unchoreographed2771696unchoreographed
videographer2254326___videographer
xylographer2754836_xy___lographer
zoogeographic3153186__zoogeographic
zoogeographies301864576__zoogeographies
zoogeography3152976__zoogeograph_y

Search took 8 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.343520965.0
2DLD Change Limit95024977.08013421.5
3Display Results97970.0601616.7
 (SQL Overall)178691977.48323879.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.