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

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

147 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
holographer208839(None) 
holographed21107621holographed
holographers2166221holographers
chorographer23118242chorographer
holograph1879662holograph__
holographic2269522holographic
holographies2148122holographies
holographs1979982holograph_s
holography2278612holograph_y
phonographer2347862phonographer
photographer2349692photographer
polygrapher2254062polygrapher
topographer1946692topographer
xylographer2754832xylographer
biographer18126513_biographer
bolograph1767293bolograph__
bolographs1867533bolograph_s
chirographer23106063chirographer
choreographer2495743choreographer
chorographers24106123chorographers
cosmographer2254883cosmographer
demographer2046373demographer
geographer1746163_geographer
hagiographer2255013hagiographer
heliographed2275513heliographed
holographing2275043holographing
homograph20810413homograph__
homographic24410073homographic
homographs21710543homograph_s
hydrographer2555803hydrographer
iconographer2054893iconographer
monographed2046553monographed
paleographer20115733paleographer
phonographers2465803phonographers
photographed2458663photographed
photographers2457173photographers
polygraphed2353613polygraphed
polygraphers2353403polygraphers
pornographer2056013pornographer
telegrapher1754503telegrapher
topographers2055073topographers
typographer2255343typographer
xylographed2854223xylographed
xylographers2853813xylographers
allograph1547534allograph__
allographic1947434allographic
allographs1648064allograph_s
autographed1856154autographed
bibliographer2362944bibliographer
biogeographer2273584biogeographer
biographee18155544_biographee
biographers19155114_biographers
calligrapher2052584calligrapher
cartographer2096114cartographer
chirographers2494694chirographers
choreographed25104824choreographed
choreographers2594534choreographers
chorographic2548554chorographic
chorographies2487434chorographies
chorography2548454chorograph_y
cosmographers2353594cosmographers
demographers2154564demographers
discographer2154164discographer
epigrapher1854064_epigrapher
ethnographer2184784ethnographer
geographers1854784_geographers
glossographer2062164glossographer
hagiographers2353744hagiographers
hectographed2454544hectographed
heliograph1946904heliograph__
heliographic2356944heliographic
heliographs2047124heliograph_s
hologamies1645874holog_amies
hologram1448104hologra___m
holograms1547364hologra__ms
hoorahed1545094ho_o_ra_hed
hydrographers2654164hydrographers
iconographers2153634iconographers
lithographer2155024lithographer
logograph1646584logograph__
logographic2047064logographic
logographs1746924logograph_s
monogrammer1553024monogrammer
monograph1748644monograph__
monographic2148554monographic
monographs1848884monograph_s
mythographer26124514mythographer
nomograph1787544nomograph__
nomographic2147924nomographic
nomographies20126604nomographies
nomographs1877804nomograph_s
nomography2166804nomograph_y
odograph1577334_odograph__
odographs1667344_odograph_s
oleograph1547364_oleograph__
oleographs1647854_oleograph_s
orographic1849074_orographic
orographies1767794_orographies
orography1847954_orograph_y
paleographers21114244paleographers
paragrapher1973654paragrapher
petrographer2057284petrographer
phonograph2148814phonograph__
phonographic2548434phonographic
phonographies2447474phonographies
phonographs2248904phonograph_s
phonography2568304phonograph_y
photograph21411014photograph__
photographic25410314photographic
photographies2459414photographies
photographs22411474photograph_s
photography25410074photograph_y
physiographer2754344physiographer
polygraph2045104polygraph__
polygraphic2464714polygraphic
polygraphs2145304polygraph_s
pornographers2164494pornographers
reprographer2056254reprographer
scenographer2064704scenographer
serigrapher1754464serigrapher
sonographies1846614sonographies
sonography1947204sonograph_y
stenographer1875304stenographer
telegraphed1853864telegraphed
telegraphers1853794telegraphers
thermographer2464884thermographer
tomograph1788714tomograph__
tomographic2148774tomographic
tomographies20127364tomographies
tomographs1889084tomograph_s
tomography2177794tomograph_y
topograph1787484topograph__
topographic2167714topographic
topographies20116934topographies
topographs1888044topograph_s
topography2177094topograph_y
typographed2354684typographed
typographers2354074typographers
videographer2254324videographer
xylograph2545134xylograph__
xylographic2946104xylographic
xylographies2855264xylographies
xylographs2645664xylograph_s
xylography2945004xylograph_y
zoogeographer2962784zoogeographer
zoographies2645804zo_ographies
zoography2745664zo_ograph_y

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 Filter1786911488190.420425454.8
2DLD Change Limit1488191479.22016140.9
3Display Results1471470.0761934.2
 (SQL Overall)1786911479.71618391.4
 
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.