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

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

86 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
zoogeographer296278(None) 
zoogeographers3062371zoogeographers
biogeographer2273582biogeographer
zoogeographic3153182zoogeographic
zoogeographies301864572zoogeographies
zoogeography3152972zoogeograph_y
biogeographers2382913biogeographers
choreographer2495743choreographer
geographer1746163___geographer
biogeographic2453954biogeographic
biogeographies2353354biogeographies
biogeography2453714biogeograph_y
choreographed25104824choreographed
choreographers2594534choreographers
chorographer23118244cho_rographer
cosmographer2254884_cosmographer
geographers1854784___geographers
glossographer2062164glossographer
hagiographer2255014_hagiographer
holographer2088394_ho_lographer
iconographer2054894ico_nographer
paleographer20115734_paleographer
phonographer2347864pho_nographer
photographer2349684pho_tographer
phytogeographer3072374phytogeographer
pornographer2056004_pornographer
topographer1946694_to_pographer
videographer2254324_videographer
zoogeographical332134494zoogeographical
autobiographer2262565autobiographer
bibliographer2362945bibliographer
biographer18126515___biographer
cartographer2096115_cartographer
chirographer23106065_chirographer
choreograph2256155choreograph__
choreographic2655875choreographic
choreographies2555275choreographies
choreographs2356195choreograph_s
choreography2656005choreograph_y
chorographers24106125cho_rographers
cosmographers2353595_cosmographers
cryptographer2663745cryptographer
demographer2046375__demographer
discographer2154165_discographer
ethnographer2184785_ethnographer
geographic1947755___geographic
geographies1856615___geographies
geography1946455___geograph_y
glossographers2161765glossographers
hagiographers2353745_hagiographers
holographed21107625_ho_lographed
holographers2166225_ho_lographers
hydrographer2555795_hydrographer
iconographers2153635ico_nographers
lexicographer28152575lexicographer
lithographer2155025_lithographer
logograph1646585_log_ograph__
logographic2047065_log_ographic
logographs1746925_log_ograph_s
mimeographed2353735_mimeographed
monographed2046555_mo_nographed
mythographer26124515_mythographer
oceanographer2162965oceanographer
oleograph1547365__oleograph__
oleographs1647855__oleograph_s
paleographers21114245_paleographers
petrographer2057285_petrographer
phonographers2465795pho_nographers
photographed2458655pho_tographed
photographers2457165pho_tographers
physiographer2754345physiographer
polygrapher2254065_po_lygrapher
pornographers2164485_pornographers
reprographer2056255_reprographer
scenographer2064695_scenographer
seismographer21143405seismographer
stenographer1875305_stenographer
stereographed2053905stereographed
telegrapher1754505_tele_grapher
thermographer2464885thermographer
topographers2055075_to_pographers
typographer2255345__typographer
videographers2353405_videographers
xylographer2754835__xylographer
zoographies2645805z_o__ographies
zoography2745665z_o__ograph_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 Filter1786911247900.1401276364.3
2DLD Change Limit124790868.01615567.6
3Display Results86860.0631365.1
 (SQL Overall)178691868.21921741.2
 
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.