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

85 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
vectorially195390(None) 
pictorially1854812pictorially
vectorial14147402vectoria_l_
bacterially18114973bacterially
ectopically2047123_ectopically
editorially1554263editorially
electorally1654273elector_ally
hectoringly2052443hectoringly
inventorially1962683inventorially
memorially1745653me_morially
rectorial11119893rectoria_l_
sartorially1454413sartorially
sectorial111110013sectoria_l_
sectorials1286523sectoria_ls
sensorially1454093sensorially
tectonically1946323tectonically
tectorial11119033tectoria_l_
tinctorially1752443tinctorially
ventrally1547253vent_r_ally
vestigially1852403vestigially
actuarially16102314_actuarially
aerially11911914ae___rially
armorially1544924_armorially
arterially1347354_arterially
auctorial11117324auctoria_l_
bestially1447054best__ially
centrally1448904cent_r_ally
centrically1848234cent_rically
chorally1638104__chor_ally
cordially1547484__c_ordially
decennially1753184decennially
dextrally2045114dext_r_ally
dictatorially1961834dictatorially
doctorial1246694doctoria_l_
doctrinally1753554doct_rinally
electrically1965684elect_rically
enterally12410014_enter_ally
eternally1247494_e_ternally
externally2045544_externally
factorial1447044factoria_l_
factorials1544714factoria_ls
gesturally1443434gestur_ally
hectically2049604hect_ically
historically2056464historically
materially1548014_materially
mercurially1852864mercurially
meteorically1956814meteorically
metrically17411084me_t_rically
motorically1849434_motorically
nectarial1147104nectaria_l_
neutrally1246344neut_r_ally
nocturnally1652424nocturnally
notarially1344684_notarially
oratorically1756374oratorically
pastorally1565444pastor_ally
pectoral121210504pector_a_l_
pectorals13128154pector_a_ls
perorally1448224pe_ror_ally
pictorial1348404pictoria_l_
pictorials1445494pictoria_ls
rectally1339714rect___ally
reportorially1861874reportorially
retrally11310524re_t_r_ally
rhetorically2065864rhetorically
sectionally1646824sectionally
sectoral10109544sector_a_l_
serially11912844se___rially
spectrally1744854spect_r_ally
suctorial11117724suctoria_l_
teetotally1353764teeto_tally
temporally1744224tempor_ally
tentorial9119604tentoria_l_
tenurially1344084te_nurially
territorially1662964territorially
texturally2043854textur_ally
uxorially1944054__uxorially
vectoring1537414vectori__ng
venially1499424ve___nially
verbally1647184ve___rbally
vernally1447824ve___rnally
vertically18410934vert_ically
vestally1437414vest___ally
victoria1346334victoria___
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.436409841.7
2DLD Change Limit148819859.08016389.8
3Display Results85850.0461847.8
 (SQL Overall)178691859.56218687.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.