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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

101 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
zoogeographic315318(None) 
biogeographic2453952biogeographic
zoogeographer2962782zoogeographer
zoogeographical332134492zoogeographical
zoogeographies301864572zoogeographies
zoogeography3152972zoogeograph_y
choreographic2655873choreographic
geographic1947753___geographic
logographic2047063_log_ographic
zoogeographers3062373zoogeographers
angiographic2155254_angiographic
aortographic2056454_aortographic
biogeographer2273584biogeographer
biogeographical2682734biogeographical
biogeographies2353354biogeographies
biogeography2453714biogeograph_y
chorographic2548554cho_rographic
cosmographic2455784_cosmographic
hagiographic2495724_hagiographic
holographic2269524_ho_lographic
homographic24410074_ho_mographic
iconographic2255614ico_nographic
ideographic2056874__ideographic
monographic2148554_mo_nographic
nomographic2147924_no_mographic
orographic1849074__o_rographic
orthographic2355634_orthographic
paleogeographic2691794paleogeographic
paleographic2276554_paleographic
phonographic2548434pho_nographic
photographic25410314pho_tographic
phytogeographic3292244phytogeographic
polarographic2394134polarographic
pornographic2286654_pornographic
stereographic2154884stereographic
tomographic2148774_to_mographic
topographic2167714_to_pographic
zoomorphic2854434zoo_mo_r_phic
allographic1947435__allographic
autobiographic2462785autobiographic
autographic1948045__autographic
barographic2146565__barographic
bibliographic2553295bibliographic
biogeographers2382915biogeographers
biographic2047445___biographic
cardiographic2454215cardiographic
cartographic2266755_cartographic
chirographic2556375_chirographic
choreograph2256155choreograph__
choreographed25104825choreographed
choreographer2495745choreographer
choreographies2555275choreographies
choreographing2663295choreographing
choreographs2356195choreograph_s
choreography2656005choreograph_y
chronographic2655515chronographic
cryptographic2864465cryptographic
demographic2247865__demographic
discographic2354665_discographic
ethnographic2355315_ethnographic
flexographic3063995_flexographic
fluorographic24113225fluorographic
geographer1746165___geographer
geographical2164535___geographical
geographies1856615___geographies
geography1946455___geograph_y
heliographic2356945_heliographic
hydrographic2756365_hydrographic
idiographic2046795__idiographic
kymographic2845735__kymographic
lexicographic3062805lexicographic
lithographic2355695_lithographic
logograph1646585_log_ograph__
logographs1746925_log_ograph_s
lymphographic3153105lymphographic
mammographic2354185_mammographic
micrographic2467125_micrographic
oceanographic2353405oceanographic
oleograph1547365__oleograph__
oleographs1647855__oleograph_s
pantographic2256575_pantographic
petrographic2278025_petrographic
phlebographic2853655phlebographic
physiographic2954645physiographic
pictographic2456385_pictographic
planographic2255465_planographic
polygraphic2464715_po_lygraphic
radiographic2156365_radiographic
renographic1947405__renographic
reprographic2296655_reprographic
scenographic2275195_scenographic
seismographic2373785seismographic
stenographic2055905_stenographic
telegraphic1954935_tele_graphic
thermographic2655655thermographic
typographic2456455__typographic
xerographic2667925__xerographic
xylographic2946105__xylographic
zoographies2645805z_o__ographies
zoography2745665z_o__ograph_y
zygomorphic332585665zygomo_r_phic

Search took 10 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 Limit1247901018.98313891.8
3Display Results1011010.0631603.2
 (SQL Overall)1786911019.18619452.5
 
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.