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

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

172 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
pastoring1231085(None) 
pasturing1238431pasturing
factoring1537522factoring
mastering122315302mastering
paltering122612892paltering
pasting103826552past__ing
pastorium1347692pastorium
pattering122314422pattering
pestering122315662pestering
pistoling1268492pistoling
plastering1339242plastering
posturing1238992posturing
prestoring13310302prestoring
restoring10314612restoring
storing83921122__storing
adoring9412523_a_doring
altering91917113_altering
armoring1149123_armoring
aspiring1138873_aspiring
assorting1037303_assorting
assuring937773_assuring
astonying1345233_astonying
astringe938223_ast_ringe
atoning83514873_a_toning
attiring939483_attiring
attorning1045503_attorning
authoring1348583_authoring
autoing8314043_auto_ing
bantering122414233bantering
bartering122313643bartering
basting104227203bast__ing
battering122715143battering
bestowing1535803bestowing
cantering122417373cantering
cantoning12310883cantoning
capturing1436623capturing
cartoning12311113cartoning
casting104628343cast__ing
castling11311233cast_ling
catering112019903ca_tering
distorting1239583distorting
doctoring1346183doctoring
easting84924303east__ing
faltering132211113faltering
fastening13268603fastening
fasting114522833fast__ing
favoring1596673fa_voring
festering132413173festering
fostering132411253fostering
gartering112111573gartering
gasting95022763gast__ing
gastrin839833gast_rin_
gastrins9310123gast_rins
gesturing1136653gesturing
haltering132212003haltering
hamstring1546003hamst_ring
harboring1538263harboring
hastening13259483hastening
hasting114725193hast__ing
hectoring1538303hectoring
kashering1736253kashering
laboring112110143la_boring
lassoing946383lasso_ing
lasting84725243last__ing
lustering102711203lustering
lustring9269723lust_ring
majoring1836363ma_joring
martyring1535783martyring
masoning1139763mas_oning
masting104325823mast__ing
mattering122314053mattering
maturing1139953ma_turing
mentoring1239543mentoring
motoring11410953_motoring
mustering122212333mustering
nattering102212213nattering
oystering1337553oystering
pairing103716733pa__iring
pampering1638383pampering
pandering133211963pandering
panting104025423pant__ing
papering132213313pa_pering
pardoning1338763pardoning
paring94236493pa___ring
paroling113316213pa_roling
parring103222063pa__rring
parroting1239153parroting
partaking1698673partaking
parting103527383part__ing
partnering1345553partnering
partying14168893part_ying
pashing135120513pas__hing
passaging1345613passaging
passerine1147083passerine
passing104318423pas__sing
pastern94415063paster_n_
pasterns104112623paster_ns
pastina93914593past__ina
pastor84817483pastor___
pastoral10310483pastor_al
pastorale1147313pastorale
pastorali1146243pastorali
pastorals1147953pastorals
pastorate11411173pastorate
pastored1139963pastor_ed
pastoriums1445553pastoriums
pastorly1345783pastor_ly
pastors94119003pastor__s
pastries101517423past_ries
patching163212753pa_tching
patining11312303pa_tining
patterning1346073patterning
patting103722343pa_t_ting
paupering1437273paupering
peltering122011673peltering
pestling111010253pest_ling
petering112516813p_etering
photoing1439063photo_ing
picturing1436033picturing
pistolling1345353pistolling
plaistering1444603plaistering
plasterings1444743plasterings
poring94227273p___oring
portering122012303portering
postforming1953263postforming
posting105622243post__ing
postponing1555743postponing
postposing1555023postposing
pottering122612003pottering
prescoring1547433prescoring
proctoring1546673proctoring
puttering122611643puttering
rapturing1245353rapturing
razoring1836443ra_zoring
rescoring12310603rescoring
restoking1438193restoking
restring91518783rest_ring
savoring1269483sa_voring
scoring103117213__scoring
sectoring1239583sectoring
shoring112820063__shoring
sistering101213753sistering
snoring83917203__snoring
soring74731883__s_oring
spattering13107793spattering
sporing104319413__sporing
staring84527053__staring
stoking123615593__stoking
stoning83717443__stoning
stoping103716623__stoping
storming11209423__storming
storying12249673__storying
stowing113315133__stowing
string75327563__st_ring
taboring113010193ta_boring
tailoring1036403tailoring
tasting84624213tast__ing
tattering102212323tattering
tattooing1043963tattooing
tutoring938433_tutoring
unstring9312093unst_ring
upstaring1235963upstaring
vaporing1437653va_poring
vectoring1537413vectoring
vesturing1337203vesturing
visoring1238373vis_oring
waitering13310713waitering
wantoning1337083wantoning
wasting114422843wast__ing
watering122316313wa_tering
westering132112643westering
yattering132410443yattering

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 Filter1786911486410.1731032896.0
2DLD Change Limit1486411728.12318298.8
3Display Results1721720.0802150.0
 (SQL Overall)1786911728.37621333.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.