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

156 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
paleographers2111424(None) 
paleographer20115731paleographer_
paleographies2155732paleographies
calligraphers2162223calligraphers
cartographers2194463cartographers
geographers1854783__geographers
hagiographers2353743hagiographers
holographers2166223hol_ographers
paleographic2276553paleograph_ic
paleography2246173paleograph__y
paragraphers2093033pa_ragraphers
petrographers2155073petrographers
phonographers2465803phonographers
photographers2457173photographers
polygraphers2353403pol_ygraphers
pornographers2164493pornographers
telegraphers1853793tele_graphers
videographers2353403videographers
xylographers2853813xyl_ographers
allographs1648064_allograph__s
bibliographers2462534bibliographers
biogeographers2382914biogeographers
biographers19155114__biographers
calligrapher2052584calligrapher_
cartographer2096114cartographer_
chirographers2494694chirographers
choreographers2594534choreographers
chorographers24106124chorographers
cosmographers2353594cosmographers
demographers2154564_demographers
discographers2253194discographers
ethnographers2293584ethnographers
geographer1746164__geographer_
hagiographer2255014hagiographer_
holographer2088394hol_ographer_
hydrographers2654164hydrographers
iconographers2153634iconographers
lithographers2253904lithographers
metallographers2371844metallographers
mythographers2793634mythographers
oleographs1647854_oleograph__s
paleographical2463664paleographical
pantographs1946574pantograph__s
paragrapher1973654pa_ragrapher_
petrographer2057284petrographer_
phlebographies2763304phlebographies
phonographer2347864phonographer_
photographer2349694photographer_
physiographers2863404physiographers
planographies2164884planographies
polygrapher2254064pol_ygrapher_
pornographer2056014pornographer_
reprographers2154664reprographers
scenographers2173634scenographers
stenographers19104094stenographers
telegrapher1754504tele_grapher_
topographers2055074_topographers
typographers2354074_typographers
videographer2254324videographer_
xylographer2754834xyl_ographer_
zoogeographers3062374zoogeographers
allograph1547535_allograph___
allographic1947435_allograph_ic
altigraphs1654315_altigraph__s
altogethers1551355_altog_ethers
anemographs1955415_anemograph__s
autographed1856155_autographe_d
autographies1856955_autographies
autographs1648735_autograph__s
barographs1847075ba_rograph__s
bibliographer2362945bibliographer_
biogeographer2273585biogeographer_
biographees19124535__biographees
biographer18126515__biographer_
bolographs1867535bol_ograph__s
cacographies2255725ca_cographies
calligraphies2153195calligraphies
cartographies2156045cartographies
chirographer23106065chirographer_
choreographer2495745choreographer_
chorographer23118245chorographer_
cosmographer2254885cosmographer_
cryptographers2762915cryptographers
demographer2046375_demographer_
discographer2154165discographer_
epigraphers1953405__epigraphers
ethnographer2184785ethnographer_
filmographies2454305filmographies
flexographies2953545_flexographies
geographies1856615__geographies
glossographers2161765glossographers
hagiographies2354925hagiographies
heliographed2275515heliographe_d
heliographs2047125heliograph__s
holographed21107625hol_ographe_d
holographies2148125hol_ographies
holographs1979985hol_ograph__s
hydrographer2555805hydrographer_
iconographer2054895iconographer_
ideographies1955775_ideographies
ideographs1746785_ideograph__s
lexicographers29172195lexicographers
lithographer2155025lithographer_
mammographies2253565mammographies
metallographer2262335metallographer_
mimeographed2353735mimeographe_d
mimeographs2184765mimeograph__s
mythographer26124515mythographer_
oceanographers2262295oceanographers
oleograph1547365_oleograph___
palsgraves1651935pal_sgra_ve_s
pantograph1847065pantograph___
pantographic2256585pantograph_ic
paragraphed2083305pa_ragraphe_d
paragraphs1844845pa_ragraph__s
petrographies2157145petrographies
phlebographic2853655phlebograph_ic
phlebography2853615phlebograph__y
phonographies2447475phonographies
phonographs2248905phonograph__s
photographed2458665photographe_d
photographies2459415photographies
photographs22411475photograph__s
physiographer2754345physiographer_
pictographies2355635pictographies
pictographs2146555pictograph__s
planographic2255465planograph_ic
planography2255165planograph__y
pleathers1446455p_le___athers
polarographies2253535polarographies
polygraphed2353615pol_ygraphe_d
polygraphs2145305pol_ygraph__s
pornographies2165965pornographies
programers1584405p__rogra_mers
programmers1893535p__rogrammers
radiographed2065125radiographe_d
radiographies2055825radiographies
radiographs1856525radiograph__s
reprographer2056255reprographer_
scenographer2064705scenographer_
seismographers22142685seismographers
serigraphers1853575_serigraphers
stenographer1875305stenographer_
telegraphed1853865tele_graphe_d
telegraphese1852475tele_graphese
telegrapheses1961685tele_grapheses
telegraphies1854775tele_graphies
telegraphs1645195tele_graph__s
thermographers2553685thermographers
topographer1946695_topographer_
typographer2255345_typographer_
videographies2354425videographies
xylographed2854225xyl_ographe_d
xylographies2855265xyl_ographies
xylographs2645665xyl_ograph__s
zoogeographer2962785zoogeographer_

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.390458182.1
2DLD Change Limit1247901568.65614416.6
3Display Results1561560.0931677.4
 (SQL Overall)1786911569.13919552.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.