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

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

83 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
pictorially185481(None) 
pictorial1348402pictoria_l_
pictorials1445492pictoria_ls
tinctorially1752442tinctorially
vectorially1953902vectorially
bacterially18114963bacterially
dictatorially1961833dictatorially
editorially1554263editorially
historically2056463historically
pastorally1565443pastor_ally
pictorialism1864953pictorialism
pictorialist1675373pictorialist
pictorialize2553583pictorialize
sartorially1454413sartorially
actuarially16102314_actuarially
armorially1544924_armorially
arterially1347334_arterially
auctorial11117314auctoria_l_
binomially1753664bi_nomially
biosocially1852744biosocially
chorally1638104__chor_ally
cordially1547474__c_ordially
diatonically1856024diatonically
dichotically2356224dichotically
dictionally1755974dictionally
doctorial1246694doctoria_l_
doctrinally1753554doct_rinally
ectopically2047124_ectopically
electorally1654264elector_ally
epitaxially2351994epi_taxially
factorial1447024factoria_l_
factorials1544694factoria_ls
fictionally1956054fictionally
hectoringly2052444hectoringly
iconically1769274_ic_onically
immorally1645164_immor_ally
immortally1753844_immortally
imperially1746844_imperially
informally1844464_informally
internally13410094_internally
lictorian1166604lictoria__n
literally1248344li_ter_ally
materially1548004_materially
memorially1745654_memorially
mitotically1849124mi_totically
motorically1849434_motorically
nocturnally1652424nocturnally
notarially1344684_notarially
oratorically1756374oratorically
partially1449034part__ially
paternally1545864p_aternally
pectoral121210504pector_a_l_
pectorals13128154pector_a_ls
perorally1448214p_eror_ally
pictography2446074pictography
pictorialisms1984584pictorialisms
pictorialists1774114pictorialists
pictorialized2753024pictorialized
pictorializes2653454pictorializes
pictorialness1762524pictorialness
piscatorial1553294piscatoria_l_
pitiably1545844pi_t__iably
pivotally1743644pi_vo_tally
platonically1945904platonically
pretorial11512654pretoria_l_
primordially2061814primordially
proctorial1447514proctoria_l_
rectorial11119894rectoria_l_
reportorially1861874reportorially
rhetorically2065864rhetorically
sectorial111110014sectoria_l_
sectorials1286524sectoria_ls
sensorially1454094sensorially
spectrally1744854spect_r_ally
suctorial11117724suctoria_l_
tectonically1946324tectonically
tectorial11119034tectoria_l_
tinctorial1254394tinctoria_l_
uxorially1944054__uxorially
vectorial14147404vectoria_l_
victoria1346314victoria___
victorias1446524victoria__s
victoriously2053564victoriously

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.1531167915.0
2DLD Change Limit148819839.23616112.9
3Display Results83830.0461804.3
 (SQL Overall)178691839.43518939.2
 
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.