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

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

99 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
pectoral12121050(None) 
pectorals13128151pectorals
sectoral10109541sectoral
doctoral1146302doctoral
electoral1156732electoral
pastoral10310482pastoral
peroral9314792pe_roral
peytral1287502peyt_ral
pictorial1348402pictorial
postoral10311722postoral
rectorial11119892rectorial
restoral8810982restoral
sectorial111110012sectorial
spectral12246192spect_ral
tectorial11119032tectorial
vectorial14147402vectorial
apertural1144093apertural
auctorial11117323auctorial
bestowal1344513bestowal
central93114473cent_ral
choral115118493__choral
clitoral10106463clitoral
coral76033453__c_oral
dentural948083dentural
dextral1577003dext_ral
doctorial1246693doctorial
ecotonal1046253_ecotonal
ectypal1442773_ectypal
enteral73516443_enteral
enthral103410933_enthral
ephoral1248403_ephoral
estral64716513_est_ral
factorial1447033factorial
femoral1238723fe_moral
gestural946033gestural
hectical1547933hectical
hectogram17115813hectogram
hector113312653hector__
hectored1436883hectored
hectors123513263hector_s
lector83514993lector__
lectors93415773lector_s
litoral7610763_litoral
littoral845273littoral
nectarial1147103nectarial
neutral737923neut_ral
pastorale1147323pastorale
pastorali1146243pastorali
pastorals1147953pastorals
pastural1038413pastural
pedocal1237893pe_docal
pentosan1045733pentosan
personal102311573personal
petal76526893pe_t__al
petrale9312623pe_t_rale
petrel83111533pe_t_rel
petrol82714063pe_t_rol
petrosal1047153petrosal
peytrals1355493peyt_rals
peytrel1264253peyt_rel
picloram1445913picloram
pictogram1645163pictogram
pictorials1445493pictorials
plectra1145793plect_ra_
postural1049203postural
predoctoral1663133predoctoral
premoral1249713premoral
preoral9312673p_reoral
pretorial11512653pretorial
proctorial1447513proctorial
protectoral1554933protectoral
recoal84117973rec_o_al
rectal84418133rect__al
rector84019753rector__
rectorate11411373rectorate
rectors93520523rector_s
rectory123512733rector_y
restorals978073restorals
retotal739843re_total
retral64419743re_t_ral
seconal9310073sec_onal
sectional1149423sectional
sector83415933sector__
sectored1138073sectored
sectorials1286523sectorials
sectors93116453sector_s
spectra11275833spect_ra_
suctorial11117723suctorial
tectal83713253tect__al
teetotal844533teetotal
temporal1246333temporal
tentorial9119603tentorial
textural1544943textural
vector113212063vector__
vectored1435633vectored
vectors123212593vector_s
ventral103612173vent_ral
vestral104111013vest_ral
vestural1156473vestural

Search took 9 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 Filter1786911461620.423422437.4
2DLD Change Limit146162997.62619166.3
3Display Results99990.0462152.2
 (SQL Overall)178691998.09522074.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.